日期:2014-05-18  浏览次数:20833 次

使用proxool连接池几个小时之后总是会报错!
环境:tomcat6.0+proxool-0.9.01+hibernate3.1+mysql5.0
请大侠解决!!
proxool.xml:
<?xml version="1.0" encoding="UTF-8"?>  

<something-else-entirely>  
    <proxool>  
        <alias>mysqlProxool</alias> 
        <driver-url>jdbc:mysql://127.0.0.1/shaiyaya</driver-url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <driver-properties>  
            <property name="user" value="root" />
            <property name="password" value="banpeizhi" />  
        </driver-properties>    
       
        <maximum-connection-count>100</maximum-connection-count>    
        <minimum-connection-count>10</minimum-connection-count>    
        <maximum-active-time>6000000</maximum-active-time>  
        <house-keeping-sleep-time>120000</house-keeping-sleep-time>  
        <maximum-new-connections>10</maximum-new-connections>    
        <prototype-count>5</prototype-count>    
        <test-before-use>true</test-before-use>  
        <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>  
    </proxool>  
</something-else-entirely> 


hibernate.cfg.xml:

<session-factory>
<property name="hibernate.proxool.pool_alias">mysqlProxool</property>
<property name="hibernate.proxool.xml">proxool.xml</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.existing_pool">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.cache.use_query_cache">true</property>

<!--是否将运行期生成的SQL输出到日志以供调试-->
<property name="show_sql">false</property> 

<!-- 事务管理类型 (显示配置)-->
<property name="hibernate.transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory
</property>

<!-- 映射资源文件 -->
<mapping resource="com/shaiyaya/dao/Report.hbm.xml" />
                ……


报错:

Struts Problem Report

Struts has detected an unhandled exception:

Messages:
Couldn't perform the operation prepareStatement: You can't perform any