i use Swing + MySQL v5.0.81 +JDBC
is it possible the transaction could not be rollbacked?..
so what i have to do to handle it?..
do i have to rollback it manually?..
but i guess it is a hard work to rollback it manually..
is there any solution?
what kind of query which cause the query could not be rollbacked?..
Thanks in advance
Sorry, perhaps my english language isn't too good.. Prepare for SCJP 6, Please God help me.. ☼
References : [Java.Boot] [JavaChamp] [JavaPrepare]
Thanks for your reply..
what do you mean that all of transactions could be rollbacked?..
if there suddenly the electricity is turned off, does the transactions could be rollbacked also?..
i have just faced the problem, when the electricity is turned off suddenly (caused by the electricity provider).. and the table is crashed..
and the the transaction could not be rollbacked...
Does MySQL especially InnoDB storage engine can handle this case?..
If you lose a connection you lose all associated resources, transaction included, which is the same as a rollback. If there has been no comit then the database will time it out (assuming you are using a MySQL db engine that supports transactions in the first place).