proxool一个数据库连接池框架，提供了对你选择的其它类型的驱动程序的连接池封装。可以非常简单的移植到现存的代码中。完全可配置。快速，成熟，健壮。可以透明地为你现存的JDBC驱动程序增加连接池功能。到目前为止最新版本是proxool 0.9.1,可从官网下载最新版本http://proxool.sourceforge.net
一、配置proxool.xml文件
Xml代码
< xml version="1.0" encoding="UTF-8" >
dbname
jdbc:oracle:thin:@127.0.0.1:1521:testdb
oracle.jdbc.driver.OracleDriver
100
10
90000
10
5
true
select sysdate from dual
< xml version="1.0" encoding="UTF-8" >
dbname
jdbc:oracle:thin:@127.0.0.1:1521:testdb
oracle.jdbc.driver.OracleDriver
100
10
90000
10
5
true
select sysdate from dual
二、配置web.xml
Xml代码
< xml version="1.0" encoding="UTF-8" >
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">
ServletConfigurator
org.logicalcobwebs.proxool.configuration.ServletConfigurator
xmlFile
WEB-INF/proxool.xml
1
Admin
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
Admin
/admin
proxool
/admin
manager
BASIC
proxool manager Application
The role that is required to log in to the Manager Application
manager
401
/401.jsp
< xml version="1.0" encoding="UTF-8" >
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">
ServletConfigurator
org.logicalcobwebs.proxool.configuration.ServletConfigurator
xmlFile
WEB-INF/proxool.xml
1
Admin
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
Admin
/admin
proxool
/admin
manager
BASIC
proxool manager Application
The role that is required to log in to the Manager Application
manager
401
/401.jsp
ServletConfigurator:加载并初始化proxool.xml文件,因为它是连接数据库的.其他很多模块都用到数据,所以必须首先加载它
load-on-startup:数值越小，就会先被加载初始化
Admin:监控数据库连接池的连接情况
//获得数据库连接的语句
Connection conn=DriverManager.getConnection("proxool.dbname");
注意:在401.jsp页面中必须加
<%
response.setHeader("WWW-Authenticate", "Basic realm=\"Tomcat Manager Application\"");
%>这句话，否则在访问/admin察看连接池信息时，会直接跳转到401.jsp页面。我们是想让访问admin/的用户必须输入用户名和密码，且必须是manager角色，三次输入不正确才会跳到401.jsp页面，如图
输入正确用户名和密码后才能看到proxool池的信息