摘要:springboot中使用druid数据源;在application.properties配置数据源信息,使用druidConfig配置数据源
application.properties
# 数据库访问配置 数据库2 spring.datasource.druid.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.druid.driver-class-name=oracle.jdbc.OracleDriver spring.datasource.druid.url=jdbc:oracle:thin:@127.0.0.1:1521:ZHSQFK spring.datasource.druid.username=USR_SHZHFK spring.datasource.druid.password=Zxelec123456 # 下面为连接池的补充设置,应用到上面所有数据源中 spring.datasource.druid.initialSize=5 spring.datasource.druid.minIdle=5 spring.datasource.druid.maxActive=20 spring.datasource.druid.removeAbandoned=true spring.datasource.druid.removeAbandonedTimeout = 600000 spring.datasource.druid.logAbandoned=true # 配置获取连接等待超时的时间 spring.datasource.druid.maxWait=60000 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 spring.datasource.druid.timeBetweenEvictionRunsMillis=60000 # 配置一个连接在池中最小生存的时间,单位是毫秒 spring.datasource.druid.minEvictableIdleTimeMillis=300000 spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL spring.datasource.druid.testWhileIdle=true spring.datasource.druid.testOnBorrow=false spring.datasource.druid.testOnReturn=false # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙 spring.datasource.druid.filters=s