tMySQLoutput do not capture the data with out tmysqlcommit

[Anonymous]

recently I found that tmysqloutput do not commit automatically you have to use tmysqlcommit.

Can anybody tell me it is by design or there something I am missing?

[akumar2301]

it is always recommended to use Commit component so that you can manage your transactions well.

you have other option like

tMySqlConnection - Auto Commit option ( Commit is done for each transaction )

tMySqlOutput ( batch mode also has commit option)

[Anonymous · Accepted solution]

hello @Satyax2019 ,

Take a look at this page: https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/CInUFSCGXiagiSq0fcnFLQ?section=Raa91640

It shows how to use a tMySQLConnection and a tMySqlCommit. To do what you want you need to start with creating a connection, do each of your steps, then decide at the end (maybe using a tPostJob) whether everything has happened cleanly (then Commit) or whether you need to rollback (use the tMySQLRollback).

Warm Regards,
Manish Suryawanshi,

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