Error during database connection:

[Former Member]

Hello,

I am getting error while connecting SAP PI to mySQL server.

Error: Could not open connection to jdbc:mysql://172.22.2.94:3306/FNXT0801

I have used the following connection parameter in the JDBC adapter.

JDBC Driver: com.mysql.jdbc.Driver

Connection: jdbc:mysql://172.22.2.94:3306/FNXT0801

Can anybody tell me how to resolve this issue?

Thanks,

Sayanti Mukherjee

[naveen_chichili · Accepted solution]

Hi Sayanti,

This issue comes when network ports were not opened between PI and Database. Please check with you network team.

also check the below links for reference

https://scn.sap.com/message/10257011

and

http://scn.sap.com/people/michal.krawczyk2/blog/2011/12/14/michals-pi-tips-jdbcjms-driver-deployment...

Thanks,

Naveen