proxool配置詳解

proxool一個資料庫連接配接池架構，提供了對你選擇的其它類型的驅動程式的連接配接池封裝。可以非常簡單的移植到現存的代碼中。

<?xml version=”1.0” encoding=”utf-8”?>

<something-else-entriely>

<alias>dbname</alias><!—資料源的别名-->

<driver-url>jdbc:oracle:thin:@127.0.0.1:1521:testdb</driver-url><!—url連接配接串-->

<driver-class>oracle</driver-class><!—驅動類-->

<driver-properties>

</driver-properties>

<!—最大連接配接數（預設5個），超過了這個連接配接數，再有請求是，就排在隊列中等待，最大的等待請求書又maximum-new-connections決定-->

<maximum-connection-count>100</maximum-connection-count>

<!—最小連接配接數(預設2個)-->

<minimum-connection-count>10</minimum-connection-count>

<!—proxool自動偵探各個連接配接狀态的時間間隔(毫秒),偵探到空閑的就馬上收回，逾時的銷毀

預設30秒-->

<house-keeping-sleep-time>90000</house-keeping-sleep-time>

<!—沒有空閑連接配接可以配置設定而在隊列中等候的最大請求書，超過這個請求數的使用者連接配接就不會被接受-->

<maximum-new-connections>400</maximum-new-connections>

<!—最少保持的空閑連接配接數(預設2個)-->

<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-entriely>

配置web.xml

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

<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"

xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"

xsi:schemalocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<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-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>

<security-constraint>

<web-resource-collection>

<web-resource-name>proxool</web-resource-name>

<url-pattern>/admin</url-pattern>

</web-resource-collection>

<auth-constraint>

<role-name>manager</role-name>

</auth-constraint>

</security-constraint>

<login-config>

<auth-method>basic</auth-method>

<realm-name>proxool manager application</realm-name>

</login-config>

<security-role>

<description>the role that is required to log in to the manager application</description>

<role-name>manager</role-name>

</security-role>

<error-page>

<error-code>401</error-code>

</error-page>

</web-app>

servletconfigurator:加載并初始化proxool.xml檔案，因為它是連接配接資料庫的。其他很多子產品都用到資料，是以必須首先加載它

load-on-startup:數值越小，就會先被加載初始化

admin:監控資料庫連接配接池連接配接情況

//獲得資料庫的語句

connection conn = drivermanager.getconnection(“proxool.dbname”);

proxool.xml配置屬性說明

xml代碼：

<?xml

version="1.0"

encoding="iso-8859-1"?>

<something-else-entirely

xmlns="http://sumthin.else.entirely"

xmlns:proxool="the latest version is available at http://proxool.sourceforge.net/xml-namespace">

<proxool:proxool>

<proxool:alias>xml-test-ns</proxool:alias>

<proxool:driver-url>jdbc:hsqldb:db/test</proxool:driver-url>

<proxool:driver-class>org.hsqldb.jdbcdriver</proxool:driver-class>

<proxool:driver-properties>

<proxool:property

name="user"

value="sa"/>

name="password"

value=""/>

</proxool:driver-properties>

<proxool:house-keeping-sleep-time>40000</proxool:house-keeping-sleep-time>

<proxool:house-keeping-test-sql>select current_date</proxool:house-keeping-test-sql>

<proxool:maximum-connection-count>10</proxool:maximum-connection-count>

<proxool:minimum-connection-count>3</proxool:minimum-connection-count>

<proxool:maximum-connection-lifetime>18000000</proxool:maximum-connection-lifetime><!--

5 hours -->

<proxool:simultaneous-build-throttle>5</proxool:simultaneous-build-throttle>

<proxool:recently-started-threshold>40000</proxool:recently-started-threshold>

<proxool:overload-without-refusal-lifetime>50000</proxool:overload-without-refusal-lifetime>

<proxool:maximum-active-time>60000</proxool:maximum-active-time>

<proxool:verbose>true</proxool:verbose>

<proxool:trace>true</proxool:trace>

<proxool:fatal-sql-exception>fatal error</proxool:fatal-sql-exception>

<proxool:prototype-count>2</proxool:prototype-count>

</proxool:proxool>

<nothing-to-do-with-proxool>

<proxool:proxool>

<proxool:alias>xml-test-ns-2</proxool:alias>