HTTP状态 500 - 内部服务器错误


类型 异常报告

消息 在 [20] 行处理 [detail/jiudian_yd.jsp] 时发生异常

描述 服务器遇到一个意外的情况,阻止它完成请求。

例外情况

org.apache.jasper.JasperException: 在 [20] 行处理 [detail/jiudian_yd.jsp] 时发生异常

17: 	 " from usr_view a,info_ticket b where b.parent_cust_id="+cust_id+" and b.state=0 and b.tree_id=5 and b.sale_scope in(2,3)"+
18: 	 " and a.view_id='"+view_id+"' and a.view_id=b.view_ids order by b.goods_count,b.is_top desc) where mm=1";
19: 
20: DataSet ds=dao.queryForDataSet(site.getDb_link(),sql,0,0,false);
21: if (ds.size()==0){
22: 	return;
23: }


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:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	uw.websafe.filter.WebSafeFilter.doFilter(WebSafeFilter.java:61)
	com.llk.utils.web.SetEncodeFilter.doFilter(SetEncodeFilter.java:34)

根本原因。

javax.servlet.ServletException: uw.dm.TransactionException: : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(partition by a.view_id) as sale_price,min(b.market_price) over (partition by a.' at line 1
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:655)
	org.apache.jsp.detail.jiudian_005fyd_jsp._jspService(jiudian_005fyd_jsp.java:883)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	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:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	uw.websafe.filter.WebSafeFilter.doFilter(WebSafeFilter.java:61)
	com.llk.utils.web.SetEncodeFilter.doFilter(SetEncodeFilter.java:34)

根本原因。

uw.dm.TransactionException: : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(partition by a.view_id) as sale_price,min(b.market_price) over (partition by a.' at line 1
	uw.dm.impl.SQLCommandImpl.selectCommandForDataSet(SQLCommandImpl.java:251)
	uw.dm.impl.DAOFactoryImpl.queryForDataSet(DAOFactoryImpl.java:565)
	uw.dm.impl.DAOFactoryImpl.queryForDataSet(DAOFactoryImpl.java:531)
	org.apache.jsp.detail.jiudian_005fyd_jsp._jspService(jiudian_005fyd_jsp.java:158)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	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:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	uw.websafe.filter.WebSafeFilter.doFilter(WebSafeFilter.java:61)
	com.llk.utils.web.SetEncodeFilter.doFilter(SetEncodeFilter.java:34)

根本原因。

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(partition by a.view_id) as sale_price,min(b.market_price) over (partition by a.' at line 1
	sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	com.mysql.jdbc.Util.getInstance(Util.java:381)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	uw.dm.impl.SQLCommandImpl.selectCommandForDataSet(SQLCommandImpl.java:245)
	uw.dm.impl.DAOFactoryImpl.queryForDataSet(DAOFactoryImpl.java:565)
	uw.dm.impl.DAOFactoryImpl.queryForDataSet(DAOFactoryImpl.java:531)
	org.apache.jsp.detail.jiudian_005fyd_jsp._jspService(jiudian_005fyd_jsp.java:158)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	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:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	uw.websafe.filter.WebSafeFilter.doFilter(WebSafeFilter.java:61)
	com.llk.utils.web.SetEncodeFilter.doFilter(SetEncodeFilter.java:34)

):注意 主要问题的全部 stack 信息可以在 server logs 里查看


Apache Tomcat/9.0.84