topic Re: Using tOracleCommit with Component List in Talend Studio

Using tOracleCommit with Component List

Anonymous — Fri, 16 Jun 2017 11:58:23 GMT

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?

Re: Using tOracleCommit with Component List

cterenzi — Fri, 16 Jun 2017 14:50:36 GMT

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.

Re: Using tOracleCommit with Component List

Anonymous — Mon, 19 Jun 2017 05:55:16 GMT

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

Re: Using tOracleCommit with Component List

Anonymous — Mon, 19 Jun 2017 07:03:56 GMT

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

Re: Using tOracleCommit with Component List

Anonymous — Mon, 19 Jun 2017 09:50:48 GMT

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?