how to setup spring data jpa with multiple datasources

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!!!

Solution 1

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

Solution 2

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

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