ice world

1.下載proxool，自己到網(wǎng)站http://proxool.sourceforge.net/download.html隨便下載一個(gè)版本，解壓后進(jìn)入目錄lib，會(huì)得到兩個(gè)jar文件，分別為proxool-0.9.1.jar(版本不同可能名稱(chēng)有所不同)和proxool-cglib.jar，將這兩個(gè)jar文件拷貝到項(xiàng)目的WEB-INF/lib下

2.配置web.xml，需要配置proxool的Servlet，如下：

<servlet>
    <servlet-name>proxoolServletConfigurator</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>proxooladmin</servlet-name>
    <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet
    </servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>proxooladmin</servlet-name>
    <url-pattern>/proxooladmin</url-pattern>
</servlet-mapping>

3.創(chuàng)建proxool.xml文件，將此文件放在與web.xml同級(jí)目錄下，即WEB-INF下

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
    <proxool>
        <alias>testDB</alias>
        <driver-url>jdbc:oracle:thin:@192.168.1.229:1521:orcl</driver-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <driver-properties>
            <property name="user" value="test_user" />
            <property name="password" value="password" />
        </driver-properties>
        <maximum-connection-count>10</maximum-connection-count>
        <minimum-connection-count>5</minimum-connection-count>
        <prototype-count>5</prototype-count>
        <test-before-use>true</test-before-use>
        <house-keeping-sleep-time>180000</house-keeping-sleep-time>
        <house-keeping-test-sql>select CURRENT_DATE from dual</house-keeping-test-sql>
    </proxool>
</something-else-entirely>

上面的<test-before-use>true</test-before-use>據(jù)說(shuō)是用來(lái)自動(dòng)重連的，也就是在網(wǎng)絡(luò)錯(cuò)誤或數(shù)據(jù)庫(kù)重啟等等原因?qū)е屡c數(shù)據(jù)庫(kù)斷開(kāi)，每次獲取連接前都會(huì)檢查，如果現(xiàn)在池子中的連接已經(jīng)無(wú)效將會(huì)重新創(chuàng)建

4.在java中獲取數(shù)據(jù)庫(kù)連接的代碼

Connection con = DriverManager.getConnection("proxool.testDB");