Flow service A:
Flow service A has one Doc list input variable.
During runtime Doc list contains 4 elements (records).
In A service, I used Loop step to iterate the Doc List. Inside the Loop, I have used try catch sequence steps. In the try block I am invoking the insert JDBC service(Local Transaction).In the catch block appending the error msg from getlasterror in case if any error occurs.
The Input Doc list contains 4 records, assume 1st & 3rd records will get inserted successfully.2nd & 4th record has error.
In the above scenario after the execution of the flow service 1st & 3rd record insertion is commited.
I WANT TO ROLLBACK, if there is a error in one of the record.
Kindly tell me how can we do this? In the above scenario If I have used explicit transaction, then I can rollback the changes. I want to rollback without using explicit transaction.
I read the following in the JDBC manual
LOCAL_TRANSACTION With this transaction type, all of the operations on the same connection in one transaction boundary will be committed or rolled back together. A transaction boundary means the scope of the transaction, from the beginning to the end of a transaction. It can be in one adapter service, one flow service, one Java service, or several steps in a flow service.
Please tell me how to define a transaction boundry.
Thanks
Saravanan S