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