Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable Postgresql Autocommit on ODI

Lucas MatisDec 14 2018 — edited Dec 17 2018

I have a mapping for a table with 10M records loading from Postgresql to Oracle.

LKM is set to SQL to Oracle and job always fails on "Out of Memory".

Fetch Size is set to 100.

Postgresql documentation shows that for Fetch Size to work, the connection must set AutoCommit to Off (it is on by default).

https://jdbc.postgresql.org/documentation/head/query.html#query-with-cursor

I can load from Oracle to Oracle 10M lines using same LKM without problems.

How can I set this configuration on ODI topology?

Added on Dec 14 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

684 views