本文介绍了Spring Boot 配置和使用两个数据源的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何配置和使用两个数据源?
How can I configure and use two data sources?
例如,这是我对第一个数据源所拥有的:
For example here is what I have for the first data source:
application.properties
#first db
spring.datasource.url = [url]
spring.datasource.username = [username]
spring.datasource.password = [password]
spring.datasource.driverClassName = oracle.jdbc.OracleDriver
#second db ...
应用类
@SpringBootApplication
public class SampleApplication
{
public static void main(String[] args) {
SpringApplication.run(SampleApplication.class, args);
}
}
如何修改 application.properties
以添加另一个数据源?我如何自动装配它以供不同的存储库使用?
How do I modify application.properties
to add another data source? How do I autowire it to be used by a different repository?
推荐答案
给你.
在您的 application.properties 文件中添加:
Add in your application.properties file:
#first db
spring.datasource.url = [url]
spring.datasource.username = [username]
spring.datasource.password = [password]
spring.datasource.driverClassName = oracle.jdbc.OracleDriver
#second db ...
spring.secondDatasource.url = [url]
spring.secondDatasource.username = [username]
spring.secondDatasource.password = [password]
spring.secondDatasource.driverClassName = oracle.jdbc.OracleDriver
在任何用@Configuration注解的类中添加以下方法:
Add in any class annotated with @Configuration the following methods:
@Bean
@Primary
@ConfigurationProperties(prefix="spring.datasource")
public DataSource primaryDataSource() {
return DataSourceBuilder.create().build();
}
@Bean
@ConfigurationProperties(prefix="spring.secondDatasource")
public DataSource secondaryDataSource() {
return DataSourceBuilder.create().build();
}
这篇关于Spring Boot 配置和使用两个数据源的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!