Spring2.5配置proxool连接池

首先按正常步骤配置好proxool连接池，在web.xml中配置自动监控，做简单测试保证该连接池能够正常工作。proxool.xml配置如下：

1.proxool.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application''s.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
  <proxool>
    <alias>MyPool</alias>
    <driver-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test;SelectMethod=cursor</driver-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
    <driver-properties>
      <property name="user" value="testuser"/>
      <property name="password" value="testpwd"/>
    </driver-properties>
    <maximum-connection-count>80</maximum-connection-count>
    <minimum-connection-count>20</minimum-connection-count>
    <house-keeping-sleep-time>180000</house-keeping-sleep-time>
    <prototype-count>5</prototype-count>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
  </proxool>
</something-else-entirely>
 

2.applicationContext.xml配置proxool连接池,有两种方式，一种是利用上面配置好的proxool.xml文件，另一种方式是直接在applicationContext.xml中配置，首先看方式一：

   <bean   id="TestSource"   class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
          <property   name="driverClassName">  
              <value>org.logicalcobwebs.proxool.ProxoolDriver</value>  
          </property>  
          <proper