com mysql jdbc exceptions jdbc4 MySQLSyntaxErrorException Ta

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

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 FastClassBySpringCGLIB

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 is available in the Apache Tomcat/7.0.54 logs.

Table 'xinghe.base_class' doesn't exist

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

解决方法：

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

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

           

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow