超简单多数据源集成!MybatisPlus集成多数据源(oracle&mysql)
依赖
所需依赖:com.baomidou.dynamic-datasource-spring-boot-starter
这是mybatisPlus官房提供一个多数据源的配置方案;
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
</dependency>
application.yml配置
这里主要是做多数据源的配置,数据库连接配置;有几个数据源就配置几个,只是有一些细节需要注意;
spring:
autoconfigure:
exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 为了某些版本的springboot @SpringBootApplication(exclude= {
DataSourceAutoConfiguration.class}) 无法生效
datasource:
dynamic:
primary: base #设置默认的数据源或者数据源组,默认值即为master,如果读者只是单数据源只需要注释掉slave相关配置即可,这里为了方便演示master与slave保持相同
datasource:
# oracle数据源1
base:
url: jdbc:oracle:thin:@XXX.XXX.XX.XX:1521:rhipp
username: base
password: 123456
driverClassName: oracle.jdbc.OracleDriver
# oracle数据源2
portal:
url: jdbc:oracle:thin:@XXX.XXX.XX.XX:1521:rhipp
username: app_Portal_system
password: 123456
driverClassName: oracle.jdbc.OracleDriver
# oracle数据源3
rhipp:
url: jdbc:oracle:thin:@XXX.XXX.XX.XX:1521:rhipp
username: rhipp
password: 123456
driverClassName: oracle.jdbc.OracleDriver
# oracle数据源4
platform:
url: jdbc:oracle:thin:@XXX.XXX.XX.XX: