Proxool pool的配置

配置web.xml 

<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>

lib下新建proxool.xml

<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely>


  <proxool>
  
    <alias>store-ds</alias>
    
    <driver-url>jdbc:oracle:thin:@192.168.1.101:1521:orcl</driver-url>
    
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    
    <driver-properties>
      <property name="user" value="storeMgr"/>
      <property name="password" value="abc"/>
    </driver-properties>
   
    <maximum-connection-count>100</maximum-connection-count> 
    
    <minimum-connection-count>10</minimum-connection-count>    

    <maximum-new-connections>10</maximum-new-connections>    
     
    <house-keeping-sleep-time>90000</house-keeping-sleep-time>  


    <prototype-count>5</prototype-count>    


    <test-before-use>true</test-before-use>  


    <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>  


  </proxool>
  
</something-else-entirely>

获取连接：

Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
java.sql.Connection conn = DriverManager.getConnection("proxool.store-ds");//proxool，让ProxoolDriver知道是给它的