0

We are developing a web application where it deals with more than 1 data bases using spring jpa. A login screen which allows the user to select the country and market. we have multiple databases and each database with respect to one country and market. So we decided that we plan to load all datasources (at present we have 10 databases). I have few questions on this.

  1. is it good practice to load all databases at once while application startup? (Later we may go with few more countries also) 2.We are planning to have single entity manager factory for all the data bases we load . can we acheive this using spring jpa ? 3.If we have a single entity manager, how we can handle the connection pooling for each database we load.

appreciate your help..

Ven
  • 31
  • 1
  • 6
  • 1
    Looks like [multi-tenant project](https://stackoverflow.com/a/49783853/5380322)... – Cepr0 May 02 '18 at 08:20
  • Check this link [StackOverflow link](https://stackoverflow.com/questions/26308035/spring-boot-spring-data-jpa-with-multiple-datasources). It may help to solve your issue. – Vignesh May 02 '18 at 08:27
  • Hi Cepr0, i would like to go with the spring 4 and jpa with this multi tenant but not with spring boot. is it possible? – Ven May 02 '18 at 14:40
  • @Vignesh, i am seeing the implementation in spring boot. if we go with multi tenant aproach are we loading all the datasources and keeping. – Ven May 02 '18 at 17:45

0 Answers0