HTTP Status 500 - An exception occurred processing JSP page /modules/clientHomeCn/newsContent.jsp at line 17


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.


Apache Tomcat/6.0.44