On a component "Tmysql commit", appears a Timeout error of the connection.
Error message :
Exception in component tMysqlCommit_2
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure During commit (). Transaction unknown resolution.
Today, I open a new connection to each commit. The solution is viable, but seems to be optimized.
I will wish to force "mysql timeOut Wait" value directly to a parameter of Talend.
Do you have an idea for optimized this process?
I’d like to execute this request in mysql linked to the connexion:
SET session wait_timeout=300 in Composant->TmysqlConnection->Additional JDBC parameter
Do you have any idea on how I can do this ?
We tried to add this parameter in talend but it doesn’t seems to work
An otherway I thought is to execute this command in a T_Java component but I don’t know how to recover the connexion ID in the other component, cause today we use a select box wich list only the mysql connexion and those kind of “home made connexion”
