jsp连接postgre数据库?妈的用这种数据库连不上急

cuihao 2003-08-21 05:15:42

<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<html>
<title>
用户信息
</title>
<body>
<p align="left">

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

<%
Statement sqlStmt;
ResultSet sqlRst;
String strSQL;
Connection conn=null;
Class.forName("org.postgresql.Driver");
conn=DriverManager.getConnection(
"jdbc:postgresql://211.99.13.53:5432/test","postgre","");
sqlStmt=conn.createStatement();
strSQL="select * from mobile";
sqlRst = sqlStmt.executeQuery(strSQL);

while(sqlRst.next()){
%>
<tr>
<td>id：<%=sqlRst.getInt(1) %> </td>
</tr>
<tr>
<td> name：<%=sqlRst.getString(2) %> </td>
</tr>
<tr>
<td>memo：<%=sqlRst.getString(3) %></td>
</tr>
<% } %>
</p>
</body>
</html>

JB8编译
错误信息:

Apache Tomcat/4.0.6 - HTTP Status 500 - Internal Server Errortype Exception reportmessage Internal Server Errordescription The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.
exception

javax.servlet.ServletException: org.postgresql.Driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.condb$jsp._jspService(condb$jsp.java:113)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

root
cause java.lang.ClassNotFoundException: org.postgresql.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1406)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:198)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:132)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)

...全文

58 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

leb 2003-08-27

打赏
举报

启动服务器时用postmaster -i 以支持tcp/ip

cuihao 2003-08-21

打赏
举报

本地连接搞定,可是传到服务器上,就不零了 ,数据驱动也都复制到了服务器上的web-inf/lib
下了

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

conning333 2003-08-21