JSP报错500错误

Question

HTTP Status 500 - type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Column not found org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) root cause javax.servlet.ServletException: java.sql.SQLException: Column not found org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779) org.apache.jsp.log_jsp._jspService(log_jsp.java:151) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) root cause java.sql.SQLException: Column not found sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source) sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source) org.apache.jsp.log_jsp._jspService(log_jsp.java:109) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.Apache Tomcat/6.0.13 这是什么错误？ 我看不明白 

Answer 1

java.sql.SQLException: Column not found ------>说数据库中有一列没有找到
出现这样的问题无非就是两种可能
1.rs.getString(int n);<----参数n比你数据库中的列数的值要大
2.rs.getString("name") <------参数name数据库中没有name名字的列
找到错误的方法：
关键错误提示代码：sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source) org.apache.jsp.log_jsp._jspService(log_jsp.java:109) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
------->解决的方法
1.如果你用MyEclipse:
你到Tomcat下面找到你发布的工程名那个文件夹：搜索log_jsp.java这个文件
打开该文件找到log_jsp.java的第109行代码 可以看到你jsp页面出错的代码
2.如果你是用eclipse：
你到自己的工程目录下面找到工程那个文件夹：搜索log_jsp.java这个文件
打开该文件找到log_jsp.java的第109行代码 可以看到你jsp页面出错的代码

Answer 2

ServletException错误，SQL没连上。500都是代码的错误

Answer 3

检查下 你的数据库连接是否正确。。

Answer 4

java.sql.SQLException: Column not found 数据库