Connecting to mysql

[Former Member]

Hi experts,

I am having JDBC(mysql) to file scenario

The MYSQL team has shared the details .

To import the external definition in ESR i have created the Receiver communication channel with jdbc adapter.

wht the syntax for the connection fleld in jdbc adapter for mysql.

thanks ,

priya

[rajasekhar_reddy14]

Please search in SCN before posting repeated thread. Same discussion answered many times.

[Former Member]

Hi.

The connection for mysql is.

JDBC Driver : com.mysql.jdbc.Driver

Connection : jdbc:mysql://<Server>:<port>/<database>

Port by default = 3306.

Regards

Lucho

[Former Member]

thanks for the reply ,

i used the same thing and i am able to see the table name  in external defination  in ESR

but when i am opening the table its showing the error,

Error when connecting to database.

What shoud be the issue.

thanks

priya

[baskar_gopalakrishnan2]

First check whether you are able to create connection.  You might want to check whether the port is enabled between PI and database server to establish connection. Second thing is to see whether your user credentials are allowed to access that database schema. Check with DBA about user credentials access. I suspect issue could be due to second issue.

[Former Member]

Thnks for the reply,

IN ESR when i am displaying the table in external defination, its showing the all table name . that means connection if fine write ?

But when iam opening the table and click to finish then its showing the error that

"Error when connecting to database"

I am accessing the mysql table ,

waiting for the reply,

thanks

priya.

[former_member192238]

Priya,

Check the blog of Willaim li regarding how to import SQL Tables Metadata

http://scn.sap.com/people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-import-sq...

Regards

Praveen Reddy