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.
Hello you can use :
- tOracleConnection (don't forget to uncheck commit automatique in advanced setting)
- 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 ,
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.
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.