到网上查了好多资料说是mysql8小时问题,解决方法是修改mysql5的配置文件“my.ini”中的[mysqld]后面添加上: wait_timeout=1814400 
重新启动mysql5。 
我照着修改了,但是还是报错,请各位高手帮忙解决一下。多谢!

解决方案 »

  1.   

    我用了c3p0连接池,下面是我的配置,麻烦帮忙看一下,有什么问题吗?
    属性文件:
    datasource.type=mysql
    #sqlserver
    datasource.driverClassName=org.gjt.mm.mysql.Driver
    #com.microsoft.sqlserver.jdbc.SQLServerDriver
    datasource.url=jdbc:mysql://localhost:3306/shose?useUnicode=true&characterEncoding=UTF-8
    #jdbc:sqlserver://localhost:1433;DatabaseName=shose
    datasource.username=root
    #bbs_manage
    datasource.password=rootdatasource.maxActive=20
    datasource.maxIdle=4
    datasource.maxWait=120000
    datasource.whenExhaustedAction=1
    datasource.validationQuery=select 1 from dual
    datasource.testOnBorrow=true
    datasource.testOnReturn=falsec3p0.acquireIncrement=6
    c3p0.acquireRetryAttempts=30    
    c3p0.acquireRetryDelay=30000       
    c3p0.autoCommitOnClose=false
    c3p0.breakAfterAcquireFailure=false
    c3p0.initialPoolSize=20
    c3p0.minPoolSize=10
    c3p0.maxPoolSize=250
    c3p0.maxStatements=200
    c3p0.numHelperThreads=20
    c3p0.maxIdleTime=600
    c3p0.idleConnectionTestPeriod=900
    c3p0.preferredTestQuery=select 1 from dual
    c3p0.testConnectionOnCheckin=true
    c3p0.testConnectionOnCheckout=false#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
    hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
    #hibernate.dialect=org.hibernate.dialect.SQLServerDialecthibernate.jdbc.batch_size=25
    hibernate.jdbc.fetch_size=50
    hibernate.show_sql=false
    hibernate.connection.release_mode=after_transaction
    hibernate.autoReconnect=truezengzhi.isloadconfig=false
    zengzhi.safePath=e:/safe/cache.config=oscache.properties
    cacheus.config=oscache_us.properties
    cacheup.config=oscache_up.properties
    cachefl.config=oscache_fl.properties
    cachelist.config=oscache_list.properties
    cachepost.config=oscache_post.properties
    ==========================================================================
    spring配置
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
    <beans>
    <bean id="placeholderConfig"
    class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location">
    <value>classpath:init.properties</value>
    </property>
    </bean> 
    <bean id="dataSourceTarget" class="com.mchange.v2.c3p0.ComboPooledDataSource"
    destroy-method="close" dependency-check="none">
    <property name="driverClass">
    <value>${datasource.driverClassName}</value>
    </property>
    <property name="jdbcUrl">
    <value>${datasource.url}</value>
    </property>
    <property name="user">
    <value>${datasource.username}</value>
    </property>
    <property name="password">
    <value>${datasource.password}</value>
    </property>
    <property name="acquireIncrement">
    <value>${c3p0.acquireIncrement}</value>
    </property>
    <property name="initialPoolSize">
    <value>${c3p0.initialPoolSize}</value>
    </property>
    <property name="minPoolSize">
    <value>${c3p0.minPoolSize}</value>
    </property>
    <property name="maxPoolSize">
    <value>${c3p0.maxPoolSize}</value>
    </property>
    <property name="maxIdleTime">
    <value>${c3p0.maxIdleTime}</value>
    </property>
    <property name="idleConnectionTestPeriod">
    <value>${c3p0.idleConnectionTestPeriod}</value>
    </property>
    <property name="maxStatements">
    <value>${c3p0.maxStatements}</value>
    </property>
    <property name="numHelperThreads">
    <value>${c3p0.numHelperThreads}</value>
    </property>
    <property name="preferredTestQuery">
    <value>${c3p0.preferredTestQuery}</value>
    </property>
    <property name="testConnectionOnCheckin">
    <value>${c3p0.testConnectionOnCheckin}</value>
    </property>
    <property name="testConnectionOnCheckout">
    <value>${c3p0.testConnectionOnCheckout}</value>
    </property>
    <property name="acquireRetryAttempts">
    <value>${c3p0.acquireRetryAttempts}</value>
    </property> 
    <property name="acquireRetryDelay">
    <value>${c3p0.acquireRetryDelay}</value>
    </property>
    <property name="breakAfterAcquireFailure">
    <value>${c3p0.breakAfterAcquireFailure}</value>
    </property>
    <property name="autoCommitOnClose">
    <value>${c3p0.autoCommitOnClose}</value>
    </property>
    </bean>
    </beans>