Communications link failure

Highlighted
Four Stars

Communications link failure

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


Accepted Solutions
Highlighted
Forteen Stars

Re: Communications link failure

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

-----------

View solution in original post


All Replies
Highlighted
Forteen Stars

Re: Communications link failure

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

-----------

View solution in original post

Highlighted
Four Stars

Re: Communications link failure

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.

Highlighted
Forteen Stars

Re: Communications link failure

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

 

 

-----------
Highlighted
Four Stars

Re: Communications link failure

Hi Vapukov,

 

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read