topic Re: Oracle Rollback on Error in Talend Studio

Oracle Rollback on Error

Anonymous — Sun, 10 Sep 2017 08:03:25 GMT

Hello Everyone!

I am, fairly, new to Talend, and I was wondering about how can I rollback in case of an error in case if the "Action on table" is not "NONE". Your help is really appreciated.

Thanks!

Re: Oracle Rollback on Error

Anonymous — Mon, 11 Sep 2017 14:54:15 GMT

Hello you can use :

- tOracleConnection (don't forget to uncheck commit automatique in advanced setting)

- tOracleCommit

- tOracleRollBack

- tOracleClose (don't forget to close you connection after your job)

Then you can manage your rollback and commit as you want and you have only one connection for your job. Instead of connect and disconnect for each tOracleInput or tOracleoutput

You can manage like this for example :

tOracleOutput --- OnComponentError --- tOracleRollback

I _ _ _ _ OnComponentOk --- tOracleCommit

Hope this help.

Good luck ,

SGV

Re: Oracle Rollback on Error

Anonymous — Mon, 11 Sep 2017 15:21:44 GMT

Thanks for your reply. I have done this and I see that it goes to the rollback path however it doesnt do the rollback. And I was looking around in my destination the "action on table" is "drop table if exists" and I see warning saying that this will do an auto commit. Can you pleass explain to me what am I doing incorrectly?

Thanks

Re: Oracle Rollback on Error

Anonymous — Mon, 11 Sep 2017 15:48:28 GMT

Please be sure that the "Use existing Connection" is checked on your tOracleOutput component.

Good Luck ,

SGV

Re: Oracle Rollback on Error

Anonymous — Tue, 12 Sep 2017 09:08:45 GMT

I made sure. The same thing exists

Re: Oracle Rollback on Error

Anonymous — Tue, 12 Sep 2017 09:26:51 GMT

Oh ok, if you want to enable the "auto commit" you have to use the Default action on your tOracleOutput.

But if you want to trun table before insert, there is different way :

- You can use a tOracleRow to execute a code before your tOracleOuput.

- You can use a temporary table

If you have some problem, send a screenshot of your job and explain the purpose of the job you have to do.

Good luck,

SGV

Re: Oracle Rollback on Error

Irshad1 — Tue, 12 Sep 2017 15:25:53 GMT

Hello

do you want to drop the table or want to rollback the data on error?

"drop table if exists"--- this will drop your table from the database.

Thanks!

Re: Oracle Rollback on Error

Anonymous — Tue, 19 Sep 2017 14:01:13 GMT

I would like to drop the table if exists if the job succeeds only, otherwise I'd like for it to roll back.