jdbc.properties

# Driver class name
jdbc.driverClassName=com.mysql.jdbc.Driver
# Database URL
#local server
jdbc.url=jdbc:mysql://192.168.1.1:3306/mysql?zeroDateTimeBehavior=convertToNull
# 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=20


#每18000秒检查所有连接池中的空闲连接。Default: 0 
cpool.idleConnectionTestPeriod=18000
#在每个connection提交的时候都将校验其有效性
cpool.testConnectionOnCheckout=true
#c3p0将建一张名为TEST的空表，并使用其自带的查询语句进行测试。
cpool.automaticTestTable=TEST


# How long to keep unused connections around(in seconds)
# Note:MySql times out idle connections after 8 hours(28800 seconds)
# so ensure this value is below MySql idle timeout
cpool.maxIdleTime=25000


# How long to hang on excess unuserd connections after traffic spike
cpool.maxIdleTimeExcessConnection=1800


# Acquiring new connections is slow, so eagerly retrieve extra connection when current pool size is reached
cpool.acquireIncrement=3
#初始化连接数
cpool.initialPoolSize=10
#自动重连
cpool.autoCommitOnClose=true