How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction

by

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

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

This transaction manager also supports direct DataSource access within a transaction (i.e. plain JDBC code working with the same DataSource). This allows for mixing services which access JPA and services which use plain JDBC (without being aware of JPA)! Application code needs to stick to the same simple Connection lookup pattern as with DataSourceTransactionManager (i.e. DataSourceUtils.getConnection(javax.sql.DataSource) or going through a TransactionAwareDataSourceProxy). Note that this requires a vendor-specific JpaDialect to be configured.

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>

More Related Contents:

  1. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  2. Transaction marked as rollback only: How do I find the cause
  3. How to integrate spring with hibernate session and transaction management?
  4. Invalidating JPA EntityManager session
  5. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  6. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  7. How does spring.jpa.hibernate.ddl-auto property exactly work in Spring?
  8. Mapping many-to-many association table with extra column(s)
  9. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  10. Spring Data JPA map the native query result to Non-Entity POJO
  11. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  12. @OrderColumn annotation in Hibernate 3.5
  13. How to query data for Primefaces dataTable using lazy loading and pagination
  14. Does the JPA specification allow references to non-primary key columns?
  15. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  16. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  17. Hibernate: How specify custom sequence generator class name using annotations?
  18. Deleted object would be re-saved by cascade (remove deleted object from associations)
  19. Spring JpaRepository – Detach and Attach entity
  20. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  21. JPA CriteriaBuilder – How to use “IN” comparison operator
  22. Spring @Transactional with a transaction across multiple data sources
  23. How to rollback a database transaction when testing services with Spring in JUnit?
  24. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture
  25. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  26. How to configure transaction management for working with 2 different db in Spring?
  27. Difference between LockModeType Jpa
  28. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  29. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment