Com. mysql. jdbc. exceptions. jdbc4.MySQLSyntaxErrorExceptionTa

Com. mysql. jdbc. exceptions. jdbc4.MySQLSyntaxErrorExceptionTablexinghe. base_classdoesntexistHTTPStatus500

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 messa

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. $ Proxy12.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 ( )
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 ( )
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.exe cSQL (ConnectionImpl. java: 2734)
Com.mysql.jdbc.PreparedStatement.exe cuteInternal (PreparedStatement. java: 2155)
Com.mysql.jdbc.PreparedStatement.exe cute (PreparedStatement. java: 1379)
Com.mchange.v2.c31_impl.newproxypreparedstatement.exe cute (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.w.proxy17.exe cute (Unknown Source)
Org.apache.ibatis.exe cutor. statement. PreparedStatementHandler. update (PreparedStatementHandler. java: 44)
Org.apache.ibatis.exe cutor. statement. RoutingStatementHandler. update (RoutingStatementHandler. java: 69)
Org.apache.ibatis.exe cutor. SimpleExecutor. doUpdate (SimpleExecutor. java: 48)
Org.apache.ibatis.exe cutor. 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. $ Proxy15.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. $ Proxy15.update (Unknown Source)
Org. apache. ibatis. session. defaults. DefaultSqlSession. update (defasqlsqlsession. java: 152)
Org. apache. ibatis. session. defaults. DefaultSqlSession. delete (defasqlsqlsession. 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. $ Proxy12.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 ( )
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 ( )
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 is available in the Apache Tomcat/7.0.54 logs.

Table 'xinghe. base_class 'doesn' t exist

Error cause: unable to find the data table "base_class"

Solution:

The project uses the MyBatis persistence layer framework, and the ing relationship with the database is saved in the xxxMapper. xml file,

Xxx is the corresponding object class name. Check if the table name is incorrect.