spring add datasource at runtime

11
votes

I am working on a spring boot multi-tenant application with database per tenant strategy. Requirement is that to add new databases at runtime which means I have to create new datasource objects dynamically.

I also looked upon Spring's AbstractRoutingDataSource but in needs pre-defined datasources. So I just want to know how to add/remove datasource without restarting application server.

Thanks in advance.

1
javaspringruntimedatasourcemulti-tenant

1 Answers

13
votes

I finally managed to get things working straight. For someone having same issue, just check this multi-tenant demo project.