topic [resolved] Question on use of tOracleRollback & tOracleCommit in Talend Studio

[resolved] Question on use of tOracleRollback & tOracleCommit

txvincent — Sat, 16 Nov 2024 12:58:38 GMT

Hi,
If I want to do a rollback whenever any component in my job fails, will the way I have my tOracleRollback and tOracleCommit components set up do that? Or is it only going to do a commit or rollback whenever the tOracleOutput component is successful or unsuccessful?

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

Anonymous — Mon, 18 Apr 2011 16:04:33 GMT

use "OnSubjobOK" from the start component of the particular subjob (the one with a green background, the start of the flow) rather than onComponentOK on the DB output.
as a rule of thumb, onComponentOK should be avoided. This connector can have different behavior depending on the source component-- so unless you know what you're doing, its a good idea to just avoid using it all together.

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

txvincent — Mon, 18 Apr 2011 16:08:19 GMT

So would I have to set it on only the first component or would I have to set OnSubjobOK for every component up to the Staging Table tOracleOutput component? What about the tOracleRollback? How would the rollback know what the table name that it needs to commit or rollback if it isn't coming out of the Staging Table tOracleOutput component? Thanks.

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

Anonymous — Mon, 18 Apr 2011 16:14:34 GMT

Only on the start component... both the rollback and commit will be connected.
for example

tDBInput--->tMap--->tDBOutput
| |
OnOK OnError
| |
| rollback
commit

Re: [resolved] Question on use of tOracleRollback & tOracleCommit

txvincent — Mon, 18 Apr 2011 16:19:39 GMT

Great, I got it. Thanks so much John for your help!