2 subjobs commit in same transaction

michaelh1 — Sat, 16 Nov 2024 02:24:14 GMT

I have two subjobs inserting data in two different tables. What i need is to commit all data in one transaction. How can i achieve this?

1st one is insetring into table authors and 2nd one into table books. but after some testing i noticed that if the second job failed, the first one have already commited rows into first table.

I tried to use tDBConnection for this but its not working as expected as you can see in the picture:

And in the child component if i tick "use an existing connection" the combobox is empty.

Is there any way how to force subjobs commit in one transaction?

Re: 2 subjobs commit in same transaction

manodwhb — Fri, 22 May 2020 06:14:41 GMT

@michaelh , You can take the on component ok from sub2 and connect to commit. and You remove the On Subjob ok from tDBconnection to Sub2 job.

topic Re: 2 subjobs commit in same transaction in Talend Studio

2 subjobs commit in same transaction

Re: 2 subjobs commit in same transaction