Roolback and Commit

[Anonymous]

I am trying to create a Rollback and Commit Job in Talend as shown below. On encountering an error, the flow shows to be going to the Rollback component, but the question is what has been rolled back? I can still see in my DB the 6 records as is shown in the figure. How to achieve commit and rollback then in Talend?

Regards

Pankaj

[Anonymous]

does your tOracleConnection component have auto-commit option checked?

If yes, try disabling it and run again. In such a case, I don't really think a separate rollback component is required since the data gets committed only if the sub job loading to oracle table, gets completed successfully.

[Anonymous]

No it is unchecked.

Also the sub job loading to oracle table is OK as you can see in the screen.

the real question is when the error has happened and the flow goes to Rollback, why not actual Rollback took place?

[Anonymous]

Well, in that case you shouldn't see those 6 records in the table as the flow would never reach tOracleCommit Component.

This is weird. Maybe you can try using tLogCatcher instead of the 'onSubJobError' link and see if that works.

[Anonymous]

Ya this is what the problem is... I am not getting proper help or guidance to proceed..

I wonder what should i do?

[cterenzi]

Please verify that your TESTOUTPUT component is using the same connection as the commit and rollback components.

[Anonymous]

---

@ppp_rrr wrote:

Ya this is what the problem is... I am not getting proper help or guidance to proceed..

I wonder what should i do?

---

I am just thinking out loud here but can you try using a tOracleRow component to write a rollback query and see if that works.

[Anonymous]

Ya confirmed, the TESTOUTPUT component is using the same connection as the commit and rollback components.

[Anonymous]

Hello
Make sure the 'die on error' option is checked on tOracleOutput, so that the job will die and throws the Java exception if there occurs an error during the job execution.
I have made a testing on version 6.4.0 and it works as expected. Which version are you using? What's the error messages thrown on the console?

Regards
Shong

[Anonymous]

Hello Shong,

Did exactly as you said. checked the 'die on error' option, but still can't see the Rollback in effect. See the screenshot below again, there is an exception in 7th row shown in the console as well, and the flow goes to Rollback component. But, records can be seen in DB.

I am using Talend 6.3 for Data Integration.