Communications link failure

[Anonymous]

Hi,
I'm currently following this tutorial: https://help.talend.com/reader/q23BCE3W4MjloHD1RvMJ4A/53ZgjRgRIZBxKLOrSTD_CA?section=mlelandais-2012...
And I am at the 1st step called "save and execute job" but I am encoutering an error and can not figure out how to solve it.. Thanks in advance for the help!

Cordially.

Here are the logs:

Endpoint deployed at: http://localhost:8088/users
[statistics] connecting to socket on port 3456
[statistics] connected
Exception in component tDBOutput_1 (JobWebService)
com.mysql.cj.jdbc.exceptions.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.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at webservicerest.jobwebservice_0_1.JobWebService.tFixedFlowInput_1Process(JobWebService.java:1195)
at webservicerest.jobwebservice_0_1.JobWebService.runJobInTOS(JobWebService.java:3429)
at webservicerest.jobwebservice_0_1.JobWebService.main(JobWebService.java:3278)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
... 8 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
... 11 more
[statistics] disconnected

[vapukov · Accepted solution]

HI,

you have a database connection error, so you need to check:

• do you have a prepared database server (and database and tables)?
• do you use proper credentials?
• do you use proper connection settings?
• can you access this server with this credentials from this PC without Talend?

cheers

[Anonymous]

Hi,

Im facing the same issue.

My job is working fine for 1 yr data, however when i pass 2yrs i get this error.

Appreciate if you can help on this.

[vapukov]

Hi mahadev!

it is not possible to tell exactly what you need to change without knowing your job design!

usually, it happens when you define connection at the begin of the job and use it first time at the end, when a long time delay between opening connection and using it.

the solution could be:

• define connection right before use it
• or use connection settings right in the component

regards, Vlad

[Anonymous]

Hi Vapukov,

Appreciate your response, Will try the DB connection again right before the component and test it.