Re: Database Rollback doesn't work

2003-12-19 Thread monicaf
Hi! Thanks a lot for your answer. I have decided to implement the transactionality in the code as suggested. It seems a better way of doing it. Monica > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > George Sexton wrote: >> I thought transactions were one of those features MySQL decided tha

Re: Database Rollback doesn't work

2003-12-19 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 George Sexton wrote: > I thought transactions were one of those features MySQL decided that > real developers didn't need. Are you really certain mySQL Supports > transactions in the relatively low version you are using? I assume the poster meant MySQ

RE: Database Rollback doesn't work

2003-12-19 Thread George Sexton
il goes or fails. What if it wedges for 60 seconds doing a DNS lookup? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 9:30 AM To: [EMAIL PROTECTED] Subject: Database Rollback doesn't work Hi! I have a simple webapp that allows us

Database Rollback doesn't work

2003-12-19 Thread monicaf
Hi! I have a simple webapp that allows users to register. The user is inserted in the DB and a confirmation mail is sent to the user. If the mail fails I'd like the DB to rollback the transaction, but it doesn't do it. The new user entry is kept in the DB. I'm using Tomcat 4.1 and mySQL 2.3.2. I