Spring事务回滚问题分析

最新推荐文章于 2024-05-03 13:13:36 发布

Michael_ZJQ

最新推荐文章于 2024-05-03 13:13:36 发布

阅读量310

点赞数 4

分类专栏：经验总结文章标签： spring python java

本文链接：https://blog.csdn.net/aaaqiang52411314/article/details/136782662

版权

经验总结专栏收录该内容

5 篇文章 0 订阅

订阅专栏

情况一. ServiceA调用ServiceB，ServiceB异常不处理

@Service
public class ServiceA {

    @Resource
    private ServiceB serviceB;
    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodA() {
        User user = new User();
        user.setName("zhang");
        user.setAge(18);
		serviceB.methodB(user);

        User user1 = new User();
        user1.setName("zhang1");
        user1.setAge(19);
        userMapper.insert(user1);

        
    }
}

@Service
public class ServiceB {

    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodB(User user){
        userMapper.insert(user);
        int i = 1/0;
    }
}

结果：表中没有数据

在这里插入图片描述
日志输出：

work.jdbc.support.JdbcTransactionManager.etTransaction 370 : Creating new transaction with name [org.zhang.myproject.transactiontest.ServiceA.methodA]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception
work.jdbc.support.JdbcTransactionManager.ocessRollback 842 : Participating transaction failed - marking existing transaction as rollback-only
work.jdbc.support.JdbcTransactionManager.tRollbackOnly 359 : Setting JDBC transaction [HikariProxyConnection@762570948 wrapping com.mysql.cj.jdbc.ConnectionImpl@6ce2e079] rollback-only
work.jdbc.support.JdbcTransactionManager.ocessRollback 833 : Initiating transaction rollback
work.jdbc.support.JdbcTransactionManager.   doRollback 345 : Rolling back JDBC transaction on Connection [HikariProxyConnection@762570948 wrapping com.mysql.cj.jdbc.ConnectionImpl@6ce2e079]

情况二. ServiceA调用ServiceB，ServiceB异常处理

@Service
public class ServiceA {

    @Resource
    private ServiceB serviceB;
    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodA() {
        User user = new User();
        user.setName("zhang");
        user.setAge(18);
		serviceB.methodB(user);

        User user1 = new User();
        user1.setName("zhang1");
        user1.setAge(19);
        userMapper.insert(user1);

        
    }
}
@Service
public class ServiceB {

    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodB(User user){

        userMapper.insert(user);
        try {
            int i = 1/0;
        }catch (Exception e){
            e.printStackTrace();
        }

    }
}

结果：表中有数据，且都插入成功
在这里插入图片描述
日志输出：

work.jdbc.support.JdbcTransactionManager.etTransaction 370 : Creating new transaction with name [org.zhangjq.myproject.transactiontest.ServiceA.methodA]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception
work.jdbc.support.JdbcTransactionManager.ngTransaction 470 : Participating in existing transaction
work.jdbc.support.JdbcTransactionManager.processCommit 740 : Initiating transaction commit
work.jdbc.support.JdbcTransactionManager.     doCommit 330 : Committing JDBC transaction on Connection [HikariProxyConnection@942494874 wrapping com.mysql.cj.jdbc.ConnectionImpl@2eb6d34a]
work.jdbc.support.JdbcTransactionManager.terCompletion 389 : Releasing JDBC Connection [HikariProxyConnection@942494874 wrapping com.mysql.cj.jdbc.ConnectionImpl@2eb6d34a] after transaction

情况三. ServiceA调用ServiceB，ServiceB异常在ServiceA中处理

@Service
public class ServiceA {

    @Resource
    private ServiceB serviceB;
    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodA() {
        User user = new User();
        user.setName("zhang");
        user.setAge(18);
        try {
            serviceB.methodB(user);
        }catch (Exception e){
            e.printStackTrace();
        }

        User user1 = new User();
        user1.setName("zhang1");
        user1.setAge(19);
        userMapper.insert(user1);
        
    }
}
@Service
public class ServiceB {

    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodB(User user){

        userMapper.insert(user);
        int i = 1/0;

    }
}

结果：表中没有数据
在这里插入图片描述
日志输出：

work.jdbc.support.JdbcTransactionManager.etTransaction 370 : Creating new transaction with name [org.zhangjq.myproject.transactiontest.ServiceA.methodA]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception
work.jdbc.support.JdbcTransactionManager.ngTransaction 470 : Participating in existing transaction
Participating transaction failed - marking existing transaction as rollback-only
work.jdbc.support.JdbcTransactionManager.tRollbackOnly 359 : Setting JDBC transaction [HikariProxyConnection@942494874 wrapping com.mysql.cj.jdbc.ConnectionImpl@2eb6d34a] rollback-only
work.jdbc.support.JdbcTransactionManager.       commit 705 : Global transaction is marked as rollback-only but transactional code requested commit
work.jdbc.support.JdbcTransactionManager.ocessRollback 833 : Initiating transaction rollback
work.jdbc.support.JdbcTransactionManager.   doRollback 345 : Rolling back JDBC transaction on Connection [HikariProxyConnection@942494874 wrapping com.mysql.cj.jdbc.ConnectionImpl@2eb6d34a]
work.jdbc.support.JdbcTransactionManager.terCompletion 389 : Releasing JDBC Connection [HikariProxyConnection@942494874 wrapping com.mysql.cj.jdbc.ConnectionImpl@2eb6d34a] after transaction

情况四. ServiceA调用ServiceB，ServiceB异常在ServiceA中处理，ServiceB是新事物

@Service
public class ServiceA {

