hi there, i'm using two different database objects, for each connection. i still haven't tried with save points, but i will, to see what append.
regards, andré Citando Heikki Tuuri <[EMAIL PROTECTED]>: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
