Using tOracleCommit with Component List

[Anonymous]

Hi,

I am trying to create a Rollback and Commit Job. I am using tOracleCommit and Rollback component as my starting point.

However the job is asking for Component List and I am not getting anything in the list.

What is the issue here? can you please help?

[cterenzi]

To use these components, you have to use a tOracleConnection component.  Configure one with the necessary settings at the start of the job (ideally, connected to a tPrejob component), and have the output, commit and rollback components refer to it.  You may also want to configure a tOracleClose component connected to tPostjob.

[Anonymous]

Can you please give me a simple example, i.e. job design of Commit and Rollback ?

[Anonymous]

Hi
A simple job looks like:
tOracleConnection_1
|
onsubjobok
|
tFileInputDelimited--main--tMap--out1--toracleOutput
--onsubJobOK -tOracleCommit
--onsubJobEorror--tOracleRollback

on tOracleCommit and tOracleRollback, select tOracleConnection_1 in the component list.

Regards
Shong

[Anonymous]

Hi Shong,

Are you suggesting some thing like below or correct me if i am wrong. Ideally commit or rollback should mean either all the rows are committed or rolled back.Will this give the desired result?