I want to connect two different MySQL databases with spring boot application. I want application to be able to communicate with both databases at the same time.
2
-
Just have two datasources and communicate with the correct database when you need to interact with it? There are numerous articles about this subject. Please do some research first. That is a part of your job.KarelG– KarelG2018-05-30 06:34:30 +00:00Commented May 30, 2018 at 6:34
-
Possible duplicate of: stackoverflow.com/questions/30337582/…damjad– damjad2018-05-30 06:35:23 +00:00Commented May 30, 2018 at 6:35
Add a comment
|
1 Answer
You have to decleare different keys for different datasource.
@Bean
@Primary
@ConfigurationProperties("mysql.connection1")
public DataSourceProperties connectionProp1() {
return new DataSourceProperties();
}
@Bean
@Primary
@ConfigurationProperties("mysql.connection1")
public DataSource connection1() {
return connectionProp1().initializeDataSourceBuilder().build();
}
@Bean
@Primary
@ConfigurationProperties("mysql.connection2")
public DataSourceProperties connectionProp2() {
return new DataSourceProperties();
}
@Bean
@Primary
@ConfigurationProperties("mysql.connection2")
public DataSource connection2() {
return connectionProp2().initializeDataSourceBuilder().build();
}
