From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

[TimeOUt] tmysql Commit

Highlighted
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

Highlighted
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 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog