Andre, ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, March 07, 2004 3:28 PM Subject: transactions
> Hello there. > > i'm working with transactions, and i have one situtation where i start a > transaction and execute the insert/update statement, then i execute another > start transaction for another db and execute the insert/update, and if this > return a error i do the rollback, and then i do the rollback for the first > transaction. > > example: > start transaction > insert/update .... > start transaction (for another database) > insert/update ... > rollback or commit > rollback or commit (this rollback isn't working) > > my problem is that the rollback for the first transaction isn't working, and= > i > don't understand why! > > can you help me? maybe you should use savepoints. Though, then if you rollback the outer transaction, it will also rollback the inner 'transaction'. If that is not ok, then you must use 2 different connections to MySQL. http://www.innodb.com/ibman.php#Savepoints > thanks, > Andr=E9 Br=E1s Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
