整合Druid

引入依赖

<!-- alibaba的druid数据库连接池 -->
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>${druid-spring-boot-starter}</version>
            </dependency>

连接池配置

druid:
      driver-class-name: oracle.jdbc.OracleDriver
      url: jdbc:oracle:thin:@10.15.22.17:1521:V7DBtest1
      username: PCIS_DEV
      password: PCIS_DEV
      initial-size: 10
      max-active: 30
      min-idle: 10
      max-wait: 10000
      timeBetweenEvictionRunsMillis: 60000
      minEvictableIdleTimeMillis: 30000
      validationQuery: select 1 from dual
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      filters: stat,wall,slf4j
      connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000