Spring Data + JPA with multiple datasources but only one set of Repositories

by

If you’re really using the different DataSourcees in a multi-tenant kind of way (essentially assigning a request to a DataSource and sticking with it for the entire request) you should have a look at AbstractRoutingDataSource. It essentially provides a way to keep a Map of DataSourcees as well as a callback method to return a key to be used to lookup the DataSource to be used eventually. The implementation of this method usually looks up some thread bound key and return that (or even maps that onto a DataSource map key in turn). You just have to make sure some web component binds that key to the thread in the first place.

If you have that in place your Spring configuration just sets up a bean for your sub-class of AbstractRoutingDataSource and pipes the map of DataSources into it. Your Spring Data JPA setup stays the default way. The EntityManagerFactoryBean refers to the AbstractRoutingDataSource and you have a single <jpa:repositories /> element only.

More Related Contents:

  1. setMaxResults for Spring-Data-JPA annotation?
  2. Using generics in Spring Data JPA repositories
  3. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  4. Handling soft-deletes with Spring JPA
  5. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  6. Spring-Data FETCH JOIN with Paging is not working
  7. Why use returned instance after save() on Spring Data JPA Repository?
  8. How to use @Transactional with Spring Data?
  9. Spring Data JPA: query ManyToMany
  10. Spring Data JPA find by embedded object property
  11. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  12. Dynamic spring data jpa repository query with arbitrary AND clauses
  13. Spring Boot, Spring Data JPA with multiple DataSources
  14. Spring Data JPA – ZonedDateTime format for json serialization
  15. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  16. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  17. Implementing custom methods of Spring Data repository and exposing them through REST
  18. Spring JpaRepository – Detach and Attach entity
  19. Use abstract super class as parameter for Spring data repository
  20. Are you supposed to have one repository per table in JPA?
  21. How to map sql native query result into DTO in spring jpa repository?
  22. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  23. Delete Not Working with JpaRepository
  24. Spring Data JPA: Query by Example?
  25. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  26. How to store @Query sql in external file for CrudRepository?
  27. Spring Data – Multi-column searches
  28. Missing CrudRepository#findOne method
  29. Best way of handling entities inheritance in Spring Data JPA
  30. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories

Leave a Comment