type Exception report
message An exception occurred processing JSP page /modules/clientHomeCn/newsContent.jsp at line 17
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /modules/clientHomeCn/newsContent.jsp at line 17 14: List<WebNews> list = new ArrayList<WebNews>(); 15: WebNews wn=new WebNews(); 16: if(!id.contains("*") && !id.contains("SELECT")){ 17: list=wnd.getNewsById(id); 18: } 19: if(list!=null&&list.size()>0){ 20: wn=list.get(0); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) com.embraiz.filter.RoleFilter.doFilter(RoleFilter.java:90)
root cause
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from v_web_news where 1=1 and id in (112?lctHref=15) order by create_time]; nested exception is com.mysql.jdbc.exceptions.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 '?lctHref=15) order by create_time' at line 1 org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463) com.embraiz.dao.core.WebNewsDao.getNewsById(WebNewsDao.java:56) org.apache.jsp.modules.clientHomeCn.newsContent_jsp._jspService(newsContent_jsp.java:116) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) com.embraiz.filter.RoleFilter.doFilter(RoleFilter.java:90)
root cause
com.mysql.jdbc.exceptions.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 '?lctHref=15) order by create_time' at line 1 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) com.mysql.jdbc.Connection.execSQL(Connection.java:3277) com.mysql.jdbc.Connection.execSQL(Connection.java:3206) com.mysql.jdbc.Statement.executeQuery(Statement.java:1232) org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463) com.embraiz.dao.core.WebNewsDao.getNewsById(WebNewsDao.java:56) org.apache.jsp.modules.clientHomeCn.newsContent_jsp._jspService(newsContent_jsp.java:116) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:723) com.embraiz.filter.RoleFilter.doFilter(RoleFilter.java:90)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.44 logs.