51,409
社区成员
发帖
与我相关
我的任务
分享为什么调试proxool-test.jsp时，出现No suitable driver found for proxool.net
proxool-test.jsp
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" %>
<html>
<head>
<title>Proxool-test.jsp</title>
</head>
<body>
<h2>使用 Proxool Connection Pool</h2>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
con = DriverManager.getConnection("Proxool.net");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM tb_usertable";
rs = stmt.executeQuery(query);
while(rs.next()) {
String name = rs.getString(2);
String password = rs.getString(3);
%>
姓名为：<%= name %><br>
密码为：<%=password %>
<%
}
stmt.close();
con.close();
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try {
if(con != null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}
%>
</body>
</html>
-----------------------------------------------------------------------------------
Proxool.properties
jdbc-0.proxool.alias=net
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://192.168.1.102:1433;DatabaseName=db_net
jdbc-0.user=sa
jdbc-0.password=acer
jdbc-0.proxool.maximum-connection-count=10
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
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" %>
<html>
<head>
<title>Proxool-test.jsp</title>
</head>
<body>
<h2>使用 Proxool Connection Pool</h2>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
con = DriverManager.getConnection("Proxool.net");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM tb_usertable";
rs = stmt.executeQuery(query);
while(rs.next()) {
String name = rs.getString(2);
String password = rs.getString(3);
%>
姓名为：<%= name %><br>
密码为：<%=password %>
<%
}
stmt.close();
con.close();
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try {
if(con != null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}
%>
</body>
</html>
-----------------------------------------------------------------------------------
Proxool.properties
jdbc-0.proxool.alias=net
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://192.168.1.102:1433;DatabaseName=db_net
jdbc-0.user=sa
jdbc-0.password=acer
jdbc-0.proxool.maximum-connection-count=10
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
...全文
请发表友善的回复…
发表回复
fengnenglu 2011-08-11
- 打赏
- 举报
我觉得是某个包没有导入
luohuijun619 2011-08-11
- 打赏
- 举报
con = DriverManager.getConnection("Proxool.net");
lz用的名称不对吧
lz用的名称不对吧
