topic Re: tMySQLoutput do not capture the data with out tmysqlcommit in Talend Studio

tMySQLoutput do not capture the data with out tmysqlcommit

Anonymous — Sat, 16 Nov 2024 03:23:33 GMT

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?

Re: tMySQLoutput do not capture the data with out tmysqlcommit

akumar2301 — Sat, 01 Feb 2020 10:46:23 GMT

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)

Re: tMySQLoutput do not capture the data with out tmysqlcommit

Anonymous — Sat, 01 Feb 2020 12:07:25 GMT

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 🙂