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配置
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 + "/";
%>
My JSP 'Proxool.jsp' starting page
<%
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'。等
各位大哥大姐,帮帮忙啊。