How to configure transaction management for working with 2 different db in Spring?

by

The javadoc for JpaTransactionManager has some advice on this:

This transaction manager is
appropriate for applications that use
a single JPA EntityManagerFactory for
transactional data access. JTA
(usually through
JtaTransactionManager) is necessary
for accessing multiple transactional
resources within the same transaction.
Note that you need to configure your
JPA provider accordingly in order to
make it participate in JTA
transactions.

In other words, if you find yourself with multiple entity managers, with corresponding tx managers, then you should consider using a single JtaTransactionManager instead. The entity managers should be able to participate in JTA transactions, and this will give you full transactionality across both entity managers, without hacving to worry about which entity manager you’re in at any one time.

Of course, JtaTransactionManager does require a full JTA-supporting application server, rather than a vanilla servlet engine like Tomcat.

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. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  4. How to return a custom object from a Spring Data JPA GROUP BY query
  5. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  6. Spring Boot, Spring Data JPA with multiple DataSources
  7. Using generics in Spring Data JPA repositories
  8. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  9. Handling soft-deletes with Spring JPA
  10. Persistence unit as RESOURCE_LOCAL or JTA?
  11. @Transactional method called from another method doesn’t obtain a transaction
  12. Spring – Is it possible to use multiple transaction managers in the same application?
  13. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  14. Spring JPA @Query with LIKE
  15. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  16. Change database schema during runtime based on logged in user
  17. How to use @Transactional with Spring Data?
  18. How to map sql native query result into DTO in spring jpa repository?
  19. javax.transaction.Transactional vs org.springframework.transaction.annotation.Transactional
  20. How to rollback a database transaction when testing services with Spring in JUnit?
  21. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  22. Understanding Spring transactions – What happens when a transactional method calls another transactional method?
  23. Hibernate, spring, JPS & isolation – custom isolation not supported
  24. JSR303 custom validators being called twice
  25. Where to put @Transactional? In interface specification or implementation? [duplicate]
  26. DAO and Service layers (JPA/Hibernate + Spring) [duplicate]
  27. Creating a post commit when using transaction in Spring
  28. java.lang.IllegalStateException: No transactional EntityManager available
  29. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  30. How to find distinct rows with field in list using JPA and Spring?

Leave a Comment