jdbc mysql 重连_mysql重连的问题

应用在长时间不连mysql后会与mysql断开，再次链接mysql时会报无法连接数据库的异常，所以连接的配置需要稍微改一下：

factory="org.apache.naming.factory.BeanFactory" driverClass="com.mysql.jdbc.Driver"

maxPoolSize="10" minPoolSize="6" acquireIncrement="10" name="JDBC/ACS"

autoCommitOnClose="true" initialPoolSize="6" maxIdleTime="7200"

preferredTestQuery="select 1;" idleConnectionTestPeriod="18000" maxIdleTimeExcessConnections="1800" jdbcUrl="jdbc:mysql://127.0.0.1:3306/asd?useUnicode=true&characterEncoding=utf-8&autoReconnect=true" />

auth="Container"

type="javax.sql.DataSource"

driverClassName="org.gjt.mm.mysql.Driver"

url="jdbc:mysql://127.0.0.1:3306/dbname?characterEncoding=UTF-8"

username="******"

password="******"

maxActive="500"

maxIdle="30"

maxWait="10000"

validationQuery = "SELECT 1"

testWhileIdle = "true"

timeBetweenEvictionRunsMillis = "3600000"

minEvictableIdleTimeMillis = "18000000"

testOnBorrow = "true"/>

上面的是C3P0的配置，下面的DBCP的配置。