本贴主要讲解配置多数据源
springboot+jpa的整合需要自行准备好
1.maven中要导入Oracle和SqlServer的jar包
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!--oracle驱动 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
<scope>system</scope>
<systemPath>${xxx}/src/main/webapp/WEB-INF/lib/ojdbc6-11.2.0.3.jar</systemPath>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.1.0.7.0</version>
<scope>system</scope>
<systemPath>${xxx}/src/main/webapp/WEB-INF/lib/ojdbc6.jar</systemPath>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc5</artifactId>
<version>11.1.0.7.0</version>
<scope>system</scope>
<systemPath>${xxx}/src/main/webapp/WEB-INF/lib/ojdbc5.jar</systemPath>
</dependency>
<!--SQL server-->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0.0</version>
</dependency>
2.在yml文件中配置双数据源等信息
spring:
datasource:
database1:
# --------------- Oracle -----------------#
driver-class-name: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@IP:端口:数据库
username: xxxx
password: xxxx
database2:
# --------------- SQL Server -----------------#
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
url: jdbc:sqlserver://localhost:1433;DatabaseName=数据库
username: xxxx
password: xxxx
#配置 Jpa
jpa:
database: mysql