Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Table ' xinghe.base_class ' doesn ' t exist

Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Table ' xinghe.base_class ' doesn ' t exist

HTTP Status 500-request processing failed; Nested exception is org.springframework.jdbc.BadSqlGrammarException:


Type Exception Report


Message Request processing failed; Nested exception is org.springframework.jdbc.BadSqlGrammarException:


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:
# # # Error updating database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' xinghe.base_class ' doesn ' t exist
# # # The error may involve middleware.delete-inline
# # # The error occurred while setting parameters
# # # Sql:delete from Base_class
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' xinghe.base_class ' doesn ' t exist
; Bad SQL Grammar []; Nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' Xinghe.base_class ' doesn ' t Exist
Org.springframework.web.servlet.FrameworkServlet.processRequest (frameworkservlet.java:965)
Org.springframework.web.servlet.FrameworkServlet.doGet (frameworkservlet.java:844)
Javax.servlet.http.HttpServlet.service (httpservlet.java:620)
Org.springframework.web.servlet.FrameworkServlet.service (frameworkservlet.java:829)
Javax.servlet.http.HttpServlet.service (httpservlet.java:727)
Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52)
Com.auth.filter.AuthorizationFilter.doFilterInternal (authorizationfilter.java:77)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:343)
Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:260)
Com.auth.filter.AuthenticationFilter.doFilterInternal (authenticationfilter.java:113)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:343)
Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:260)
Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:88)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Root cause


