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

[Aukema]

Could you add a screenshot of your TESTOUTPUT component configuration?

[Anonymous]

OK here it is.

[Aukema]

You are using the connection settings from the repository, but you should set the "Use an existing connection" checkbox to use the transaction.

[Anonymous]

OMG, you said you use the same connection, I thought you have checked the 'Use an existing connection' checkbox.

[Anonymous]

O ya..just got confused for the 'same connection' as both the Connection component and Output component had same connection properties from Repository.

So, thanks that first part has been resolved.

Now, the actual scenario is that my client wants that if we put some auto fix validations like name.replaceall() etc. in some data transformation step, then he should be able to visually see all data errors that were fixed automatically so that he can approve and/or reject and/or rollback.

Will this be possible to achieve?

[Anonymous · Accepted solution]

Hi ppp_rrr
This is a new question about data validations, please open a new topic for a new question. One topic for one question helps us to manage the questions and other users to find answer/solution easily.
Thanks!
Shong