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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables