Breaking News
Home / Java / Java Issues / SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Issue:

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.) : Cannot create PoolableConnectionFactory (Communications link failure
<!>The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
2011-09-25 01:36:02,979[Thread-17]ERROR JobChangeServiceDao -sql error occured while inserting data for minjbamforth
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory

(BasicDataSource.java:1549)     at org.apache.commons.dbcp.BasicDataSource.createDataSource

(BasicDataSource.java:1388)    at org.apache.commons.dbcp.BasicDataSource.getConnection

(BasicDataSource.java:1044)
at com.infuze.service.linkedin.dao.JobChangeServiceDao.addUser

(JobChangeServiceDao.java:72)     at com.infuze.service.linkedin.workflow.RegisterUserWorkflow.executeProcess

(RegisterUserWorkflow.java:76)     at com.infuze.service.workflow.WorkflowExecutor.execute(WorkflowExecutor.java:24)
at com.infuze.service.linkedin.xml.LinkedInJobAlertXmlService.register

(LinkedInJobAlertXmlService.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.livrona.xhttpi.XHttpInvoker.execute(Unknown Source)
at com.infuze.server.service.XmlServiceActionHandler.execute

(XmlServiceActionHandler.java:28)
at com.livrona.haxe.server.RequestHandler.executeRequest(RequestHandler.java:149)
at com.livrona.haxe.server.RequestHandler.run(RequestHandler.java:77)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Posible Solutions

Most likely the MYSQL Server process is not running or has died or possibly the port specified in your program is not correct or mysql may not be running on the standard port.
[pb_builder]

Check Also

Data truncation: Data too long for column – JDBC

Issue Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘columname‘ at row 1     …

Advertisment ad adsense adlogger