Rollback problem

Hi! I've got the following problem with Version 4.0.9 of Mysql: The page http://www.mysql.com/doc/en/COMMIT.html says: 'If you do a ROLLBACK when you have updated a non-transactional table you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning. All transactional safe tables will be

Re: Re: Commit and rollback problem and mm.mysql

Hi. Thanks for the reply... I curious with what you mean by mysql not supporting commit and rollback coz I found this in the site : http://www.mysql.com/documentation/mysql/bychapter/manual_Refere nce.html#COMMIT Actually, Ive already tested it in my app under weblogic(and worked). I was just

Commit and rollback problem

Hi List! Hope you can help me with my problem... I am trying to incorporate commit and rollback in my sql statements... I have tried it in my web application which runs on weblogic and it work fine. However, when I migrated my web app to Tomcat, it failed to rollback when it encountered an er