| 12345678910111213141516171819202122232425262728293031323334 |
- url:jdbc:sqlserver://127.0.0.1:21009;DatabaseName\=RMDB
- driverClassName:com.microsoft.sqlserver.jdbc.SQLServerDriver
- username:zljc
- password:Zljc123!@#
- #url:jdbc:mysql://127.0.0.1:3306/xrserverms
- #driverClassName:com.mysql.jdbc.Driver
- #username:root
- #password:123456
-
- filters:stat
-
- maxActive:20
- initialSize:1
- maxWait:60000
- minIdle:10
- #maxIdle:15
-
- timeBetweenEvictionRunsMillis:60000
- minEvictableIdleTimeMillis:300000
-
- validationQuery:SELECT 'x'
- testWhileIdle:true
- testOnBorrow:false
- testOnReturn:false
- #poolPreparedStatements:true
- maxOpenPreparedStatements:20
- #禁用对于长时间不使用的连接强制关闭的功能
- removeAbandoned:true
- #超过30分钟开始关闭空闲连接,由于removeAbandoned为false,这个设置项不再起作用
- removeAbandonedTimeout:1800
- #将当前关闭动作记录到日志,由于removeAbandoned为false,这个设置项不再起作用
- logAbandoned:true
|