One Star

[resolved] Connection failure on mysqlinput

Hi,
I have a problem running jobs in command line.
I try to run a job which call other jobs (total of 12 jobs). When i run it using Talend Open Studio, it works, but when i run it in command line, i'm getting this error on a random mysqlinput :
----
Exception in component tMysqlInput_11
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.
Caused by: java.net.ConnectException: Connection timed out
----
Problem is that I get this error on random MysqlInput (sometimes I get this on the first jobs, sometimes on the last, etc... ).
I saw that this could be resolved by increasing "wait_timeout" and "interactive_timeout" => they're already at "28800" so it should be okay. (?)
If you have any idea what could be resolve this, I would be glad to know it Smiley Happy
Thanks.
(Sry for my english, I'm doing my best).
1 ACCEPTED SOLUTION

Accepted Solutions
Seventeen Stars

Re: [resolved] Connection failure on mysqlinput

I know this problem:
http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure
is a discussion about this topic and so far there is no real solution. It is not a problem from Talend, it is a problem of the recent release of the JDBC driver for MySQL.
1 REPLY
Seventeen Stars

Re: [resolved] Connection failure on mysqlinput

I know this problem:
http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure
is a discussion about this topic and so far there is no real solution. It is not a problem from Talend, it is a problem of the recent release of the JDBC driver for MySQL.