多数据源配置1
a、 job/pom.xml
b、 /resources/dev/application-dev.yml
c、 /job/config/MybatisPlusConfig.java
d、 /job/config/DataSourceContextHolder.java
e、 /job/config/DynamicDataSource.java
f、 /core/enums/DbSourceEnum.java
g、 /job/controller/HomeController.java
- 引包
- yml数据源配置spring节点(配置了德国节点及新加坡节点数据源)
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
datasource:
dynamic:
primary: sqlserver-sg #设置默认的数据源或者数据源组,默认值即为master
strict: false #设置严格模式,默认false不启动. 启动后在未匹配到指定数据源时候会抛出异常,不启动则使用默
datasource:
sqlserver-sg:
driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDri
jdbcUrl: jdbc:sqlserver://10.1.1.146:1443;DatabaseName=DHB
username: b2b_sa
password: '******'
max-active: 100
initial-size: 1
max-wait: 60000
min-idle: 1
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: select 1
test-while-idle: true
test-on-borrow: false
test-on-return: false
pool-prepared-statements: true
max-open-prepared-statements: 50
max-pool-prepared-statement-per-connection-size: 20
sqlserver-de:
driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDri
jdbcUrl: jdbc:sqlserver://10.1.1.146:1443;DatabaseName=DHB
username: b2b_sa
password: '******'
max-active: 100
initial-size: 1
max-wait: 60000
min-idle: 1
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
validation-query: select 1
test-while-idle: true
test-on-borrow: false
test-on-return: false
pool-prepared-statements: true
max-open-prepared-statements: 50
max-pool-prepared-statement-per-connection-size: 20