dbcp.properties基本配置

# Database driverClassName

#jdbc.driverClassName=com.p6spy.engine.spy.P6SpyDriver

jdbc.driverClassName=com.mysql.jdbc.Driver

 

# Database URL

jdbc.url=jdbc:mysql://192.168.1.136:3306/mvcs?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true

 

# Database login information

jdbc.username=root

jdbc.password=root

 

#Connection Pooling Info

initialSize=10

maxActive=50

minIdle=5

maxIdle=10

maxWait=10000

timeBetweenEvictionRunsMillis=5000

minEvictableIdleTimeMillis=2000

removeAbandoned=true

removeAbandonedTimeout=60

logAbandoned=true

 

validationQuery=select 1

testOnBorrow=true

testOnReturn=true

testWhileIdle=true