类型 异常报告
消息 在 [150] 行处理 [detail/zixun_list.jsp] 时发生异常
描述 服务器遇到一个意外的情况,阻止它完成请求。
例外情况
org.apache.jasper.JasperException: 在 [150] 行处理 [detail/zixun_list.jsp] 时发生异常 147: 148: ds.absolute(0); 149: String img=""; 150: ds=dao.queryForDataSet(site.getDb_link(),"select tree_id,sign_img,info_id,info_title,sale_price,market_price,interface_id,parent_cust_id,interface_cust_id from info_ticket where parent_cust_id="+cust_id+" and tree_id=3 and state=0 and sale_scope in(2,3) order by is_top desc",0,4,false); 151: while (ds.next()){ 152: if(!ds.getString("sign_img").equals("")){ 153: String imghref=""; 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: : Table 'seq.info_ticket' doesn't exist org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:655) org.apache.jsp.detail.zixun_005flist_jsp._jspService(zixun_005flist_jsp.java:829) 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: : Table 'seq.info_ticket' doesn't exist 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.zixun_005flist_jsp._jspService(zixun_005flist_jsp.java:484) 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: Table 'seq.info_ticket' doesn't exist 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.zixun_005flist_jsp._jspService(zixun_005flist_jsp.java:484) 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 里查看