Re: Database Rollback?
Thanks for both of your responses.
What about handler_rollback...? According to what I see in MySQL Administrator, there have been 14.
Also - the app is a vb.net app and uses MySQL Connector Net 1.0.5
now I've been reading that on connection.close any pending statements will be rolled back. This could explain the loss of one invoice transaction, but not an entire day. But it's confusing as .. how are rollbacks possible if MyISAM does not do rollbacks? And how could the statements be pending? Would the inserts be cached and somehow rolled back?
Does mycommand.executeNonQuery() write directly to the db?
If it's a caching issue - can I turn that off?
Subject
Views
Written By
Posted
8215
April 04, 2006 04:45PM
2728
April 05, 2006 12:14PM
2362
April 05, 2006 03:55PM
2255
April 05, 2006 12:22PM
Re: Database Rollback?
2307
April 05, 2006 04:02PM
2051
April 06, 2006 01:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.