Skip to Content

Unable to mysql data base JDBC channel error

Hello Experts,

From PI i am trying to connect MYSQL database yesturday it worked fine but to day i am facing a new issue as below i check with my data base people they are able to connect the data base.

Error during database connection to the database URL 'jdbc:mysql://xxxxxxx/sglnet' using the JDBC driver 'com.mysql.jdbc.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection timed out STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection timed out at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:116) at com.sap.aii.adapter.jdbc.JDBC2XI.connectDB(JDBC2XI.java:1466) at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:330) at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:523) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago.. : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection timed out STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection timed out at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:116) at com.sap.aii.adapter.jdbc.JDBC2XI.connectDB(JDBC2XI.java:1466) at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:330) at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:523) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago

Please throw some light on the issue any help is high

Regards

Praveen Reddy

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 13, 2011 at 06:16 AM

    Hi,

    Check with your network team, network conenction between PI and Data base not working , Network team have to open Data base system ports inorder connect PI System.

    Talk to Basis or system administrators and check whether your PI server is located within firewall or not. If not then ask them to enable the connectivity

    please go through below thread,

    SQLException: Io exception: The Network Adapter could not establish the con

    regards,

    ganesh.

    Add comment
    10|10000 characters needed characters exceeded