proxool配置文件如下:----------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. --><proxool>
<alias>spring</alias>
<driver-url>jdbc:mysql://localhost:3306/xxx</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="connection.autoReconnect" value="true"/>
<property name="connection.useUnicode" value="true"/>
<property name="connection.characterEncoding" value="utf-8"/>
<property name="connection.useNewIO" value="false"/>
<property name="connection.zeroDateTimeBehavior" value="convertToNull"/>
<property name="connection.useServerPrepStmts" value="false"/>
<property name="user" value="xx" />
<property name="password" value="xx" />
</driver-properties>
<minimum-connection-count>2</minimum-connection-count>
<maximum-connection-count>20</maximum-connection-count>
<maximum-connection-lifetime>18000000</maximum-connection-lifetime> <!-- 5 hours -->
<house-keeping-test-sql>values(current TimeStamp)</house-keeping-test-sql>
<statistics>1m,15m,1d</statistics>
<statistics-log-level>INFO</statistics-log-level>
<fatal-sql-exception>Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01</fatal-sql-exception>
<fatal-sql-exception-wrapper-class>org.logicalcobwebs.proxool.FatalRuntimeException</fatal-sql-exception-wrapper-class>
<verbose>false</verbose>
</proxool>

解决方案 »

  1.   

    下边是spring的配置片段:
    ----------------------------------------------------------------------------
    <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="mappingDirectoryLocations">
    <list>
    <value>classpath:/com/xx/model/businessobject</value>
    </list>
    </property>
    <property name="hibernateProperties">
    <props>
    <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
    <prop key="hibernate.show_sql">false</prop>
    <prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
    <prop key="hibernate.cache.use_query_cache">true</prop>
    <prop key="hibernate.cache.provider_class">org.hibernate.cache.OSCacheProvider</prop>
    <prop key="hibernate.proxool.pool_alias">spring</prop>
    <prop key="hibernate.proxool.xml">proxool.xml</prop>
    </props>
    </property>
    </bean>