Spring Boot : How to add new Datasource at runtime

Question

My project want to connect two datasource.

The first datasource I can Config in application.properties but the second datasource can't config because this config is in the tableConfig from DB of the first datasource.

So,

config the 1st datasource.
query data from the 1st datasource for get config of 2nd datasource (url, username, password).
add new 2nd datasource

Now, I config two Datasource from application.properties and it's work.

But the requirement want to change the 2nd datasource from table of 1st datasource. T.T

Please, gives me some suggestions.

Thank you.

try this http://www.baeldung.com/spring-data-jpa-multiple-databases — Ganesh Gudghe, Jun 26 '18 at 10:00
Possible duplicate of [Spring Boot Configure and Use Two DataSources](https://stackoverflow.com/questions/30337582/spring-boot-configure-and-use-two-datasources) — TOvidiu, Jun 26 '18 at 10:00
Now I config 2 Datasource from application.properties and it's work. But the requirement want to change the 2nd datasource from table of 1st datasource. T.T — methodplayer, Jun 26 '18 at 10:06

score 0 · Answer 1 · answered Jun 26 '18 at 10:50

A Spring configuration like this should work (consider it pseudo code):

@Bean("secondDatasource")
public Datasource secondDatasource(@Qualifier("firstDatasource") Datasource ds){
    // use `ds` to obtain the necessary information to obtain a datasource ...
    return DataSourceBuilder
        .create()
        .username(username)
        .password(pwd)
        .url(url)
        .driverClassName(driver)
        .build();
}

I would at least start without using Spring Data JPA in the configuration class and operate directly on the data source to keep things simple.

You already got pointers, how to set up Spring Data JPA to then use the different data sources: http://www.baeldung.com/spring-data-jpa-multiple-databases

The code above is mainly just copied from: https://stackoverflow.com/a/28822145

Spring Boot : How to add new Datasource at runtime

1 Answers1