proxool连接池配置详细说明

proxool连接池配置详细说明 
      目前市面上三个主流连接池从性能上排名如下：proxool>c3p0>dbcp，proxool还提供了可视化的
连接池实时监控工具，所以既稳定又方便，配置也是非常容易的事情。下面我来讲讲我如何配置
proxool连接池的。
1、下载相关资源。
    从http://proxool.sourceforge.net/站点上下载我们需要的资源，proxool-0.9.1是最新版本，解压后从lib下copy里面的2个JAR包 proxool-0.9.1.jar和 proxool-cglib.jar添加到应用的WEB-INF文件夹下。
2、首先在WEB-INF文件夹下建立一个proxool.xml文件。

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool-config>
<proxool>
<alias>DBpool</alias>
<driver-url>
jdbc:oracle:thin:@localhost:1521:mydb
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="guoyong" />
<property name="password" value="guozi123" />
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>150</maximum-new-connections>
<prototype-count>3</prototype-count>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>3</minimum-connection-count>
</proxool>
</proxool-config>
</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>datasource_situation</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>datasource_situation</servlet-name>
<url-pattern>/datasource_situation</url-pattern>
</servlet-mapping>
<!-- 配置受保护域，只有Tomcat管理员才能察看连接池的信息 -->
<security-constraint>
<web-resource-collection>
<web-resource-name>proxool</web-resource-name>
<url-pattern>/datasource_situation</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>

4、在调用数据库连接代码：
    Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
    Connection conn = DriverManager.getConnection("proxool.DBpool");
5、利用proxool监控工具查看数据库运行状态。地址：datasource_situation
我测试的地址示例为：
http://localhost:8088/datasource_situation,其实<url-pattern>为监控地址。