c3p0.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
?
?
# Time to wait for an open connection before timing out
# (in milliseconds)
cpool.checkoutTimeout=5000
?
# Connection pool size
cpool.minPoolSize=5
cpool.maxPoolSize=200
?
# How long to keep unused connections around(in seconds)
# Note: MySQL times out idle connections after 8 hours(28,800 seconds)
# so ensure this value is below MySQL idle timeout
cpool.maxIdleTime=600
?
# How long to hang on to excess unused connections after traffic spike
# (in seconds)
cpool.maxIdleTimeExcessConnections=100
?
# Acquiring new connections is slow, so eagerly retrieve extra connections
# when current pool size is reached
cpool.acquireIncrement=5
?
#
cpool.acquireRetryAttempts=30
?
#
cpool.breakAfterAcquireFailure=true
cpool.testConnectionOnCheckout=true
cpool.testConnectionOnCheckin=true
cpool.preferredTestQuery=SELECT 1
#
cpool.idleConnectionTestPeriod=600
?
