spring,hibernate使用xml文件为mysql数据库配连接池proxool

 

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
       <!--<property name="dataSource" ref="dataSource"/>-->
        <property name="mappingResources">
            <list>
              <value>com/sztutors/model/News.hbm.xml</value>
            <value>com/sztutors/model/SiteInfo.hbm.xml</value>
                <value>com/sztutors/model/BookingInfo.hbm.xml</value>
                <value>com/sztutors/model/TitleLevel.hbm.xml</value>
                <value>com/sztutors/model/UserCookie.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>     
 
                <prop key="hibernate.proxool.xml">proxool.xml</prop>
              <prop key="hibernate.proxool.pool_alias">sztutors</prop>                                
            </props>
        </property>
    </bean>

 

proxool.xml文件要放到WEB-INF/classes/下 

<?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. -->
<something-else-entirely>
  <proxool>
    <alias>sztutors</alias>
    <driver-url>jdbc:mysql://localhost/sztutors?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=gb2312</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name="user" value="test"/>
      <property name="password" value="test"/>
    </driver-properties>
    <maximum-connection-count>10</maximum-connection-count>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
  </proxool>
</something-else-entirely>

 

以下还有一些参数可以加到xml文件中

jdbc-0.proxool.alias=sztutors
jdbc-0.proxool.driver-url=jdbc:mysql://localhost/sztutors?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=gbk
jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-0.user=test
jdbc-0.password=test
jdbc-0.proxool.house-keeping-sleep-time=40000
jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.maximum-connection-count=10
jdbc-0.proxool.minimum-connection-count=3
jdbc-0.proxool.maximum-connection-lifetime=18000000
jdbc-0.proxool.simultaneous-build-throttle=5
jdbc-0.proxool.recently-started-threshold=40000
jdbc-0.proxool.overload-without-refusal-lifetime=50000
jdbc-0.proxool.maximum-active-time=60000
jdbc-0.proxool.verbose=true
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-sql-exception=Fatal error
jdbc-0.proxool.prototype-count=2