HTTP Status 500 – Internal Server Error


Type Exception Report

Message An exception occurred processing [careers.jsp] at line [7]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [careers.jsp] at line [7]

4: 	String uuid = CommonString.getFormatPara(request.getParameter("uuid"));
5: 	System.out.println(uuid);
6: 	DBHelper db = DBHelper.getInstance();
7: 	Map c = db.getMap("select * from fanyang_cn_common_channel where uuid=?",new Object[]{uuid});
8: 	/* 获取栏目名称 */
9: 	String name=CommonString.getFormatPara(c.get("name"));
10: 	PageBean pb = new PageBean();


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:593)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:467)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	com.hrada.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:47)

Root Cause

javax.servlet.ServletException: java.sql.SQLException: 将字符串转换为 uniqueidentifier 时失败。 Query: select * from fanyang_cn_common_channel where uuid=? Parameters: []
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:667)
	org.apache.jsp.careers_jsp._jspService(careers_jsp.java:230)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	com.hrada.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:47)

Root Cause

java.sql.SQLException: 将字符串转换为 uniqueidentifier 时失败。 Query: select * from fanyang_cn_common_channel where uuid=? Parameters: []
	org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
	org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399)
	org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:488)
	org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:466)
	com.hrada.util.dbutil.DBHelper.getMap(DBHelper.java:228)
	org.apache.jsp.careers_jsp._jspService(careers_jsp.java:131)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728)
	com.hrada.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:47)

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/9.0.10