springboot + oracle 配置多数据源

添加数据库依赖

       <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
        </dependency>

配置数据库连接信息

spring:
  application:
    name: name
  servlet:
    multipart:
      max-file-size: 5MB
      max-request-size: 5MB
  datasource:
    hikari:
      minimum-idle: 2
      maximum-pool-size: 10
      idle-timeout: 60000
      connection-timeout: 30000
      validationTimeout: 3000
      loginTimeout: 5
      conection-test-query: select 1 from dual
      dynamic:
        primary: outside   
        datasource:
          inside:
            driver-class-name: oracle.jdbc.OracleDriver
            url: jdbc:oracle:thin:@ip:port/datasource
            username: name
            password: password
          outside:
            driver-class-name: oracle.jdbc.OracleDriver
            url: jdbc:oracle:thin:@ip:port/WSDJ
            username: name
            password: password

通过注解的方式在类或方法上指定数据源

@DS(inside)