You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

JpaTransactionManager与数据源冲突问题排查求助（Spring 2.5.2）

avatar
DevOps 小满
2026-6-22
问题描述

应用基于Java 11、Spring Boot 2.5.2开发，采用单数据源+单JpaTransactionManager，部署在AWS ECS，使用PostgreSQL数据库。稳定运行8个月后突然报错：

Pre-bound JDBC Connection found! JpaTransactionManager does not support running within DataSourceTransactionManager if told to manage the DataSource itself

已配置spring.autoconfigure.exclude排除org.springframework.boot.autoconfigure.jdbc.DataSourceTransactionManagerAutoConfiguration，但问题仍未解决。

配置代码 

@Bean
@Primary
@DependsOn({
    "env"
})
@Profile("!local")
@Qualifier("pg_RPRDB_DataSource")
public HikariDataSource pg_RPRDB_DataSource() {
    AwsSecrets awsSecrets = secretsConfig == null ? null : secretsConfig.awsSecrets();
    logger.info("Secrets :" + awsSecrets.toString());
    String url = "";
    if (awsSecrets != null) {
        String host = awsSecrets.getRPR_DB_WRITE_HOST() == null ? awsSecrets.getRPR_DB_HOST() : awsSecrets.getRPR_DB_WRITE_HOST();
        logger.info("Filling secrets from AWS secrets RPR DB " + host);
        url = "jdbc:" + awsSecrets.getRPR_DB_ENGINE() + "://" + host + "/" + awsSecrets.getRPR_DB_NAME() + "?jaasApplicationName=pgjdbc" + "&user=" + awsSecrets.getDB_USERNAME();
    }
    logger.info("URL for RPR database" + url);
    HikariDataSource dataSource = new HikariDataSource();
    dataSource.setJdbcUrl(url);
    dataSource.setDriverClassName("org.postgresql.Driver");
    dataSource.setMaximumPoolSize(30);
    dataSource.setMinimumIdle(10);
    dataSource.setIdleTimeout(60000);
    dataSource.setPoolName("RPRDB");
    Properties properties = new Properties();
    properties.setProperty("options", "-c search_path=test,public,pg_catalog -c statement_timeout=5000");
    dataSource.setDataSourceProperties(properties);
    logger.info("Number of max connections : " + dataSource.getMaximumPoolSize());
    return dataSource;
}

@Bean(name = "pg_RPRDB_EntityManager")
public LocalContainerEntityManagerFactoryBean entityManagerFactory(
    EntityManagerFactoryBuilder builder, @Qualifier("pg_RPRDB_DataSource") HikariDataSource dataSource) {
    return builder.dataSource(dataSource)
        .packages("com.icwgroup.ratingsengine.db.entity")
        .persistenceUnit("RPRDB")
        .build();
}

@Bean(name = "pg_RPRDB_TransactionManager")
public PlatformTransactionManager transactionManager(
    @Qualifier("pg_RPRDB_EntityManager") EntityManagerFactory entityManagerFactory) {
    JpaTransactionManager jpaTransactionManager = new JpaTransactionManager();
    jpaTransactionManager.setEntityManagerFactory(entityManagerFactory);
    jpaTransactionManager.setDataSource(pg_RPRDB_DataSource());
    return jpaTransactionManager;
}

错误栈 

at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:400)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at com.icwgroup.ratingsengine.db.repository.RatingDAORepository.saveResponseData(RatingDAORepository.java:118)
at com.icwgroup.ratingsengine.db.repository.RatingDAORepository$$FastClassBySpringCGLIB$$a8f05036.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.retry.interceptor.RetryOperationsInterceptor$1.doWithRetry(RetryOperationsInterceptor.java:93)
at org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:329)
at org.springframework.retry.support.RetryTemplate.execute(RetryTemplate.java:209)
at org.springframework.retry.interceptor.RetryOperationsInterceptor.invoke(RetryOperationsInterceptor.java:119)
at org.springframework.retry.annotation.AnnotationAwareRetryOperationsInterceptor.invoke(AnnotationAwareRetryOperationsInterceptor.java:163)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
at com.icwgroup.ratingsengine.db.repository.RatingDAORepository$$EnhancerBySpringCGLIB$$14188789.saveResponseData(<generated>)
at com.icwgroup.ratingsengine.businesslogic.xldp.XldpProcessor.saveData(XldpProcessor.java:123)
at com.icwgroup.ratingsengine.businesslogic.xldp.XldpProcessor.processXldpRequest(XldpProcessor.java:87)
at com.icwgroup.ratingsengine.api.xldp.XldpApiController.processXldpRequest(XldpApiController.java:31)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1063)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
问题排查与解决方案

核心问题

在transactionManager Bean的创建方法中，直接调用pg_RPRDB_DataSource()创建了一个新的数据源实例，而非注入Spring容器中已存在的pg_RPRDB_DataSource Bean。这导致：

  1. JpaTransactionManager持有的数据源与EntityManagerFactory使用的数据源不是同一个实例
  2. 事务启动时，Spring检测到连接被另一个数据源绑定（实际是两个不同数据源实例引发的冲突），触发报错。

修复步骤

修改transactionManager方法，通过依赖注入获取容器中已有的数据源Bean，而非直接调用方法创建新实例：

@Bean(name = "pg_RPRDB_TransactionManager")
public PlatformTransactionManager transactionManager(
    @Qualifier("pg_RPRDB_EntityManager") EntityManagerFactory entityManagerFactory,
    @Qualifier("pg_RPRDB_DataSource") HikariDataSource dataSource) { // 注入已有的数据源
    JpaTransactionManager jpaTransactionManager = new JpaTransactionManager();
    jpaTransactionManager.setEntityManagerFactory(entityManagerFactory);
    jpaTransactionManager.setDataSource(dataSource); // 使用注入的数据源
    return jpaTransactionManager;
}

额外说明

  • 即便排除了DataSourceTransactionManagerAutoConfiguration，如果JpaTransactionManager和EntityManagerFactory使用不同的数据源实例，依然会触发该错误
  • Spring中直接调用@Bean标注的方法，不会获取容器中的Bean实例，而是创建新对象，这是常见的配置误区
  • 建议保持数据源、EntityManagerFactory、TransactionManager三者使用同一个数据源实例，避免事务管理冲突

内容的提问来源于stack exchange，提问作者VamshiKrishnaYedire

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分)， 限时 9.9 元起

产品介绍相关文档
相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分)， 限时 9.9 元起

产品介绍相关文档
火山引擎 最新活动
全面开放
Doubao-Seedance-2.5全新模型升级

模型再升级,30秒超长叙事, 模态参考扩容

HOT
方舟Codingplan

模型自由，工具不限，最新支持 Deepseek-V4 系列、GLM-5.3 系列

HOT
方舟Agent plan

超全模态模型 × Harness 升级，最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列

HOT
新用户特惠专场

大模型19元起，Al应用9.9元畅享，新人首购爆款尽享优惠

最近更新时间：2026.06.22 11:34:51