MyBatis多数据源配置
实习中接到了新的需求,考虑到适配性,可能会涉及到不同访问方对应不同的数据源,本篇主要叙述MyBatis多数据源的配置方法和其中遇到的坑。
环境:
jdk1.8
MyBatis2.1.0
Maven
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
application.xml
这里的坑就多了
mybatis.mapper-locations= classpath:mapper/*.xml
#数据源1
spring.datasource.vip-local.jdbc-url=jdbc:oracle:thin:@192.168.16.1:1521:orcl
spring.datasource.vip-local.username= test2
spring.datasource.vip-local.password= test2
spring.datasource.vip-local.driver-class-name= oracle.jdbc.driver.OracleDriver
spring.datasource.vip-local.hikari.maximum-pool-size= 10
#数据源2
spring.datasource.vip-docker.jdbc-url=jdbc:oracle:thin:@192.168.16.12:49161:xe
spring.datasource.vip-docker.username= dev
spring.datasource.vip-docker.password= dev
spring.datasource.vip-docker.driver-class-name= oracle.jdbc.driver.OracleDriver
spring.datasource.vip-docker.hikari.maximum-pool-size= 10
classpath不能漏,在Idea中,mapper配置文件的文件夹必须在resource路径下
- 在单数据源时用户名的配置为:
spring.datasource.username= test2