mysql重连的问题

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

<Resource auth="Container" type="com.mchange.v2.c3p0.ComboPooledDataSource" user="root" password="dragon"
              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&amp;characterEncoding=utf-8&amp;autoReconnect=true" />






    <Resource name="jdbc/dbname"
        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的配置。