###### druid 连接池驱动配置信息############# spring.datasource.type=com.alibaba.druid.pool.DruidDataSource #mysql #spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver #spring.datasource.url = jdbc:mysql://localhost:3306/test?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=GMT%2B8 #spring.datasource.username = root #spring.datasource.password = root #oracle spring.datasource.url = jdbc:oracle:thin:@//192.168.0.166:1521/PDBFJ spring.datasource.driverClassName = oracle.jdbc.driver.OracleDriver spring.datasource.username=basefj spring.datasource.password=rootroot #连接池的配置信息 # 初始化大小,最小,最大 spring.datasource.initialSize=5 spring.datasource.minIdle=5 spring.datasource.maxActive=20 # 配置获取连接等待超时的时间 spring.datasource.maxWait=60000 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 spring.datasource.timeBetweenEvictionRunsMillis=60000 # 配置一个连接在池中最小生存的时间,单位是毫秒 spring.datasource.minEvictableIdleTimeMillis=300000 #测试连接 #spring.datasource.validationQuery=SELECT 1 FROM DUAL spring.datasource.validationQuery=SELECT * FROM SYS_USERS #申请连接的时候检测,建议配置为true,不影响性能,并且保证安全性 spring.datasource.testWhileIdle=true #获取连接时执行检测,建议关闭,影响性能 spring.datasource.testOnBorrow=false #归还连接时执行检测,建议关闭,影响性能 spring.datasource.testOnReturn=false #是否开启PSCache,PSCache对支持游标的数据库性能提升巨大,oracle建议开启,mysql下建议关闭 spring.datasource.poolPreparedStatements=false #开启poolPreparedStatements后生效 spring.datasource.maxPoolPreparedStatementPerConnectionSize=20 # 配置监控统计拦截的filters,去掉
|