how to setup spring data jpa with multiple datasou

Question

I am using Spring Data Jpa version 1.0.0.M2 here is the url: http://static.springsource.org/spring-data/data-jpa/docs/1.0.0.M2/reference/pdf/spring-data-jpa-reference.pdf

All is promised to be very simple and nice, but when it comes to two datasources it breaks down. The question is how to setup with two data sources? The JpaRepository automatically searches for EntityManager, when it finds more than two it throws exceptions.

If you have any idea with EntityManager and how to setup the spring data jpa, please post a reply. Your help is truly appreciated!!!

Answer 1

Are you looking to use 'EntityManager-A' with Spring Data JPA and 'EntityManager-B' for another data access layer? Mark

Answer 2

<jpa:repositories base-package="org.springframework.data.jpa.repository.sample"
    entity-manager-factory-ref="secondEntityManagerFactory" />

Answer 3

You can use a dynamic datasource that wrap your two datasources, as explained here:

http://blog.springsource.com/2007/01/23/dynamic-datasource-routing/