Skip to Content
0
Dec 13, 2011 at 06:13 AM

Unable to mysql data base JDBC channel error

260 Views

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