Five Stars

Using tOracleCommit with Component List

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.talend_error.jpg

 

What is the issue here? can you please help?

  • Data Integration
4 REPLIES
Nine Stars

Re: Using tOracleCommit with Component List

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.

Five Stars

Re: Using tOracleCommit with Component List

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

Community Manager

Re: Using tOracleCommit with Component List

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: Using tOracleCommit with Component List

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?commit.jpg