[TimeOUt] tmysql Commit

One Star

[TimeOUt] tmysql Commit

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

One Star

Re: [TimeOUt] tmysql Commit

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”

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now