One Star

Commit every n records

Hello,
I have a tOracleOutput that I need to commit every 10000 records updated. I saw there is an option that does it but if I connect my tOracleOutput to a tOracleConnection, the option disappeares and I can just flag automatique commit on the tOracleConnection. It seems that this kind of option commits every record updated but I would like to do it every 10000 or another value I want to choose.
Is there any way to do it?
Thanks.
Giuseppe
4 REPLIES
Community Manager

Re: Commit every n records

Hi
The tOracleConnection and the commit every n records feature can't be used together, if you use tOracleConnection to create the DB connection, there always be a tOracleCommit to commit the change at the end of job.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Commit every n records

and if I have got 3.000.000 di record to update? The buffer would get full before commiting my work and the job would break. In this case I have to avoid using a shared connection?
Thanks.
Community Manager

Re: Commit every n records

and if I have got 3.000.000 di record to update? The buffer would get full before commiting my work and the job would break. In this case I have to avoid using a shared connection?
Thanks.

Hi
Yes, you need to create the db connection on the db output component.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Commit every n records

Ok.
Many thanks for the reponse Smiley Happy