Rollback is not working in a clustered environment.

, ,
1

Using a local transaction I have defined explicit transaction boundary and trying to insert records into multiple tables in a clustered environment. When ever there is an error I am unable to rollback the inserted records.

Where as when I am inserting in a non clustered environment rollback works fine. May I know what could be the reason?? :roll:

2

Did you preliminary check and are you sure the error handling code and JDBC connection setup is all in sync in your cluster environment in all IS’s?

Please cross verify and see if anything is different as it supposed to work same way in cluster vs non-cluster:

HTH,
RMG

3

Thanks RMG! The issue is because of the TransactionIsolation level.

Thanks again! 8)