A method defines whether the transactional rollback is the db operation of the current method or the db operation of the entire web program when an exception occurs and is thrown.

problem description

the environmental background of the problems and what methods you have tried

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Apr.24,2022

think about the nature of the transaction
from
con.setAutoCommit (false);
to
con.commit ();
all operations on the database are rolled back

if the framework is integrated or @ Transcational
is the rollback of the database operation in the current code block.


rollback the transaction of the current session

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3a94f-2c207.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3a94f-2c207.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?