I almost always use container managed trans. SOrry. Anthony Catalfano Information Technology Analyst Deere & Company 309-748-5201
-----Original Message----- From: Chaturvedi, Rohit (CAP, GECIS) [mailto:Rohit.Chaturvedi@;GECIS.GE.COM] Sent: Thursday, October 24, 2002 6:22 AM 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".
