[错误报告]: updateBatchById方法增加了Transactional注解，外层使用DSTransactional,导致：Could not open JPA EntityManager for transaction

Author: haskxCreated Aug 19, 2026Updated Aug 24, 2026

确认

我使用的版本是最新版, 并且使用插件确认过项目里无依赖版本冲突
我已经在 issue 中搜索过, 确认问题没有被提出过
我已经修改标题, 将标题中的描述替换为遇到的问题(不得删除描述前面的部分)

当前程序版本

3.5.4

问题描述

替换到3.5.17 仍有此问题。可能原因：第一个 @DSTransactional 事务里抓到一根数据库连接后"抓住不放"（Hibernate 默认 HOLD 模式）；第一个事务收尾时 dynamic-datasource 把这根连接真关了，Session 仍攥着这根死连接；第二个事务里 MyBatis-Plus 批量方法自带的 @Transactional 复用该 Session，对死连接开启事务 → connection closed。

是否可以解决。

详细堆栈日志

bash

org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.TransactionException: JDBC begin transaction failed: 
	at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:467) ~[spring-orm-5.3.31.jar!/:5.3.31]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) ~[spring-tx-5.3.31.jar!/:5.3.31]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-5.3.31.jar!/:5.3.31]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:595) ~[spring-tx-5.3.31.jar!/:5.3.31]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:382) ~[spring-tx-5.3.31.jar!/:5.3.31]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.31.jar!/:5.3.31]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.31.jar!/:5.3.31]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) ~[spring-aop-5.3.31.jar!/:5.3.31]
	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:57) ~[dynamic-datasource-spring-4.3.0.jar!/:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.31.jar!/:5.3.31]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) ~[spring-aop-5.3.31.jar!/:5.3.31]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) ~[spring-aop-5.3.31.jar!/:5.3.31]
	at com.chint.anneng.eam.settlement.domain.zf.queryservice.XXXQueryService$$EnhancerBySpringCGLIB$$f3873601.updateBatchById(<generated>) ~[XXX-domain-1.0.8-SNAPSHOT.jar!/:na]

Source: baomidou/mybatis-plus

View original on GitHub View discussion on GitHub