HTTP狀態(tài) 500 - 內(nèi)部服務(wù)器錯(cuò)誤

類型 異常報(bào)告

消息 An exception occurred processing [specolumn/include/index_hot_bidding.jsp] at line [47]

描述 服務(wù)器遇到一個(gè)意外的情況，阻止它完成請(qǐng)求。

例外情況

org.apache.jasper.JasperException: An exception occurred processing [specolumn/include/index_hot_bidding.jsp] at line [47]

44: 							</div>
45: 							<div class="part_con">
46: 							<%
47: 							List<Map> list =dbHelper.getMapList(" SELECT top 6 id,title FROM web21sun.dbo.bidding_bulletin where is_show=1 "+whereStr+" and   DateDiff(mm,pub_date,getdate()) <2 order by view_count desc ");
48: 							if(list!=null && list.size()>0){
49: 								int num=0;
50: 								for(Map m:list){


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:610)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:489)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.jerehnet.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)

根本原因。

javax.servlet.ServletException: java.sql.SQLException: I/O Error: Connection reset Query:  SELECT top 6 id,title FROM web21sun.dbo.bidding_bulletin where is_show=1  and catalognum like '%102%'  and   DateDiff(mm,pub_date,getdate()) <2 order by view_count desc  Parameters: []
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:657)
	org.apache.jsp.specolumn.include.index_005fhot_005fbidding_jsp._jspService(index_005fhot_005fbidding_jsp.java:258)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.jerehnet.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)

根本原因。

java.sql.SQLException: I/O Error: Connection reset Query:  SELECT top 6 id,title FROM web21sun.dbo.bidding_bulletin where is_show=1  and catalognum like '%102%'  and   DateDiff(mm,pub_date,getdate()) <2 order by view_count desc  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:507)
	com.jerehnet.util.dbutil.DBHelper.getMapList(DBHelper.java:117)
	org.apache.jsp.specolumn.include.index_005fhot_005fbidding_jsp._jspService(index_005fhot_005fbidding_jsp.java:209)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.jerehnet.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)

):注意 主要問(wèn)題的全部 stack 信息可以在 server logs 里查看

Apache Tomcat/9.0.62