如何配置Spring使JPA（Hibernate）和JDBC（JdbcTemplate或MyBatis）共享相同的事务

问题描述

我有一个数据源，我使用Spring 3.0.3，Hibernate 3.5.1作为JPA提供程序，我使用MyBatis 3.0.2进行一些查询，我的应用程序在Tomcat 6上运行。我有一个HibernateDAO和一个MyBatisDAO，当我使用@Transactional注释的相同方法调用它们，看起来他们不共享相同的事务，他们获得不同的连接。

我该如何让他们做到这一点？

I have a single dataSource, I use Spring 3.0.3, Hibernate 3.5.1 as JPA provider and I use MyBatis 3.0.2 for some queries and my app runs on Tomcat 6. I have a HibernateDAO and a MyBatisDAO, when I call both from the same method which is annotated with @Transactional it looks like they don't share the same transaction, they get different connections.
How can I make them to do?

我尝试从DataSourceUtils.getConnection（dataSource）获取连接，被MyBatis使用，这很奇怪，我认为问题出在MyBatis配置中，它不能使用JpaTransactionManager。甚至多次调用DataSoruceUtils.getConnection总是给出相同的连接，这是正常的。

I've tried getting a connection from DataSourceUtils.getConnection(dataSource) and I get the one which is used by MyBatis which is strange I thought the problem was in MyBatis config and it can't use JpaTransactionManager. Even calling multiple times DataSoruceUtils.getConnection gives the same connection always, which is ok.

经过一些Google搜索之后，我尝试了spring-instrument-tomcat的类加载器（尽管我不' ））

After some googling I've tried spring-instrument-tomcat's classloader (although I don't know if tomcat really uses it :))

部分applicationContext

partial applicationContext

<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource">
    <property name="driverClassName" value="${database.driverClassName}"/>
    <property name="url" value="${database.url}"/>
    <property name="username" value="${database.username}"/>
    <property name="password" value="${database.password}"/>
</bean>

<bean class="org.springframework.orm.jpa.JpaTransactionManager" id="transactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>

<tx:annotation-driven mode="aspectj" transaction-manager="transactionManager"/>

<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="entityManagerFactory">
    <property name="dataSource" ref="dataSource"/>
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="configLocation" value="classpath:META-INF/mybatis/mybatis-config.xml" />
</bean>

部分mybatis配置

partial mybatis config

<settings>
    <setting name="cacheEnabled" value="false" />
    <setting name="useGeneratedKeys" value="false" />
    <setting name="defaultExecutorType" value="REUSE" />
    <setting name="lazyLoadingEnabled" value="false"/>
</settings>

部分persistence.xml

partial persistence.xml

<persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>

推荐答案

我在这里找到了解决方案：

I've found the solution here: What transaction manager should I use for JBDC template When using JPA ?

我使用JpaTransactionManager而不是DataSourceTransactionManager。

JavaDoc

I'm using JpaTransactionManager and not DataSourceTransactionManager.
JavaDoc http://static.springsource.org/spring/docs/3.0.x/javadoc-api/org/springframework/orm/jpa/JpaTransactionManager.html

在将jpaVendorAdapter添加到我的entityManagerFactory配置一切正常，JdbcTemplate查询和MyBatis在预期的同一事务中运行。基于JavaDoc，我猜jpaDialect应该够用了，但现在已经是凌晨4点了，所以我现在不会尝试：）

After I've added jpaVendorAdapter to my entityManagerFactory config everything works, both JdbcTemplate query and MyBatis runs in the same transaction as expected. Based on the JavaDoc I guess a jpaDialect should be enough but it's 4 a.m. here so I won't try that now :)

<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="entityManagerFactory">
    <property name="persistenceUnitName" value="persistenceUnit"/>
    <property name="dataSource" ref="dataSource"/>
    <property name="jpaVendorAdapter">
        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
            <property name="showSql" value="true" />
            <property name="generateDdl" value="true" />
            <property name="databasePlatform" value="org.hibernate.dialect.PostgreSQLDialect" />
        </bean>
    </property>
</bean>

这篇关于如何配置Spring使JPA（Hibernate）和JDBC（JdbcTemplate或MyBatis）共享相同的事务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！