[resolved] Error in tMysqlconnection

[Anonymous]

Hi,
I am getting this error while running the job.
Help me out..
connecting to socket on port 3599
connected
connecting to socket on port 4936
connected
Exception in component tMysqlConnection_1
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.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)

To see the whole post, download it here

[Anonymous · Accepted solution]

Hi,
I have made a testing on Talend Open Studio for 5.3.1. Everything is OK for me. I suspect something wrong with your MySql DB.
Could you use other tool to connect it directly to see if it is working?(such as, DB Visualizer).
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Thanks for your quick replay...

[Anonymous]

Hi Dukeguru,
Is there any update for your current situation?
Best regards
Sabrina

[Anonymous]

Hi sabrina,
That issue is resolved now. Previously i am using only one port to connect to the My sql like 8180 and now i got that it requires two ports, one to connect to the SQL Db with port no.like 3306 and one to connect to the Talend server like 8180.
Now it is working fine.
Thank you.

[Anonymous]

Hi,
Thanks for your feedback. Feel free let me know if there any further help we can provide.
Best regards
Sabrina