[TimeOUt] tmysql Commit

_AnonymousUser — Wed, 30 Sep 2015 09:37:40 GMT

Hi,
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?

Best regards
Loic

Re: [TimeOUt] tmysql Commit

_AnonymousUser — Wed, 30 Sep 2015 10:25:57 GMT

Hi,

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”

topic [TimeOUt] tmysql Commit in Talend Studio

[TimeOUt] tmysql Commit

Re: [TimeOUt] tmysql Commit