Talend community forum / Commit every n records

neosz · 2012-05-23 15:42:42

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

shong · 2012-05-23 15:48:39

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

neosz · 2012-05-24 12:33:03

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.

shong · 2012-05-24 15:18:37

neosz wrote:
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

neosz · 2012-05-24 15:24:49

Ok.

Many thanks for the reponse

Announcement

Unanswered posts

#1 2012-05-23 15:42:42

Commit every n records

#2 2012-05-23 15:48:39

Re: Commit every n records

#3 2012-05-24 12:33:03

Re: Commit every n records

#4 2012-05-24 15:18:37

Re: Commit every n records

neosz wrote:

#5 2012-05-24 15:24:49

Re: Commit every n records

Board footer