1:在同一个service中嵌套, 如果已经存在外层事务,则nested不会开启新的事务,否则会开启
nested的savepoint是不起作用的, 内层事务回滚会导致整个事务一同回滚
2:在不同的service中嵌套,如果已经存在外层事务,则nested同样不会开启新的事务,否则会开启
但是nested的savepoint是起作用的,即:内层事务回滚 只会影响内层事务,不会导致外层事务一同回滚
先来测试第一种情况
@Transactional(propagation = Propagation.REQUIRED)
@Override
public void save(UserRecord userParam) {
logger.info("开始执行 save {}, {}", userParam.getId(), userParam.getPhone());
userMapper.save(userParam);
try {
logger.info("save 完成---数据库中的值为 {}", userParam.getId());
// if ("15210712347".equals(userParam.getPhone())) {
// throw new RuntimeException();
// }
Thread.sleep(1000);
userParam.setName("xxx");
userParam.setPhone("xxx");
// userService3.save(userParam);
this.update(userParam);
// TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();// 只回滚到内层事务的savepoint
} catch (InterruptedException e) {
e.printStackTrace();
} catch (Exception ae) {
ae.printStackTrace();
}
}
@Transactional(propagation = Propagation.NESTED)
@Override
public Integer update(UserRecord userParam) {
logger.info("开始执行 update {}, {}", userParam.getId(), userParam.getPhone());
// userParam.setId(28);
// userParam.setPhone("15200001234");
userParam.setName("coffee");
int result = userMapper.update(userParam);
try {
logger.info("update 完成---数据库中的值为 {} 开始 sleep");
Thread.sleep(1000 * 10);
logger.info("sleep结束");
// throw new RuntimeException(); //外层事务也回滚
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();//只回滚到内层事务的savepoint
} catch (InterruptedException e) {
e.printStackTrace();
}
return result;
}
2017-12-24 11:18:19 [http-nio-9082-exec-1] INFO c.c.service.impl.UserServiceImpl2 - 开始执行 save null, 15210712345
2017-12-24 11:18:19 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
2017-12-24 11:18:19 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e48d997]
2017-12-24 11:18:19 [http-nio-9082-exec-1] DEBUG o.m.s.t.SpringManagedTransaction - JDBC Connection [com.mysql.jdbc.JDBC4Connection@4528e9b7] will be managed by Spring
2017-12-24 11:18:19 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e48d997]
2017-12-24 11:18:19 [http-nio-9082-exec-1] INFO c.c.service.impl.UserServiceImpl2 - save 完成---数据库中的值为 222639
2017-12-24 11:18:20 [http-nio-9082-exec-1] INFO c.c.service.impl.UserServiceImpl2 - 开始执行 update 222639, xxx
2017-12-24 11:18:22 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e48d997] from current transaction
2017-12-24T11:18:22.883+0800: [GC (Allocation Failure) [PSYoungGen: 28333K->1306K(30720K)] 79340K->52321K(99328K), 0.0054421 secs] [Times: user=0.02 sys=0.00, real=0.01 secs]
2017-12-24 11:18:23 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e48d997]
2017-12-24 11:18:23 [http-nio-9082-exec-1] INFO c.c.service.impl.UserServiceImpl2 - update 完成---数据库中的值为 {} 开始 sleep
2017-12-24 11:18:33 [http-nio-9082-exec-1] INFO c.c.service.impl.UserServiceImpl2 - sleep结束
2017-12-24 11:18:33 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e48d997]
2017-12-24 11:18:33 [http-nio-9082-exec-1] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@e48d997]
接下来测试第二种情况
@Transactional(propagation = Propagation.REQUIRED)
@Override
public void save(UserRecord userParam) {
logger.info("开始执行 save {}, {}", userParam.getId(), userParam.getPhone());
userMapper.save(userParam);
try {
logger.info("save 完成---数据库中的值为 {}", userParam.getId());
// if ("15210712347".equals(userParam.getPhone())) {
// throw new RuntimeException();
// }
Thread.sleep(1000);
userParam.setName("xxx");
userParam.setPhone("xxx");
userService3.save(userParam);
// this.update(userParam);
// TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();// 只回滚到内层事务的savepoint
} catch (InterruptedException e) {
e.printStackTrace();
} catch (Exception ae) {
ae.printStackTrace();
}
}
// service3中的save方法
@Transactional(propagation = Propagation.NESTED)
@Override
public void save(UserRecord userParam) {
logger.info("开始执行 save {}, {}", userParam.getId(), userParam.getPhone());
userMapper.save(userParam);
try {
logger.info("save 完成---数据库中的值为 {} 开始 sleep", userParam.getId());
Thread.sleep(1000);
// throw new RuntimeException();
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();//只回滚到内层事务的savepoint
} catch (InterruptedException e) {
e.printStackTrace();
}
}
通过日志发现 同样不会开启新的事务,但是回滚的时候 内层事务 不会影响到外层事务
2017-12-24 11:29:55 [http-nio-9082-exec-9] INFO c.c.service.impl.UserServiceImpl2 - 开始执行 save null, 15210712345
2017-12-24 11:29:55 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
2017-12-24 11:29:55 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef]
2017-12-24 11:29:55 [http-nio-9082-exec-9] DEBUG o.m.s.t.SpringManagedTransaction - JDBC Connection [com.mysql.jdbc.JDBC4Connection@6fd3f600] will be managed by Spring
2017-12-24 11:29:55 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef]
2017-12-24 11:29:55 [http-nio-9082-exec-9] INFO c.c.service.impl.UserServiceImpl2 - save 完成---数据库中的值为 222642
2017-12-24 11:29:56 [http-nio-9082-exec-9] INFO c.c.service.impl.UserServiceImpl3 - 开始执行 save 222642, xxx
2017-12-24 11:29:56 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef] from current transaction
2017-12-24 11:29:56 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef]
2017-12-24 11:29:56 [http-nio-9082-exec-9] INFO c.c.service.impl.UserServiceImpl3 - save 完成---数据库中的值为 222643 开始 sleep
2017-12-24 11:29:57 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef]
2017-12-24 11:29:57 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef]
2017-12-24 11:29:57 [http-nio-9082-exec-9] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1372e7ef]
本文探讨了Spring事务中的REQUIRED和NESTED传播特性。当在同一个或不同Service中嵌套使用时,NESTED事务如何处理已有事务,并解释了在嵌套事务中保存点的行为,特别是在回滚时对内外层事务的影响。测试结果显示,在嵌套情况下,NESTED事务是否开启新事务以及回滚范围的细节。

3624

被折叠的 条评论
为什么被折叠?



