topic Re: How to use strat transaction commit rollback in TALEND in Talend Studio

How to use strat transaction commit rollback in TALEND

DM2017 — Wed, 07 Feb 2018 11:34:24 GMT

I have a job which has multiple tables involved in transaction .

1>How do I use commit and rollback, Basically on which place to be used, as I have so many sub jobs connected.

2>Where to use on component OK & where to use On sub job OK. My job is working fine. But I need to know the particular use.

Kindly help.

Re: How to use strat transaction commit rollback in TALEND

lojdr — Thu, 08 Feb 2018 17:49:02 GMT

Hello,

Ad 1)

Example how to implement commit -

https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/yuU8JtnIXUBiRsJYYKOngA?section=Raa91640

Example how to implement rollback -

https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/7THiSA~u~mPb7PskcQONMQ

ad 2) OnComponentOK - for a single component check, OnSubJobOK - when you need to check that all components in the subjob finished successfully.

Regards
Lojdr

Re: How to use strat transaction commit rollback in TALEND

DM2017 — Thu, 08 Feb 2018 18:44:31 GMT

Ok. Thanks. But how to design when there are multiple transformation on a same job.

for example

tmysqlinput1>> tmp>>tmysqloutput1

tmysqlinput2>> tmp>>tmysqloutput2

tmysqlinput3>> tmp>>tmysqloutput3

Here I need all table load happens once or none. from youe suggestion I can go for individual commit & rollback but what about whole thing.

Please suggest

Re: How to use strat transaction commit rollback in TALEND

lojdr — Thu, 08 Feb 2018 19:11:26 GMT

Hello,

There is no easy solution of this task. The only correct solution is to do it in one transaction to be sure that data will stay consistent. As far as I know, there is no possibility to commit several transaction as a one. It is always one by one and this can cause inconsistency.

I recommended one solution/workaround for MySQL in the following thread:

https://community.talend.com/t5/Design-and-Development/delay-commit-when-using-built-in-mode-tMysqlOutput/m-p/46987#M14618

Please check it and let me know.

Regards
Lojdr

Re: How to use strat transaction commit rollback in TALEND

tourdownunder — Mon, 16 Dec 2019 01:01:34 GMT

Unfortunately these links are dead

Ad 1)

Example how to implement commit -

https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/yuU8JtnIXUBiRsJYYKOngA?section=Raa91640

Example how to implement rollback -

https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/7THiSA~u~mPb7PskcQONMQ