mybaits 数据源设置defaultAutoCommit=false 事务依然提交

最近在验证 defalutAutoCommit 事务提交的时候出现了一个问题 让我百思不得其解

一般来说把数据源属性设置成defalutAutoCommit=false 事务不会自动提交，也就是说在没有使用spring的时候新增一条数据是不会自动提交的到数据库的，但是事实上是不管defalutAutoCommit=false还是=true 在数据依然可以看到有新增的记录.....

打开debug日志....

logging:
  level:
    com: debug
    org: debug

日志截取如下:

org.mybatis.spring.SqlSessionUtils       : Creating a new SqlSession
2020-03-22 11:39:12.627 DEBUG 2248 --- [nio-8888-exec-4] org.mybatis.spring.SqlSessionUtils       : SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7f1802b5] was not registered for synchronization because synchronization is not active
2020-03-22 11:39:13.571 DEBUG 2248 --- [nio-8888-exec-4] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2020-03-22 11:39:13.571 DEBUG 2248 --- [nio-8888-exec-4] o.m.s.t.SpringManagedTransaction         : JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6f83eb84] will not be managed by Spring
2020-03-22 11:39:13.571 DEBUG 2248 --- [nio-8888-exec-4] c.c.f.d.d.f.m.d.TestOqMapper.createUser  : ==>  Preparing: insert into fic_user_test xxx,xxx) values (?,?);
2020-03-22 11:39:13.572 DEBUG 2248 --- [nio-8888-exec-4] c.c.f.d.d.f.m.d.TestOqMapper.createUser  : ==> Parameters: xxxx(String), xxxx(String)
2020-03-22 11:39:13.577 DEBUG 2248 --- [nio-8888-exec-4] c.c.f.d.d.f.m.d.TestOqMapper.createUser  : <==    Updates: 1
2020-03-22 11:39:13.578 DEBUG 2248 --- [nio-8888-exec-4] o.m.s.t.SpringManagedTransaction         : Committing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6f83eb84]
2020-03-22 11:39:13.581 DEBUG 2248 --- [nio-8888-exec-4] org.mybatis.spring.SqlSessionUtils       : Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7f1802b5]

 

看到红色的那行：o.m.s.t.SpringManagedTransaction         : Committing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6f83eb84]

打开SpringManagedTransaction 这个类

 

private void openConnection() throws SQLException {
    this.connection = DataSourceUtils.getConnection(this.dataSource);
    this.autoCommit = this.connection.getAutoCommit();
    this.isConnectionTransactional = DataSourceUtils.isConnectionTransactional(this.connection, this.dataSource);
    LOGGER.debug(() -> {
        return "JDBC Connection [" + this.connection + "] will" + (this.isConnectionTransactional ? " " : " not ") + "be managed by Spring";
    });
}

public void commit() throws SQLException {
    if (this.connection != null && !this.isConnectionTransactional && !this.autoCommit) {
        LOGGER.debug(() -> {
            return "Committing JDBC Connection [" + this.connection + "]";
        });
        this.connection.commit();
    }

}

 

 虽然 ：will not be managed by Spring

但是：在满足条件

if (this.connection != null && !this.isConnectionTransactional && !this.autoCommit)
的时候会执行
this.connection.commit()

 

也就是说在没有使用spring的事务管理的时候spring会自动的执行commit()

 

暂时解惑，至于SpringManagedTransaction  类的原理还有待了解