快崩溃了,配置Proxool成功的高人来指点一下。

Proxool.properties文件内容
jdbc-0.proxool.alias=proxool
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NSWZCGXT
jdbc-0.user=sa
jdbc-0.password=

jdbc-0.proxool.maximum-connection-count=10
jdbc-0.proxool.prototype-count=2

jdbc-0.proxool.house-keeping-test-sql=select * from sysusers
jdbc-0.proxool.verbose=true

WEB.xml配置

ServletConfigurator
org.logicalcobwebs.proxool.configuration.ServletConfigurator

propertyFile
WEB-INF/classes/Proxool.properties

1


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


Admin
/Admin

jsp文件

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>




<br> My JSP 'Proxool.jsp' starting page<br>









<%
out.println("连接中...");
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
con = DriverManager.getConnection("proxool.proxool");
stmt = con.createStatement();
String query = "select * from supply";
rs = stmt.executeQuery(query);
while (rs.next()) {
out.print(rs.getString("supname") + "--OK");
}

stmt.close();
con.close();
} catch (SQLException sqle) {
out.println("sqle.printStackTrace():");
sqle.printStackTrace();
//out.println("e.toString(): " + sqle.toString());
//out.println("sqle=" + sqle);
out.println("不能连接");
} finally {
try {
if (con != null) {
con.close();
}
} catch (SQLException sqle) {
//out.println("sqle=" + sqle);
out.println("不能连接");
}
}

%>

------------------------------
报错:Attempt to refer to a unregistered pool by its alias 'proxool'。等

各位大哥大姐,帮帮忙啊。

我晕,这种低级让人抓狂的连接池还去用它,连接池组件已经是Web容器的基础组件,直接使用即可,不同的连接池性能差别不大,你再花费力气研究操作系统级别的技术没有必要。