Unable to rollback the transaction

Visitor

Dear Experts! I'm looking for a solution to one of my problem. Following is the sequence of db calling initiated by Java.

***********************************************************

Begin Tran -- Java Level
1. get balance from **_CUSTOMER_BALANCES
2. insert **table 1
3. insert **_table 2 
4. insert **_table 3

5. call procedure - UspInsertIntoTripReceiptTracker
6. call procedure - Update Customer balance after discount etc.
Commit Tran -- Java Level

*****************************************************

*all are in Java transaction scope.

 

if some thing goes wrong at 6 i.e SP call, I wanted to rollback all previous DML's.

 

Currently, what happening is, 2,3 and 4 are rollbacking, they are direct queries executed by Java, but, not the DML's which are generated in 5 i.e SP call.

 

Pls advise.

Thanks in Advance!

Balananadm

 

0 Replies