access proxool配置

1.先将 proxool-0.9.0RC2.jar 复制到自己的WEB应用的WEB-INF/lib之下. 2.在web.xml中加入: servlet servlet-nameServletConfigurator/servlet-name servlet-classorg.logicalcobwebs.proxool.configuration.ServletConfigurator/servlet-class init-param pa

1.先将 proxool-0.9.0RC2.jar 复制到自己的WEB应用的WEB-INF/lib之下.

2.在web.xml中加入:

ServletConfigurator

org.logicalcobwebs.proxool.configuration.ServletConfigurator


propertyFile
WEB-INF/classes/Proxool.properties

1



Admin
org.logicalcobwebs.proxool.admin.servlet.AdminServlet

Admin
/Admin

3.写一个属性文件Proxool.propertie 放到WEB-INF/classes/目录下,内容如下:

jdbc-0.proxool.alias=Access
jdbc-0.proxool.driver-class=sun.jdbc.odbc.JdbcOdbcDriver
jdbc-0.proxool.driver-url=jdbc:odbc:tcmap
jdbc-0.proxool.maximum-connection-count=20
jdbc-0.proxool.prototype-count=4

jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG

4. 来个文件data.jsp测试一下,数据连接pool:

<%@ page import="java.sql.*" %>

<%
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet rs=null;
Conn = DriverManager.getConnection("proxool.Access");
Stmt=Conn.createStatement();
%>

5.访问出现白板.OK.

6.http://127.0.0.1/Admin查看proxool信息,注意Admin大小写.