Hai All,
I am finding diff in rolling back some transactions.
Actually in my application (ie in
Servlet) i have 5 callable statements to execute 5 stored procedures.
cstmt1,cstmt2,cstmt3,cstmt4,cstmt5
I have one connection object.
I have to execute these stored procedures in sequence. If any stored procedures returns non zero value i have to stop
execution and roll back all the transactions.
If all the 5 stored procedures return 0 then i have to commit the transaction.
i have used the following logic to do so.
But the problem is, i am failing to rollback the tranaction.
SP5 is returning non zero value, its displaying "error in SP5", but
is not rolling back all the transactions. Plz let me know how to roll back all the transactions.
Is there any mistake in my logic. ??
SP2 and SP3 are executed more than once and are included in for loop.
SP = Stored procedure.
Any help would be appreciated.
Thanks in advance
POOJA.