Spring transaction and Mysql transaction

1. Background:
mysql transaction isolation level for READ_COMMITTED; data saving using native hibernate; queries using JdpcTempLate;

2. Main question:

hibernateJDBCNot_suppport;;

3. Code:

clipboard.png
3.1.hibernate:

clipboard.png
3.2.JDBC

clipboard.png
3.3Jdbcjdbc

clipboard.png
reasons for asking for help.

Mar.13,2021

you are currently executing the commit thread query, of course you can find it. Change it to mysql client and try again, and you won't find it.

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-1b30b52-2bd41.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-1b30b52-2bd41.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?