2014-10-10 16:35:27.985 [http-8081-2] ERROR com.gamepro.web.controller.GeneralReportController.generalReportlist - /generalreport/generalReportlist error
org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:296) ~[spring-orm-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.orm.jpa.aspectj.JpaExceptionTranslatorAspect.ajc$afterThrowing$org_springframework_orm_jpa_aspectj_JpaExceptionTranslatorAspect$1$18a1ac9(JpaExceptionTranslatorAspect.aj:33) ~[spring-aspects-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at com.gamepro.core.domain.GeneralReport.getqueryGeneralReport_aroundBody0(GeneralReport.java:177) ~[gamepro-core-0.1.0.BUILD-SNAPSHOT.jar:na]
at com.gamepro.core.domain.GeneralReport.getqueryGeneralReport(GeneralReport.java:1) ~[gamepro-core-0.1.0.BUILD-SNAPSHOT.jar:na]
at com.gamepro.web.controller.GeneralReportController.generalReportlist(GeneralReportController.java:42) ~[GeneralReportController.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_29]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) [spring-web-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) [spring-webmvc-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685) [spring-webmvc-3.2.11.RELEASE.jar:3.2.11.RELEASE]
李晨星
2014/10/10 16:38:09
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1201) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:296) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_29]
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366) ~[spring-orm-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at $Proxy98.createQuery(Unknown Source) ~[na:na]
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_29]
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241) ~[spring-orm-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at $Proxy94.createQuery(Unknown Source) ~[na:na]
... 44 common frames omitted
李晨星
2014/10/10 16:38:16
Caused by: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:111) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:327) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3441) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3325) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:733) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:584) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:281) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
... 54 common frames omitted
hql语句 中表名与实体类一致
public class GeneralReport{}
SELECT o FROM GeneralReport o
否则就会报上面 错
下面摘抄别处
1、最容易想到的,就是你的from是实体类而不是表名,这个应该大家都知道,注意大小写
org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:296) ~[spring-orm-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.orm.jpa.aspectj.JpaExceptionTranslatorAspect.ajc$afterThrowing$org_springframework_orm_jpa_aspectj_JpaExceptionTranslatorAspect$1$18a1ac9(JpaExceptionTranslatorAspect.aj:33) ~[spring-aspects-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at com.gamepro.core.domain.GeneralReport.getqueryGeneralReport_aroundBody0(GeneralReport.java:177) ~[gamepro-core-0.1.0.BUILD-SNAPSHOT.jar:na]
at com.gamepro.core.domain.GeneralReport.getqueryGeneralReport(GeneralReport.java:1) ~[gamepro-core-0.1.0.BUILD-SNAPSHOT.jar:na]
at com.gamepro.web.controller.GeneralReportController.generalReportlist(GeneralReportController.java:42) ~[GeneralReportController.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_29]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_29]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_29]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) [spring-web-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) [spring-webmvc-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685) [spring-webmvc-3.2.11.RELEASE.jar:3.2.11.RELEASE]
李晨星
2014/10/10 16:38:09
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1201) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:296) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_29]
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366) ~[spring-orm-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at $Proxy98.createQuery(Unknown Source) ~[na:na]
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_29]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_29]
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241) ~[spring-orm-3.2.11.RELEASE.jar:3.2.11.RELEASE]
at $Proxy94.createQuery(Unknown Source) ~[na:na]
... 44 common frames omitted
李晨星
2014/10/10 16:38:16
Caused by: org.hibernate.hql.ast.QuerySyntaxException: generalreport is not mapped [SELECT o FROM generalreport o WHERE 1=1 ORDER BY o.id DESC ]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:111) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:327) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3441) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3325) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:733) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:584) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) ~[hibernate-core-3.6.1.Final.jar:3.6.1.Final]
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:281) ~[hibernate-entitymanager-3.6.1.Final.jar:3.6.1.Final]
... 54 common frames omitted
hql语句 中表名与实体类一致
public class GeneralReport{}
SELECT o FROM GeneralReport o
否则就会报上面 错
下面摘抄别处
1、最容易想到的,就是你的from是实体类而不是表名,这个应该大家都知道,注意大小写
2、你的hibernate配置文件中没有加入相应的映射文件<mapping resource=" " />
3、如果上面两方面都对了,还有错,基本上处于崩溃状态,哈哈....一般是上面两种原因,还是不行,那就是你hql语句有错了,好好检查一下,仔细点,不行就重新写一遍,因为我就是因为一个中文空格被折腾了两天啊,就是找不出哪儿出错了,怎么看怎么对,可是就是报错,哈哈...很崩溃的。