HTTP Status 500 – Internal Server Error


Type Exception Report

Message Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.jeecms.cms.entity.main.CmsSiteCompany#4]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.jeecms.cms.entity.main.CmsSiteCompany#4]
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.jeecms.common.web.XssFilter.doFilter(XssFilter.java:41)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35)

Root Cause

org.hibernate.exception.SQLGrammarException: could not load an entity: [com.jeecms.cms.entity.main.CmsSiteCompany#4]
	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
	org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
	org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
	org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
	org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
	org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
	org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
	org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
	org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
	org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
	org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1038)
	org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:630)
	org.hibernate.type.EntityType.resolve(EntityType.java:438)
	org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:139)
	org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:982)
	org.hibernate.loader.Loader.doQuery(Loader.java:857)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	org.hibernate.loader.Loader.doList(Loader.java:2533)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	org.hibernate.loader.Loader.list(Loader.java:2271)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	com.jeecms.cms.dao.main.impl.CmsSiteDaoImpl.getList(CmsSiteDaoImpl.java:25)
	com.jeecms.cms.manager.main.impl.CmsSiteMngImpl.getListFromCache(CmsSiteMngImpl.java:37)
	sun.reflect.GeneratedMethodAccessor358.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:333)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	com.sun.proxy.$Proxy81.getListFromCache(Unknown Source)
	com.jeecms.cms.web.FrontContextInterceptor.preHandle(FrontContextInterceptor.java:81)
	org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:134)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:958)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.jeecms.common.web.XssFilter.doFilter(XssFilter.java:41)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35)

Root Cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'everstar.jc_site_company' doesn't exist
	sun.reflect.GeneratedConstructorAccessor334.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:425)
	com.mysql.jdbc.Util.getInstance(Util.java:408)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020)
	com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
	org.hibernate.loader.Loader.doQuery(Loader.java:802)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
	org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
	org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
	org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
	org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
	org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
	org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
	org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
	org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
	org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
	org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1038)
	org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:630)
	org.hibernate.type.EntityType.resolve(EntityType.java:438)
	org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:139)
	org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:982)
	org.hibernate.loader.Loader.doQuery(Loader.java:857)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	org.hibernate.loader.Loader.doList(Loader.java:2533)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	org.hibernate.loader.Loader.list(Loader.java:2271)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	com.jeecms.cms.dao.main.impl.CmsSiteDaoImpl.getList(CmsSiteDaoImpl.java:25)
	com.jeecms.cms.manager.main.impl.CmsSiteMngImpl.getListFromCache(CmsSiteMngImpl.java:37)
	sun.reflect.GeneratedMethodAccessor358.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:333)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	com.sun.proxy.$Proxy81.getListFromCache(Unknown Source)
	com.jeecms.cms.web.FrontContextInterceptor.preHandle(FrontContextInterceptor.java:81)
	org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:134)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:958)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.jeecms.common.web.XssFilter.doFilter(XssFilter.java:41)
	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35)

Note The full stack trace of the root cause is available in the server logs.


Tomcat