Specifically How to handle Transactions for Oracle

, , ,
1

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.

Thanks

2

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.