spring配置proxool连接db2

第一步下载相关架包：

  用到了三个jar包，proxool-cglib.jar;proxool-0.9.1.jar ;proxool-listenerCfg.jar。

 也可以直接到我的csdn连接直接下载：http://download.csdn.net/detail/dawnsun2013/7141443

第二步创建proxool.xml代码如下：（proxool.xml放在web-inf下）
<?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>dbpool</alias>  
            <driver-url>jdbc:db2://192.168.1.170:50001/v6estore</driver-url>
            <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
            <driver-properties> 
                <property name="user" value="estore" />  
                <property name="password" value="estore" />
            </driver-properties>  
            <maximum-connection-count>100</maximum-connection-count>  
            <minimum-connection-count>10</minimum-connection-count>  
            <house-keeping-sleep-time>90000</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>values current timestamp</house-keeping-test-sql> 
        </proxool> 
    </something-else-entirely>  
第三步 spring applicationContext.xml配置
<bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
       <property name="driverClassName">
        <value>org.logicalcobwebs.proxool.ProxoolDriver</value>
       </property>
       <property name="url">
        <value>proxool.dbpool</value>
       </property>
    </bean>
注意：dbpool一定要和proxool.xml中的alias的值一致。

第四步 配置web.xml
    <context-param>     
        <param-name>proxoolConfigLocation</param-name>     
        <param-value>WEB-INF/proxool.xml</param-value> 
    </context-param> 
    <listener>     
        <listener-class>org.logicalcobwebs.proxool.configuration.ListenerConfigurator</listener-class>
    </listener> 
   
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>
        classpath:applicationContext.xml
        </param-value>
    </context-param>
加入监控
<servlet> 
      <servlet-name>Admin</servlet-name> 
      <servlet-class> 
        org.logicalcobwebs.proxool.admin.servlet.AdminServlet 
      </servlet-class> 
    </servlet> 
    <servlet-mapping> 
      <servlet-name>Admin</servlet-name> 
      <url-pattern>/admin</url-pattern> 
    </servlet-mapping> 
 
      <error-page> 
        <error-code>401</error-code> 
        <location>/401.jsp</location> 
      </error-page> 
注意：401.jsp要加入
<%
  response.setHeader("WWW-Authenticate", "Basic realm=\"Tomcat Manager Application\"");
%>
监控图：