I have got a problem regarding committing transactions in Integration component.
My IC consists of many Inserts/Updates operations on Oracle(Intelligent) Adapter.
All these operations are inside Try/Catch block.
When any of the operation fails,the adapter commits all the operations prior to the operation that has failed.
Why does it so though the Oracle adapter handles the transaction internally?
And how should I force my adapter to rollback the transaction in case any operation fails?
Will be very thankfully for immediate response.
Thanks in advance,