| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 |
- spring:
- datasource:
- dynamic:
- primary: master
- druid: # 全局druid参数，绝大部分值和默认保持一致。(现已支持的参数如下,不清楚含义不要乱设置)
- # 连接池的配置信息
- # 初始化大小，最小，最大
- initial-size: 5
- min-idle: 5
- maxActive: 20
- # 配置获取连接等待超时的时间
- maxWait: 60000
- # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
- timeBetweenEvictionRunsMillis: 60000
- # 配置一个连接在池中最小生存的时间，单位是毫秒
- minEvictableIdleTimeMillis: 300000
- validationQuery: SELECT 1 FROM DUAL
- testWhileIdle: true
- testOnBorrow: false
- testOnReturn: false
- # 打开PSCache，并且指定每个连接上PSCache的大小
- poolPreparedStatements: true
- maxPoolPreparedStatementPerConnectionSize: 20
- # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
- filters: stat,wall,slf4j
- # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
- connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
- datasource:
- master:
- validationQuery: SELECT 1 FROM DUAL
- driver-class-name: oracle.jdbc.OracleDriver
- url: jdbc:oracle:thin:@//192.168.31.147:1521/orcle
- username: JT
- password: TjJt123456
- chartDataSource:
- validationQuery: SELECT 1 FROM DUAL
- driver-class-name: oracle.jdbc.OracleDriver
- url: jdbc:oracle:thin:@//192.168.31.147:1521/orcle
- username: JT
- password: TjJt123456
- yjDataSource:
- validationQuery: SELECT 1 FROM DUAL
- driver-class-name: oracle.jdbc.OracleDriver
- url: jdbc:oracle:thin:@//192.168.31.147:1521/orcle
- username: JT
- password: TjJt123456
- zjyDataSource:
- validationQuery: SELECT 1 FROM DUAL
- driver-class-name: oracle.jdbc.OracleDriver
- url: jdbc:oracle:thin:@//192.168.31.147:1521/orcle
- username: JT
- password: TjJt123456
|
