What is the relationship between the defaultAutoCommit and spring transaction management of the database pool and the underlying database settings?

I remember that spring transaction management defaults to false, but there seems to be a conflict between many database pools, including druid, autocommit, which defaults to true,. In addition, autocommit, can also be configured in the configuration of the underlying database, such as mysql, so which of the three has the highest priority, that is, which setting can override the others?

in addition, there are two kinds of understanding of autocommit here
1) when the whole transaction is about to end, the transaction management AOP automatically commits
2) when each sql statement is executed, it commits automatically

which is the so-called autocommit in the defaultAutoCommit and spring transaction management of the database pool?

Spring java mysql

Jan.21,2022

is not clear about spring, but at the database level, the auto-commit of
MySQL is automatically committed after each statement from the client is executed.
but if you explicitly open a transaction using begin or start transaction, you need the displayed commit or rollback to end the transaction.
of course, executing DDL within a transaction triggers an implicit commit.

aotucommit

When

autocommit is off , as long as the DML statement (including select ) is executed, a transaction ( begin ) is automatically opened, and the transaction
autocommit is not terminated until commit or rollback is executed
autocommit is on .

priority

manual settings can override the default settings, that is, spring and druid can override mysql configured autocommit
the latter setting overrides the previous setting, druid first, spring then

Previous: Foreach has to foreach another array? for noodles.

Next: Change the design problem through "type"?

Spring transaction, update has an exception rollback problem in the loop?
in a transactional method, by reading a collection of table records and cycling the values of update or save fields, the administrative account is updated every time an ordinary account is updated. so re-query the system account . @Transactional(rollba...

Spring java mysql

Mar.23,2021

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