type Exception report
message org.hibernate.exception.SQLGrammarException: could not extract ResultSet
description The server encountered an internal error that prevented it from fulfilling this request.
exception
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:524) com.china34.johnchen.wms.dao.system.impl.SYS_SystemStationDaoImpl.checkHas(SYS_SystemStationDaoImpl.java:48) sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy87.checkHas(Unknown Source) com.china34.johnchen.wms.dao.site.impl.M_SiteServiceImpl.queryMapping(M_SiteServiceImpl.java:167) sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy109.queryMapping(Unknown Source) com.china34.johnchen.wms.utils.site.SiteUtil.queryDomainMap(SiteUtil.java:1073) com.china34.johnchen.wms.utils.site.SiteUtil.getSyncDomainMap(SiteUtil.java:1160) com.china34.johnchen.wms.utils.site.SiteUtil.getDomainMap(SiteUtil.java:1136) com.china34.johnchen.wms.filters.WMSDomainCoreFilter.getDomainMap(WMSDomainCoreFilter.java:328) com.china34.johnchen.wms.filters.WMSDomainCoreFilter.doFilter(WMSDomainCoreFilter.java:73) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
org.hibernate.exception.SQLGrammarException: could not extract ResultSet org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80) org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) org.hibernate.loader.Loader.getResultSet(Loader.java:2066) org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) org.hibernate.loader.Loader.doQuery(Loader.java:910) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) org.hibernate.loader.Loader.doList(Loader.java:2554) org.hibernate.loader.Loader.doList(Loader.java:2540) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) org.hibernate.loader.Loader.list(Loader.java:2365) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300) org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495) com.china34.johnchen.wms.dao.system.impl.SYS_SystemStationDaoImpl.checkHas(SYS_SystemStationDaoImpl.java:48) sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy87.checkHas(Unknown Source) com.china34.johnchen.wms.dao.site.impl.M_SiteServiceImpl.queryMapping(M_SiteServiceImpl.java:167) sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy109.queryMapping(Unknown Source) com.china34.johnchen.wms.utils.site.SiteUtil.queryDomainMap(SiteUtil.java:1073) com.china34.johnchen.wms.utils.site.SiteUtil.getSyncDomainMap(SiteUtil.java:1160) com.china34.johnchen.wms.utils.site.SiteUtil.getDomainMap(SiteUtil.java:1136) com.china34.johnchen.wms.filters.WMSDomainCoreFilter.getDomainMap(WMSDomainCoreFilter.java:328) com.china34.johnchen.wms.filters.WMSDomainCoreFilter.doFilter(WMSDomainCoreFilter.java:73) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'wms.sys_systemstation' doesn't exist sun.reflect.GeneratedConstructorAccessor80.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) com.mysql.jdbc.Util.handleNewInstance(Util.java:400) com.mysql.jdbc.Util.getInstance(Util.java:383) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471) org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) org.hibernate.loader.Loader.getResultSet(Loader.java:2066) org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) org.hibernate.loader.Loader.doQuery(Loader.java:910) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) org.hibernate.loader.Loader.doList(Loader.java:2554) org.hibernate.loader.Loader.doList(Loader.java:2540) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) org.hibernate.loader.Loader.list(Loader.java:2365) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300) org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495) com.china34.johnchen.wms.dao.system.impl.SYS_SystemStationDaoImpl.checkHas(SYS_SystemStationDaoImpl.java:48) sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy87.checkHas(Unknown Source) com.china34.johnchen.wms.dao.site.impl.M_SiteServiceImpl.queryMapping(M_SiteServiceImpl.java:167) sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy109.queryMapping(Unknown Source) com.china34.johnchen.wms.utils.site.SiteUtil.queryDomainMap(SiteUtil.java:1073) com.china34.johnchen.wms.utils.site.SiteUtil.getSyncDomainMap(SiteUtil.java:1160) com.china34.johnchen.wms.utils.site.SiteUtil.getDomainMap(SiteUtil.java:1136) com.china34.johnchen.wms.filters.WMSDomainCoreFilter.getDomainMap(WMSDomainCoreFilter.java:328) com.china34.johnchen.wms.filters.WMSDomainCoreFilter.doFilter(WMSDomainCoreFilter.java:73) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.53 logs.