Four Stars

Talend Auto commit for MySql Connections.

Hi, 
I would like to know how i can commit after loading data into a DB.
Currently I am loading data from a file to MySql but after the data load the data is not committing.
I have used mySqlCOmmit component but the Component List is empty with no values. 
Thanks & Regards,
Srivignesh KN
1 REPLY
Community Manager

Re: Talend Auto commit for MySql Connections.

Hi
Without using an existing connection, the data will be commit automatically every N rows, this parameter can be configured in the advanced panel of tMysqlOutput.
If you want to use an existing connection, you should use a tMysqlconnection to create a DB connection and use tMysqlCommit to commit the changes.
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business