java - Using AbstractRoutingDataSource to dynamically change the database schema/catalog

Question

According to this article, you can use the AbstractRoutingDataSource from Spring Framework to dynamically change the data source used by the application.

However, the data sources used are defined by configuration, instead of programmatically. Is there a way of configuring the data sources to be used at runtime?

How scalable is this solution, i.e., what are the limitations in number of data sources?

Thanks!

Answer 1

I have implemented this approach for 30 datasources and they are currently running in a Production environment without any issues. If you are using JPA you can have a look at my config:

dynamic-datasource-routing