异常收集-org.hibernate.hql.internal.ast.QuerySyntaxException: activityinfo is not mapped

在工作过程中，发现在使用Hibernate的时候出现了org.hibernate.hql.internal.ast.QuerySyntaxException: activityinfo is not mapped 这样的异常，由于是第一次使用Hibernate，所以没有反应到底是什么样的错误。后来在网上找了找相关的文章看了看，并对照自己编写的代码，原来在自己写的hql语句的时候出现了问题。不像sql语句， 在编写hql语句的时候，应该使用数据表所映射的实体类名，而不是数据表名。（原来我的数据表名为activityinfo ，而对应的实体名为ActivityInfo，所以在hql语句中将activityinfo 替换成ActivityInfo即可）。经验证，修改后运行正确。

给出异常的完整描述：

2015-09-22 10:38:15,656 - com.iflytek.ossp.controller.GlobalExceptionHandler -51861 [http-8081-3] ERROR  - activityinfo is not mapped [from activityinfo where 1=1  order by starttime desc]

org.hibernate.hql.internal.ast.QuerySyntaxException: activityinfo is not mapped [from activityinfo where 1=1  order by starttime desc]

 at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)

 at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)

 at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93)

 at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:326)

 at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3252)

 at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3141)

 at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:694)

 at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:550)

 at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:287)

 at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:235)

 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)

 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)

 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)

 at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:101)

 at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)

 at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:119)

 at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:215)

 at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:193)

 at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1649)

 at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:286)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

 at java.lang.reflect.Method.invoke(Method.java:601)

 at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:342)

 at $Proxy38.createQuery(Unknown Source)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

 at java.lang.reflect.Method.invoke(Method.java:601)

 at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:289)

 at $Proxy38.createQuery(Unknown Source)

 at com.iflytek.ossp.core.dao.FeeJpaDao.find(FeeJpaDao.java:157)

 at com.iflytek.ossp.core.dao.FeeJpaDao$$FastClassBySpringCGLIB$$24d97134.invoke(<generated>)

 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:649)

 at com.iflytek.ossp.core.dao.FeeJpaDao$$EnhancerBySpringCGLIB$$23fb0c99.find(<generated>)

 at com.iflytek.ossp.fee.service.ActivityInfoManageService.page(ActivityInfoManageService.java:67)

 at com.iflytek.ossp.fee.service.ActivityInfoManageService$$FastClassBySpringCGLIB$$b6218690.invoke(<generated>)

 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:649)

 at com.iflytek.ossp.fee.service.ActivityInfoManageService$$EnhancerBySpringCGLIB$$63f13275.page(<generated>)

 at com.iflytek.ossp.fee.controller.ActivityInfoManageController.getTaskInfoList(ActivityInfoManageController.java:92)

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

 at java.lang.reflect.Method.invoke(Method.java:601)

 at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

 at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

 at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

 at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781)

 at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721)

 at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)

 at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)

 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)

 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)

 at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

 at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:177)

 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

 at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

 at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

 at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

 at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

 at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

 at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

 at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

 at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

 at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

 at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

 at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)

 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)

 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

 at java.lang.Thread.run(Thread.java:722)