The server encountered an internal error () that prevented it from fulfilling this request 是那里错了？
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 4.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.leaveword.jsp_005fjavabean.viewMessages_jsp._jspService(viewMessages_jsp.java:120)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.jspdev.ch8.EncodingFilter.doFilter(EncodingFilter.java:36)
root cause
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 4.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
com.jspdev.ch9.MessageBean.getMessage(MessageBean.java:84)
org.apache.jsp.leaveword.jsp_005fjavabean.viewMessages_jsp._jspService(viewMessages_jsp.java:67)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.jspdev.ch8.EncodingFilter.doFilter(EncodingFilter.java:36)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
问题点数：20、回复次数：7Top
1 楼jialin_2004（老猫）回复于 2005-08-02 14:31:45 得分 0
代码能贴出来么?Top
2 楼hongping（晨曦）回复于 2005-08-03 11:20:14 得分 0
<!-- index.html -->
<HTML>
<HEAD>
<TITLE> message board </TITLE>
</HEAD>
<LINK href="..\..\hellking.css" type=text/css rel=stylesheet>
<BODY>
<TABLE width="90%" align="center" border=1 cellspacing="0" cellpadding="0" bordercolordark="#CCCC99" bordercolorlight="#CCCC99">
<TR>
<TD align="center" bgcolor="#CCCC99">访客留言板</TD>
</TR>
<TR>
<TD><TABLE align="center" border=1 cellspacing="0" cellpadding="0" bordercolordark="#CCCC99" bordercolorlight="#CCCC99">
<FORM ACTION="/jspdev/addMessages_servlet" method="post">
<TR>
<TD>姓名：</TD>
<TD bgcolor="#CCCC99"><input type="text" name="name" size=25></TD>
</TR>
<TR>
<TD bgcolor="#CCCC99">E-mail：</TD>
<TD bgcolor="#CCCC99"><input type="text" name="email" size=25></TD>
</TR>
<TR>
<TD>主题：</TD>
<TD bgcolor="#CCCC99"><input type="text" name="title" size=25></TD>
</TR>
<TR>
<TD valign="top" bgcolor="#CCCC99">留言：</TD>
<TD><textarea name="content" rows=7 cols=25></textarea></TD>
</TR>
<TR>
<TD colspan=3><TABLE align="center" width="100%" cellspacing="0" cellpadding="0" bordercolordark="#CCCC99" bordercolorlight="#CCCC99">
<TR>
<TD align="center" bgcolor="#CCCC99"><input type="submit" value="提交留言"></TD>
<TD align="center"><a href="/jspdev/viewMessages_servlet"><font size=2>查看留言</font></a></TD>
<TD align="center" bgcolor="#CCCC99"><input type="reset" value="重新填写"></TD>
</TR>
</TABLE></TD>
</TR>
</FORM>
</TABLE></TD>
</TR>
</TABLE>
</BODY>
</HTML>Top
3 楼hongping（晨曦）回复于 2005-08-03 11:22:01 得分 0
//viewMessages_servlet对应的代码：
package com.jspdev.ch9;
import javax.servlet.*;
import javax.servlet.http.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
import java.util.*;
import java.io.*;
public class ViewMessageServlet extends HttpServlet
{
private Connection con;
/**
*接收GET请求，执行数据库操作，保存结果到request中，
*把视图派发到下一个页面
*/
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
Collection ret=new ArrayList();
try
{
Statement stm=con.createStatement();
ResultSet result=stm.executeQuery("select count(*) from message");
int message_count=0;
if(result.next())
{
message_count=result.getInt(1);
result.close();
}
if(message_count>0)
{
result=stm.executeQuery("select * from message order by time desc");
while(result.next())
{
String title=result.getString("title");
String name=result.getString("name");
String mail=result.getString("mail");
String content=result.getString("content");
java.sql.Date date=result.getDate("time");
MessageVO message=new MessageVO();
message.setName(name);
message.setTitle(title);
message.setContent(content);
message.setDate(date);
message.setEmail(mail);
ret.add(message);
}
result.close();
stm.close();
}
//保存执行结果，把视图派发到目标
request.setAttribute("messages",ret);
RequestDispatcher requestDispatcher = request.getRequestDispatcher("/leaveword/jsp_servlet_javabean/viewMessages.jsp");
requestDispatcher.forward(request,response);
}
catch(Exception e)
{
e.printStackTrace();
}
}
/*
*初始化到数据库的连接
*/
public ViewMessageServlet()
{
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
String USER="bn";
String PWD="bn";
try
{
Class.forName(CLASSFORNAME);
con = DriverManager.getConnection(SERVANDDB,USER,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
}
/**
*和GET请求的处理一样
*/
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
doGet(request,response);
}
}
Top
4 楼hongping（晨曦）回复于 2005-08-03 11:25:28 得分 0
to jialin_2004(老猫)
我数据库中有记录，我为什么看不到留言?
用下列代码同样看不到？
//把视图派发到目标
equestDispatcher requestDispatcher = request.getRequestDispatche("/viewMessages_servlet");
requestDispatcher.forward(request,response);Top
5 楼jialin_2004（老猫）回复于 2005-08-03 11:46:45 得分 20
生成一个结果集后,最好不要再重新给他赋值,好像会有些问题,你最好重新再定义个结果集关于查询结果Top
6 楼hongping（晨曦）回复于 2005-08-03 13:55:50 得分 0
我修改对应的类在CMD下编译出错：我该怎么办？
http://community.csdn.net/Expert/topic/4185/4185616.xml?temp=.1092035Top
7 楼hongping（晨曦）回复于 2005-08-31 09:42:48 得分 0
要强制结帖了。Top
相关问题
- 求助！The server encountered an internal error () that prevented it from fulfilling this request.
- 这是一个什么错误？ description The server encountered an internal error () that prevented it from fulfilling this request.
- HTTP Status 500 - The server encountered an internal error () that prevented it from fulfilling this request.开始学jsp安装服务器
- [SQL Server]Divide by Zero error encountered????
- The server encountered an internal error () that prevented it from
- 急救:Server was unable to process request.???
- A gateway timeout occurred. The server is unreachable. Retry the request. 是什么意思呢？
- 很奇怪的一个问题--Server was unable to process request
- FCKeditor : xml request error:internal server error(500) 错误如何来解决
- 这是意思？<form method="POST" action="<?php echo $_SERVER['PHP_SELF'].'?inc_name=edit_customer&cid='.$_REQUEST['cid']; ?>">
