proxool连接池配置

1.添加proxool jar包

2.编辑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>OR</alias>
        <driver-url>
            jdbc:oracle:thin:@localhost:1521:orcl
        </driver-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <driver-properties>
            <property name="user" value="orcl" />
            <property name="password" value="111111" />
       </driver-properties>
       
         <minimum-connection-count>10</minimum-connection-count>
         <maximum-connection-count>20</maximum-connection-count>
        <house-keeping-test-sql>select * from dual</house-keeping-test-sql>
    </proxool>
</something-else-entirely>

3.在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>
<!-- 数据连接池，查看连接数量-->
<servlet>
        <servlet-name>proxool</servlet-name>
        <servlet-class>
            org.logicalcobwebs.proxool.admin.servlet.AdminServlet
        </servlet-class>
    </servlet>
<servlet-mapping>
        <servlet-name>proxool</servlet-name>
        <url-pattern>/proxool</url-pattern>
    </servlet-mapping>

4.java里面获取连接

Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
   con = DriverManager.getConnection("proxool.OR");