Org.springframework.jdbc.BadSqlGrammarException:
# # # Error updating database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' xinghe.base_class ' doesn ' t exist
# # # The error may involve middleware.delete-inline
# # # The error occurred while setting parameters
# # # Sql:delete from Base_class
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' xinghe.base_class ' doesn ' t exist
; Bad SQL Grammar []; Nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' Xinghe.base_class ' doesn ' t Exist
Org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate ( sqlerrorcodesqlexceptiontranslator.java:237)
Org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate ( ABSTRACTFALLBACKSQLEXCEPTIONTRANSLATOR.JAVA:72)
Org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible (mybatisexceptiontranslator.java:73)
Org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke (sqlsessiontemplate.java:371)
Com.sun.proxy. $Proxy 12.delete (Unknown Source)
Org.mybatis.spring.SqlSessionTemplate.delete (sqlsessiontemplate.java:268)
Com.xinghe.base.BaseMyIbatisDao.deleteBy (basemyibatisdao.java:69)
Com.xinghe.base.BaseMyIbatisDao.deleteById (basemyibatisdao.java:65)
Com.xinghe.base.BaseManager.removeById (basemanager.java:63)
com.xinghe.base.basemanager$ $FastClassBySpringCGLIB $$43ec594b.invoke (<generated>)
Org.springframework.cglib.proxy.MethodProxy.invoke (methodproxy.java:204)
Org.springframework.aop.framework.cglibaopproxy$dynamicadvisedinterceptor.intercept (CglibAopProxy.java:629)
com.xinghe.server.service.middlewaremanager$ $EnhancerBySpringCGLIB $$4cb9903d.removebyid (<generated>)
Com.xinghe.server.web.MiddlewareController.delete (middlewarecontroller.java:91)
SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method)
Sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
Sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
Java.lang.reflect.Method.invoke (Unknown Source)
Org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod ( handlermethodinvoker.java:176)
Org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod ( annotationmethodhandleradapter.java:440)
Org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle ( annotationmethodhandleradapter.java:428)
Org.springframework.web.servlet.DispatcherServlet.doDispatch (dispatcherservlet.java:919)
Org.springframework.web.servlet.DispatcherServlet.doService (dispatcherservlet.java:851)
Org.springframework.web.servlet.FrameworkServlet.processRequest (frameworkservlet.java:953)
Org.springframework.web.servlet.FrameworkServlet.doGet (frameworkservlet.java:844)
Javax.servlet.http.HttpServlet.service (httpservlet.java:620)
Org.springframework.web.servlet.FrameworkServlet.service (frameworkservlet.java:829)
Javax.servlet.http.HttpServlet.service (httpservlet.java:727)
Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52)
Com.auth.filter.AuthorizationFilter.doFilterInternal (authorizationfilter.java:77)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:343)
Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:260)
Com.auth.filter.AuthenticationFilter.doFilterInternal (authenticationfilter.java:113)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:343)
Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:260)
Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:88)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Root cause


Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table ' xinghe.base_class ' doesn ' t exist
Sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method)
Sun.reflect.NativeConstructorAccessorImpl.newInstance (Unknown Source)
Sun.reflect.DelegatingConstructorAccessorImpl.newInstance (Unknown Source)
Java.lang.reflect.Constructor.newInstance (Unknown Source)
Com.mysql.jdbc.Util.handleNewInstance (util.java:411)
Com.mysql.jdbc.Util.getInstance (util.java:386)
Com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:1053)
Com.mysql.jdbc.MysqlIO.checkErrorPacket (mysqlio.java:4096)
Com.mysql.jdbc.MysqlIO.checkErrorPacket (mysqlio.java:4028)
Com.mysql.jdbc.MysqlIO.sendCommand (mysqlio.java:2490)
Com.mysql.jdbc.MysqlIO.sqlQueryDirect (mysqlio.java:2651)
Com.mysql.jdbc.ConnectionImpl.execSQL (connectionimpl.java:2734)
Com.mysql.jdbc.PreparedStatement.executeInternal (preparedstatement.java:2155)
Com.mysql.jdbc.PreparedStatement.execute (preparedstatement.java:1379)
Com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (newproxypreparedstatement.java:989)
Sun.reflect.GeneratedMethodAccessor47.invoke (Unknown Source)
Sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
Java.lang.reflect.Method.invoke (Unknown Source)
Org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke (preparedstatementlogger.java:62)
Com.sun.proxy. $Proxy 17.execute (Unknown Source)
Org.apache.ibatis.executor.statement.PreparedStatementHandler.update (preparedstatementhandler.java:44)
Org.apache.ibatis.executor.statement.RoutingStatementHandler.update (routingstatementhandler.java:69)
Org.apache.ibatis.executor.SimpleExecutor.doUpdate (simpleexecutor.java:48)
Org.apache.ibatis.executor.BaseExecutor.update (baseexecutor.java:105)
SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method)
Sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
Sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
Java.lang.reflect.Method.invoke (Unknown Source)
Org.apache.ibatis.plugin.Invocation.proceed (invocation.java:49)
Com.xinghe.mybatis.FlushCacheInterceptor.intercept (flushcacheinterceptor.java:61)
Org.apache.ibatis.plugin.Plugin.invoke (PLUGIN.JAVA:60)
Com.sun.proxy. $Proxy 15.update (Unknown Source)
SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method)
Sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
Sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
Java.lang.reflect.Method.invoke (Unknown Source)
Org.apache.ibatis.plugin.Plugin.invoke (plugin.java:62)
Com.sun.proxy. $Proxy 15.update (Unknown Source)
Org.apache.ibatis.session.defaults.DefaultSqlSession.update (defaultsqlsession.java:152)
Org.apache.ibatis.session.defaults.DefaultSqlSession.delete (defaultsqlsession.java:165)
SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method)
Sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
Sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
Java.lang.reflect.Method.invoke (Unknown Source)
Org.mybatis.spring.sqlsessiontemplate$sqlsessioninterceptor.invoke (sqlsessiontemplate.java:358)
Com.sun.proxy. $Proxy 12.delete (Unknown Source)
Org.mybatis.spring.SqlSessionTemplate.delete (sqlsessiontemplate.java:268)
Com.xinghe.base.BaseMyIbatisDao.deleteBy (basemyibatisdao.java:69)
Com.xinghe.base.BaseMyIbatisDao.deleteById (basemyibatisdao.java:65)
Com.xinghe.base.BaseManager.removeById (basemanager.java:63)
com.xinghe.base.basemanager$ $FastClassBySpringCGLIB $$43ec594b.invoke (<generated>)
Org.springframework.cglib.proxy.MethodProxy.invoke (methodproxy.java:204)
Org.springframework.aop.framework.cglibaopproxy$dynamicadvisedinterceptor.intercept (CglibAopProxy.java:629)
com.xinghe.server.service.middlewaremanager$ $EnhancerBySpringCGLIB $$4cb9903d.removebyid (<generated>)
Com.xinghe.server.web.MiddlewareController.delete (middlewarecontroller.java:91)
SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method)
Sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
Sun.reflect.DelegatingMethodAccessorImpl.invoke (Unknown Source)
Java.lang.reflect.Method.invoke (Unknown Source)
Org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod ( handlermethodinvoker.java:176)
Org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod ( annotationmethodhandleradapter.java:440)
Org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle ( annotationmethodhandleradapter.java:428)
Org.springframework.web.servlet.DispatcherServlet.doDispatch (dispatcherservlet.java:919)
Org.springframework.web.servlet.DispatcherServlet.doService (dispatcherservlet.java:851)
Org.springframework.web.servlet.FrameworkServlet.processRequest (frameworkservlet.java:953)
Org.springframework.web.servlet.FrameworkServlet.doGet (frameworkservlet.java:844)
Javax.servlet.http.HttpServlet.service (httpservlet.java:620)
Org.springframework.web.servlet.FrameworkServlet.service (frameworkservlet.java:829)
Javax.servlet.http.HttpServlet.service (httpservlet.java:727)
Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52)
Com.auth.filter.AuthorizationFilter.doFilterInternal (authorizationfilter.java:77)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:343)
Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:260)
Com.auth.filter.AuthenticationFilter.doFilterInternal (authenticationfilter.java:113)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:343)
Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:260)
Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:88)
Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:106)
Note the full stack trace of the root cause are available in the Apache tomcat/7.0.54 logs.

Table ' xinghe.base_class ' doesn ' t exist

Error Reason: Data table "Base_class" not Found

Workaround:

The project uses the MyBatis Persistence layer framework, and the mappings to the database are stored in the Xxxmapper.xml file.

XXX for the corresponding entity class name, see if the table name here is not written wrong.

Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Table ' xinghe.base_class ' doesn ' t exist