topic Re: Commit every n records in Talend Studio

Commit every n records

Anonymous — Wed, 23 May 2012 14:42:42 GMT

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

Re: Commit every n records

Anonymous — Wed, 23 May 2012 14:48:39 GMT

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

Re: Commit every n records

Anonymous — Thu, 24 May 2012 11:33:03 GMT

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.

Re: Commit every n records

Anonymous — Thu, 24 May 2012 14:18:37 GMT

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

Re: Commit every n records

Anonymous — Thu, 24 May 2012 14:24:49 GMT

Ok.
Many thanks for the reponse