Hi Rohit: You need to explain your problem statement more clearly. Maybe the code snippet could help.
If you mean that in your application, while all statements in one transaction pass, and then one of the statements in the next transaction fail, and you are expecting that this failure of the last transaction should also roll back the previous transaction, you are wrong in expecting this. They are two different transactions, and are isolated from each other. If you mean that you have a set of statements that form a part of a transaction, and failure of one of them does not result in the rollback of the whole transaction, then you have a problem. In such a case also, one will be able to help only if the code snippet, or some details are available... Regards Sanjeev -----Original Message----- From: Chaturvedi, Rohit (CAP, GECIS) [mailto:Rohit.Chaturvedi@;GECIS.GE.COM] Sent: Thursday, October 24, 2002 4:52 PM To: [EMAIL PROTECTED] Subject: Transaction Rollback....... Importance: High Hi All, We have created a connection object to the SQL database whose autocommit has been set as off........ We have obtained the UserTransaction object through JNDI lookup(context.lookUp(java:comp/userTransaction)) in a JSP page. We have a set of transaction which are executed within a begin and commit method of UserTransaction object. In the SQLException block, we have rolled back the UserTransaction. Now the problem is that even if one of the transaction fails and rollback method is executed, the previous transaction still reflects in the database and doesn't seems to be rolled back. Pl. suggest what could be the reason behind??Need an urgent help...... Thanks a lot. Regards, Rohit. ____________________ ROHIT CHATURVEDI Sr. Software Engineer - Information Management Group GECIS Technology 22B, Sector 18, Udyog Vihar Gurgaon, India Ph: 91.124.8925344 EMail: [EMAIL PROTECTED] ______________________________________________ > This e-mail, together with any attachments, is confidential. It may be read, copied and used only by the intended recipient. If you have received it in error, please notify the > sender immediately by e-mail or telephone. Please then delete it from your computer without making any copies or disclosing it to any other person. > =========================================================================== 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". =========================================================================== 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".
