Dynamic Datasource using SpringBoot [duplicate]

Question

I'm writing a Microservice using SpringBoot and I have a requirement to select the datasource dynamically. I will select the datasource based on the parameter. Each datasources will point to Oracle Database that has the same schema (same tables, triggers, stored procedures and etc). How can I implement this requirement?

Answer 1

Configure all datasources at startup, then:

either:

a. Have a different repo class that implements each datasource, check the parameter before calling the corresponding repo.

b. Have one repo class that checks the parameter and uses the corresponding datasource for its queries.