implement dynamically datasource in spring data jpa

Question

I have N Servers, N DBs and N configuration. see the scenario below

So, on every request , I need to access server and db based on configuration.

How can implement dynamically data source in spring data jpa?

Answer 1

You can try AbstractRoutingDatasource provided by Spring since version 2.0.1. using which you can dynamically use appropriate data-source . For integration with Spring data JPA check this very good example. In your case since your configurations are in DB instead of properties file you would need to perform an extra first database lookup to get the appropriate database configuration and return appropriate data-source object.