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.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.$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)
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(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.$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
错误原因:找不到数据表“base_class”
解决方法:
项目使用的是mybatis持久层框架,与数据库的映射关系都保存在xxxmapper.xml文件中,
xxx为对应的实体类名,看看这里的表名是不是写错了。