HTTP Status 500 – Internal Server Error


Type Exception Report

Message javax.servlet.ServletException: java.sql.SQLException: I/O Error: Connection reset Query: select pm.id,pm.score1,pm.is_help,pm.score2,pm.score3,pm.score4,pm.content,pm.name contact_address,pm.username,pm.product_id,pp.factoryid,pp.factoryname,pp.catalognum,pp.catalogname,pp.name product_name,pp.img2,pp.file_name,pm.add_date,pp.view_count from pro_comments pm left join pro_products pp on pm.product_id=pp.id where pm.is_show=1 and pm.id=173350 order by pm.add_date desc Parameters: []

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

Exception

org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: I/O Error: Connection reset Query: select pm.id,pm.score1,pm.is_help,pm.score2,pm.score3,pm.score4,pm.content,pm.name contact_address,pm.username,pm.product_id,pp.factoryid,pp.factoryname,pp.catalognum,pp.catalogname,pp.name product_name,pp.img2,pp.file_name,pm.add_date,pp.view_count from pro_comments pm left join pro_products pp on pm.product_id=pp.id where pm.is_show=1 and  pm.id=173350 order by pm.add_date desc Parameters: []
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:599)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:500)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
	com.jerehnet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:36)

Root Cause

javax.servlet.ServletException: java.sql.SQLException: I/O Error: Connection reset Query: select pm.id,pm.score1,pm.is_help,pm.score2,pm.score3,pm.score4,pm.content,pm.name contact_address,pm.username,pm.product_id,pp.factoryid,pp.factoryname,pp.catalognum,pp.catalogname,pp.name product_name,pp.img2,pp.file_name,pm.add_date,pp.view_count from pro_comments pm left join pro_products pp on pm.product_id=pp.id where pm.is_show=1 and  pm.id=173350 order by pm.add_date desc Parameters: []
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:917)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:846)
	org.apache.jsp.koubei.detail_jsp._jspService(detail_jsp.java:934)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
	com.jerehnet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:36)

Root Cause

java.sql.SQLException: I/O Error: Connection reset Query: select pm.id,pm.score1,pm.is_help,pm.score2,pm.score3,pm.score4,pm.content,pm.name contact_address,pm.username,pm.product_id,pp.factoryid,pp.factoryname,pp.catalognum,pp.catalogname,pp.name product_name,pp.img2,pp.file_name,pm.add_date,pp.view_count from pro_comments pm left join pro_products pp on pm.product_id=pp.id where pm.is_show=1 and  pm.id=173350 order by pm.add_date 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.getMap(DBHelper.java:216)
	org.apache.jsp.koubei.detail_jsp._jspService(detail_jsp.java:156)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
	com.jerehnet.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:36)

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


Apache Tomcat/7.0.104