I think it might have something to do with the fact that I'm running the
NDB engine. I'm not sure... It doesn't seem to have the same problem
on Inno (another transaction-safe engine)
I think I need to send MySQL some info so they can try to duplicate it.
I'm wondering if anyone else
Hi Cory - nice to see a fellow Lasso user here!
I've not use transactions myself but I think you might be having a problem with
autocommit.
http://dev.mysql.com/doc/refman/5.0/en/commit.html
HTH,
James Harvard
At 12:44 am -0700 15/12/05, Cory @ SkyVantage wrote:
I have a transaction that is
and Services
http://www.mysql.com/network/
- -Original Message-
- From: Cory @ SkyVantage [mailto:[EMAIL PROTECTED]
- Sent: Thursday, December 15, 2005 1:45 AM
- To: [EMAIL PROTECTED]; mysql@lists.mysql.com
- Subject: Transactions (not rolling back on error)
-
- I have a transaction
I have a transaction that is very simple, I need to create records in
multiple tables that are related. If any one insert statement fails or
throws an error I want to rollback the ENTIRE transaction.
I thought that this was the default functionality, but apparently that's
not the case here.