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

版权声明：本文为 testcs_dn(微wx笑) 原创文章，非商用自由转载-保持署名-注明出处，谢谢。 https://blog.csdn.net/testcs_dn/article/details/41650303

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.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

root cause

org.springframework.jdbc.BadSqlGrammarException: 

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(<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)

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)

org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)

com.sun.proxy.$Proxy17.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)

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)

org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)

org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)

org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:165)

org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)

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

错误原因：找不到数据表“base_class”

解决方法：

项目使用的是MyBatis持久层框架，与数据库的映射关系都保存在xxxMapper.xml文件中，

xxx为对应的实体类名，看看这里的表名是不是写错了。