This very same issue was dealt with earlier this month.
Try this URL.
Let me know if the second solution that was mentioned there works for you.
Regards
Madhu
http://archives.java.sun.com/cgi-bin/wa?A2=ind9909&L=ejb-interest&D=1&O=D&P=17462
-----Original Message-----
From: Madhusudan Iyengar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 23, 1999 11:27 AM
To: [EMAIL PROTECTED]
Subject: Transaction issue
Hi
I have a stateful session bean which has to execute four prepared
statements, there is a dependency of a table between the first and the last
statement. I also need to be able to rollback all the changes if exception
occurs in any of the statements. Because of the dependency pages in the
database gets locked, if I put them in separate transactions how do I
rollback the changes.
Any suggestions would be appreciated.
Madhu
________________________________________________________________
Get FREE voicemail, fax and email at http://voicemail.excite.com
Talk online at http://voicechat.excite.com
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
