HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT A.TITLE AS MAIN_TITLE,A.TOPIC_ID,B.SUB_TOPIC_ID,B.TITLE FROM CODE_TOPIC A LEFT JOIN CODE_SUB_TOPIC B ON A.TOPIC_ID=B.TOPIC_ID WHERE A.TOPIC_ID = ? AND A.LAN_ID =? ORDER BY SUB_TOPIC_ID]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'haishunftp.code_topic' doesn't exist


type Exception report

message Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT A.TITLE AS MAIN_TITLE,A.TOPIC_ID,B.SUB_TOPIC_ID,B.TITLE FROM CODE_TOPIC A LEFT JOIN CODE_SUB_TOPIC B ON A.TOPIC_ID=B.TOPIC_ID WHERE A.TOPIC_ID = ? AND A.LAN_ID =? ORDER BY SUB_TOPIC_ID]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'haishunftp.code_topic' doesn't exist

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT A.TITLE AS MAIN_TITLE,A.TOPIC_ID,B.SUB_TOPIC_ID,B.TITLE FROM CODE_TOPIC A LEFT JOIN CODE_SUB_TOPIC B ON A.TOPIC_ID=B.TOPIC_ID WHERE A.TOPIC_ID = ? AND A.LAN_ID =? ORDER BY SUB_TOPIC_ID]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'haishunftp.code_topic' doesn't exist
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT A.TITLE AS MAIN_TITLE,A.TOPIC_ID,B.SUB_TOPIC_ID,B.TITLE FROM CODE_TOPIC A LEFT JOIN CODE_SUB_TOPIC B ON A.TOPIC_ID=B.TOPIC_ID WHERE A.TOPIC_ID = ? AND A.LAN_ID =? ORDER BY SUB_TOPIC_ID]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'haishunftp.code_topic' doesn't exist
	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:603)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:718)
	com.hs.service.HsService.advantageService(HsService.java:91)
	com.hs.web.HsController.index(HsController.java:121)
	sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'haishunftp.code_topic' doesn't exist
	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:3283)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
	org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:718)
	com.hs.service.HsService.advantageService(HsService.java:91)
	com.hs.web.HsController.index(HsController.java:121)
	sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.43 logs.


Apache Tomcat/6.0.43