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