当前页面: 开发资料首页 → JSP 专题 → 各位大哥,小弟用Proxool连接池,连接不上数据库,帮帮忙
各位大哥,小弟用Proxool连接池,连接不上数据库,帮帮忙
摘要: 各位大哥,小弟用Proxool连接池,连接不上数据库,帮帮忙
我用的tomcat + JSP + mysql;
数据库驱动在tomcat的common/lib之下
Proxool-0.8.3 放在了 站台的WEB-INF/lib之下
程序:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<body>
<%Class.forName("org.logicalcobwebs.proxool.proxoolDriver");
Connection conn= DriverManager.getConnection("proxool.teach:org.gjt.mm.mysql.Driver:jdbc:mysql://localhost:3306/teach?user=root&password=121826&useUnicode=true&characterEncoding=8859_1");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from gonggao";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
错误提示:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: org.logicalcobwebs.proxool.proxoolDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.connc_jsp._jspService(connc_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.lang.ClassNotFoundException: org.logicalcobwebs.proxool.proxoolDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1366)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1213)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:184)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:110)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.connc_jsp._jspService(connc_jsp.java:42)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
友情接分。。。
我刚毕业不久,关注新问题。。。
java.lang.ClassNotFoundException: org.logicalcobwebs.proxool.proxoolDriver
----------
没有引用这个类啊,把含这个类的jar文件放到lib目录
我认为 在设置MySql的时候,还需要把驱动的jar文件放到jdk下的lib中。但是你的这个异常提示好像不是数据库连接错误,只是也关注一下驱动的问题吧。
谢谢楼上各位
DB配置文件
<?xml version="1.0" encoding="UTF-8"?>
ms//连接池名称
jdbc:oracle:thin:@192.168.210.45:1521:ms
oracle.jdbc.driver.OracleDriver
50
select CURRENT_DATE
加载配置文件
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;
public class DatasourceInitConfig
{
public void loadConfig(String fileName) throws Exception {
JAXPConfigurator.configure(fileName, false);
}
}
调用方法
public boolean isExist(String userId) {
if (userId == null)
return false;
boolean result = false;
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("proxool.ms");
pstmt = conn.prepareStatement(IS_EXIST);
pstmt.setString(1, userId);
rs = pstmt.executeQuery();
if (rs.next())
result = true;
} catch (SQLException sqle) {
logger.error(sqle);
} catch (Exception e) {
logger.error(e);
}
try {
pstmt.close();
conn.close();
} catch (SQLException sqle) {
logger.error(sqle);
}
return result;
}
将数据库驱动的jar和Proxool-0.8.3的jar放在同一个地方看看