    @Resource
    private ServiceB serviceB;
    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodA() {
        User user = new User();
        user.setName("zhang");
        user.setAge(18);
        try {
            serviceB.methodB(user);
        }catch (Exception e){
            e.printStackTrace();
        }

        User user1 = new User();
        user1.setName("zhang1");
        user1.setAge(19);
        userMapper.insert(user1);
        
    }
}
@Service
public class ServiceB {

    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class,propagation = Propagation.REQUIRES_NEW)
    public void methodB(User user){

        userMapper.insert(user);
        int i = 1/0;

    }
}

结果：表中有数据，ServiceA数据插入成功，ServiceB数据回滚
在这里插入图片描述
日志输出：

work.jdbc.support.JdbcTransactionManager.etTransaction 370 : Creating new transaction with name [org.zhangjq.myproject.transactiontest.ServiceA.methodA]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception
work.jdbc.support.JdbcTransactionManager.ngTransaction 429 : Suspending current transaction, creating new transaction with name [org.zhangjq.myproject.transactiontest.ServiceB.methodB]
work.jdbc.support.JdbcTransactionManager.ocessRollback 833 : Initiating transaction rollback
work.jdbc.support.JdbcTransactionManager.   doRollback 345 : Rolling back JDBC transaction on Connection [HikariProxyConnection@773865813 wrapping com.mysql.cj.jdbc.ConnectionImpl@27dc335a]
work.jdbc.support.JdbcTransactionManager.terCompletion 996 : Resuming suspended transaction after completion of inner transaction
work.jdbc.support.JdbcTransactionManager.processCommit 740 : Initiating transaction commit
work.jdbc.support.JdbcTransactionManager.     doCommit 330 : Committing JDBC transaction on Connection [HikariProxyConnection@903904793 wrapping com.mysql.cj.jdbc.ConnectionImpl@a1e912f]
work.jdbc.support.JdbcTransactionManager.terCompletion 389 : Releasing JDBC Connection [HikariProxyConnection@903904793 wrapping com.mysql.cj.jdbc.ConnectionImpl@a1e912f] after transaction

情况五. ServiceA调用ServiceB，ServiceB异常处理，ServiceB是新事物

@Service
public class ServiceA {

    @Resource
    private ServiceB serviceB;
    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    public void methodA() {
       User user = new User();
        user.setName("zhang");
        user.setAge(18);
        serviceB.methodB(user);
        
        User user1 = new User();
        user1.setName("zhang1");
        user1.setAge(19);
        userMapper.insert(user1);
        
    }
}
@Service
public class ServiceB {

    @Resource
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class,propagation = Propagation.REQUIRES_NEW)
    public void methodB(User user){

        userMapper.insert(user);
        try {
            int i = 1/0;
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}

结果：表中有数据，ServiceA数据插入成功，ServiceB数据插入成功
在这里插入图片描述
日志输出：

work.jdbc.support.JdbcTransactionManager.etTransaction 370 : Creating new transaction with name [org.zhangjq.myproject.transactiontest.ServiceA.methodA]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception
work.jdbc.support.JdbcTransactionManager.ngTransaction 429 : Suspending current transaction, creating new transaction with name [org.zhangjq.myproject.transactiontest.ServiceB.methodB]
work.jdbc.support.JdbcTransactionManager.processCommit 740 : Initiating transaction commit
work.jdbc.support.JdbcTransactionManager.     doCommit 330 : Committing JDBC transaction on Connection [HikariProxyConnection@1356763258 wrapping com.mysql.cj.jdbc.ConnectionImpl@1fd37440]
work.jdbc.support.JdbcTransactionManager.terCompletion 389 : Releasing JDBC Connection [HikariProxyConnection@1356763258 wrapping com.mysql.cj.jdbc.ConnectionImpl@1fd37440] after transaction
work.jdbc.support.JdbcTransactionManager.terCompletion 996 : Resuming suspended transaction after completion of inner transaction
work.jdbc.support.JdbcTransactionManager.processCommit 740 : Initiating transaction commit
work.jdbc.support.JdbcTransactionManager.     doCommit 330 : Committing JDBC transaction on Connection [HikariProxyConnection@762570948 wrapping com.mysql.cj.jdbc.ConnectionImpl@6ce2e079]
work.jdbc.support.JdbcTransactionManager.terCompletion 389 : Releasing JDBC Connection [HikariProxyConnection@762570948 wrapping com.mysql.cj.jdbc.ConnectionImpl@6ce2e079] after transaction

总结：

根据情况二和情况五得知：在ServiceB中处理异常，无论ServiceA和ServiceB是否在同一个事务中，都不会回滚
根据情况三得知：ServiceB不处理异常，ServiceA处理异常时，事务被标记成不可提交状态，故而数据都不能提交
根据情况四得知：若想解决情况三的问题，ServiceA的数据正常入库，则需要设置成不属于同一事务即可
若想解决问题三，另外方法就是将ServiceB的方法放到ServiceA中，属于方法内部调用，ServiceB的方法相当于没有事务（没有代理），即，不走代理的同一个事务内，异常被catch后，不会回滚。
总结4间接的解释了总结1中的情况

完整代码：

代码gitee

Michael_ZJQ

关注

4
点赞
踩
8

收藏

觉得还不错? 一键收藏
1
评论
Spring事务回滚问题分析

根据情况二和情况五得知：在ServiceB中处理异常，无论ServiceA和ServiceB是否在同一个事务中，都不会回滚根据情况三得知：ServiceB不处理异常，ServiceA处理异常时，事务被标记成不可提交状态，故而数据都不能提交根据情况四得知：若想解决情况三的问题，ServiceA的数据正常入库，则需要设置成不属于同一事务即可。
复制链接

扫一扫