techhero-project-track-dev.yml 2.27 KB
Newer Older
1 2 3 4
#数据源
rdsdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@192.168.0.196:1521:orcl
5 6
  username: sjgz
  password: sjgz
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true

jckdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@192.168.0.196:1521:orcl
  username: jcsjv2
  password: jcsjv2
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true