I am trying to load data into oracle using TOS 2.3.3. 1) I have main connection that goes from my file to tOracleOutput. 2) I use the existing connection. 3) I want to commit every 10000 rows. Is there a way to implement this kind of load in Talend? I understand that I can do it if I don't use existing connection (there is a Commit Every... field on the Advanced Settings tab, but it disappears when I switch to "use existing connection"). Why can't I do it with the existing connection? Is there a reason or am I missing something?
Why can't I do it with the existing connection? Is there a reason or am I missing something?
It's a design choice from us the developers. tOracleConnection/tOracleCommit/tOracleRollback where designed so that user can control the transactions.
Workaround:
tFileInputDelimited --row--> tOracleOutput --row--> tFilterRow --row--> tOracleCommit
in the tFilterRow, advanced mode:
sequence('abcd', 1, 1) % 10_000 == 0
Don't forget to add a tOracleCommit after the subjob, so that last lines are commited.
May I ask you to add a feature request "add a commit every in t*Commit"? I think it would be much more user friendly than the tip I just gave you.
Why can't I do it with the existing connection? Is there a reason or am I missing something?
It's a design choice from us the developers. tOracleConnection/tOracleCommit/tOracleRollback where designed so that user can control the transactions.
Workaround:
tFileInputDelimited --row--> tOracleOutput --row--> tFilterRow --row--> tOracleCommit
in the tFilterRow, advanced mode:
sequence('abcd', 1, 1) % 10_000 == 0
Don't forget to add a tOracleCommit after the subjob, so that last lines are commited.
May I ask you to add a feature request "add a commit every in t*Commit"? I think it would be much more user friendly than the tip I just gave you.
Excellent! I will use this trick for now and wait for the new feature.
Submitted 3797
