Specifically How to handle Transactions for Oracle

Hi all,

I have a simple problem of handling transaction in WM. That is when I am inserting data in the database and it commits in between the transactions. Can anyone help me with what I need to do to handle transactions. How can I make the database autocommit to set to ‘no’. It seems it’s ‘yes’ at the moment.


Hi, Rahul.

The Enterprise Database Adapter will commit transactions only after the integration component completes its execution.

You can use Try-Catch blocks or Stored Procedures to manage transactions. Most folks here will push you towards the latter.

Good luck.