hibernate3报错 XXX is not mapped

最新推荐文章于 2022-05-09 16:05:34 发布
最新推荐文章于 2022-05-09 16:05:34 发布
阅读量85 收藏
点赞数
文章标签： java 测试
原文链接：https://yq.aliyun.com/articles/58058
版权

以前没有用过hibernate，配置hql时出错。

错误日志如下：

org.springframework.orm.hibernate3.HibernateQueryException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:656)
	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
	at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)
	at cn.com.daxtech.framework.orm.hibernate3.dao.impl.HibernateDAOImpl.getListByHql(HibernateDAOImpl.java:288)
	at cn.digitalpublishing.dao.CrRightQtDao.getPagingList(CrRightQtDao.java:15)
	at cn.digitalpublishing.service.impl.CrRightQtServiceImpl.getPagingList(CrRightQtServiceImpl.java:79)
	at sun.reflect.GeneratedMethodAccessor459.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at com.sun.proxy.$Proxy415.getPagingList(Unknown Source)
	at cn.digitalpublishing.springmvc.controller.rightLicense.CrRightQtController.manager(CrRightQtController.java:85)
	at sun.reflect.GeneratedMethodAccessor457.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at cn.digitalpublishing.filter.LanguageFilter.doFilter(LanguageFilter.java:30)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at cn.com.daxtech.framework.web.filter.sso.PermissionFilter.doFilter(PermissionFilter.java:162)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.hql.ast.QuerySyntaxException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]
	at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
	at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:111)
	at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
	at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:327)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3441)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3325)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:733)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:584)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:2321)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:2121)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1522)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:593)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:256)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:187)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
	at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1282)
	at com.sun.proxy.$Proxy7.createQuery(Unknown Source)
	at cn.com.daxtech.framework.orm.hibernate3.dao.impl.HibernateDAOImpl$7.doInHibernate(HibernateDAOImpl.java:290)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
	... 57 more
cn.com.daxtech.framework.exception.CcsException: org.springframework.orm.hibernate3.HibernateQueryException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]
	at cn.digitalpublishing.service.impl.CrRightQtServiceImpl.getPagingList(CrRightQtServiceImpl.java:81)
	at sun.reflect.GeneratedMethodAccessor459.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at com.sun.proxy.$Proxy415.getPagingList(Unknown Source)
	at cn.digitalpublishing.springmvc.controller.rightLicense.CrRightQtController.manager(CrRightQtController.java:85)
	at sun.reflect.GeneratedMethodAccessor457.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at cn.digitalpublishing.filter.LanguageFilter.doFilter(LanguageFilter.java:30)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at cn.com.daxtech.framework.web.filter.sso.PermissionFilter.doFilter(PermissionFilter.java:162)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.orm.hibernate3.HibernateQueryException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:656)
	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
	at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)
	at cn.com.daxtech.framework.orm.hibernate3.dao.impl.HibernateDAOImpl.getListByHql(HibernateDAOImpl.java:288)
	at cn.digitalpublishing.dao.CrRightQtDao.getPagingList(CrRightQtDao.java:15)
	at cn.digitalpublishing.service.impl.CrRightQtServiceImpl.getPagingList(CrRightQtServiceImpl.java:79)
	... 53 more
Caused by: org.hibernate.hql.ast.QuerySyntaxException: crm_person is not mapped [select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus from cn.digitalpublishing.po.CrRightQt a]
	at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
	at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:111)
	at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
	at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:327)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3441)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3325)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:733)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:584)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:2321)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:2121)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1522)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:593)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
	at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:256)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:187)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
	at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1282)
	at com.sun.proxy.$Proxy7.createQuery(Unknown Source)
	at cn.com.daxtech.framework.orm.hibernate3.dao.impl.HibernateDAOImpl$7.doInHibernate(HibernateDAOImpl.java:290)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
	... 57 more

日志很多，挑重点看，crm_person is not mapped  
</pre></p><p>还有，在错误中，还有这样一句话。.</p><p>select a.id, (select z.corp.shortName from cn.digitalpublishing.po.CrmCorpTypeRelationship z where z.id = a.department), a.code, </p><p>和</p><p>(select z.name from crm_person z where z.id = (SELECT x.person.id from cn.digitalpublishing.po.CrmPersonTypeRelationship x where x.id = a.createBy)),</p><p></p><p>从这两句，我感觉到，应该是找不到 我写的crm_person .</p><p> 我的sql语句是从sql中直接复制的，</p><p>XML配置文件，如下：</p><p><pre name="code" class="html"><query>
			<id>getPagingList</id>
			<method>getPagingList</method>
			<params>
				<param name="condition" type="java.util.Map"></param>
				<param name="sort" type="java.lang.String"></param>
			</params>
			<properties>id, department, code, contractType, name, createOn, createBy, dateBegin, dateEnd, otherInfo, remark, approveStatus</properties>
			<fields>a.id, (select z.corp.shortName from CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus</fields>
			<hql>from CrRightQt a</hql>
			<conditions>
				<condition id="id" discribe="ID">
					<params type="param">
						<param name="id" type="java.lang.String" />
					</params>
					<hql>a.id = ?</hql>
				</condition>
				<condition id="department" discribe="部门">
					<params type="param">
						<param name="department" type="java.lang.String" />
					</params>
					<hql>a.department like ?</hql>
				</condition>
				<condition id="code" discribe="合同编号">
					<params type="param">
						<param name="code" type="java.lang.String" />
					</params>
					<hql>a.code like ?</hql>
				</condition>
				<condition id="contractType" discribe="合同类型">
					<params type="param">
						<param name="contractType" type="java.lang.String" />
					</params>
					<hql>a.contractType like ?</hql>
				</condition>
				<condition id="name" discribe="合同名称">
					<params type="param">
						<param name="name" type="java.lang.String" />
					</params>
					<hql>a.name like ?</hql>
				</condition>
				<condition id="createBy" discribe="创建人">
					<params type="param">
						<param name="createBy" type="java.lang.String" />
					</params>
					<hql>a.createBy like ?</hql>
				</condition>
				<condition id="otherInfo" discribe="第三方信息">
					<params type="param">
						<param name="otherInfo" type="java.lang.String" />
					</params>
					<hql>a.otherInfo like ?</hql>
				</condition>
				<condition id="remark" discribe="备注">
					<params type="param">
						<param name="remark" type="java.lang.String" />
					</params>
					<hql>a.remark like ?</hql>
				</condition>
				<condition id="approveStatus" discribe="审批状态">
					<params type="param">
						<param name="approveStatus" type="java.lang.String" />
					</params>
					<hql>a.approveStatus like ?</hql>
				</condition>
			</conditions>
			<group></group>
			<order></order>
			<className>cn.digitalpublishing.po.CrRightQt</className>
		</query>

看重点，如下：

<fields>a.id, (select z.corp.shortName from CrmCorpTypeRelationship z where z.id = a.department), a.code, a.contractType, a.name, a.createOn, (select z.name from crm_person z where z.id = (SELECT x.person.id from CrmPersonTypeRelationship x where x.id = a.createBy)), a.dateBegin, a.dateEnd, a.otherInfo, a.remark, a.approveStatus</fields>


hql，识别 类名，但是，不识别表名，所以报错  is not mapped，

修改crm_person 为CrmPerson ，类名，运行成功

weixin_34013044
关注
Hibernate 中出现表名(XXX) is not mapped 问题
**My Coding Family**
01-17 2万+
当你们遇到这个问题，只能说是没有好好理解Hibernate。当我们执行如下语句的时候： StudentDaoimpl： public int selectAllQingJiaDanCounts(String keyword) { long count = (Long)this.getHibernateTemplate().find(&quot;select count(*) from tb_studen...
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Student is not mapped
游海东的技术专栏
02-23 1844
1、错误描述org.hibernate.hql.internal.ast.QuerySyntaxException: Student is not mapped [from Student ] at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.jav
hibernate 报错： is not mapped
liupan_664021的博客
12-30 702
可能问题是： 1.请务必要注意，在“select aa from User aa where uname= ? and upwd= ?”的时候，这个User，不是你的数据库对应的表名，也不是你的映射文件的表名。而是你的实体对象的名称（是区分大小写的！）。 2.配置文件没有加载到Hibernate的实体类列表里面。 3.映射文件的字段与数据库字段不一致，或者名称不一致 如果都不是可以试...
Hibernate Is Not Mapped
SimonChen
12-02 9050
 好久没玩Hibernate了，都忘记了，今天碰到一个关于没有映射的错误，找了半天才发现原来是HQL的错误。org.springframework.orm.hibernate3.HibernateQueryException: USERINFO is not mapped.看到.hbm.xml文件中的                    配置一直以为所要的对象是table后的USERINFO表名
org.springframework.orm.hibernate3.HibernateQueryException: XXX is not mapped
答案是肯定的
11-03 8204
spring的配置文件中没有配置该实体类
hibernate 出现 is not mapped 问题
老杜的博客
10-17 9985
在用hibernate框架时，  运行时报org.hibernate.hql.ast.QuerySyntaxException:tab_user is not mapped [select u.username from tab_user u where u.username=? and and password=?] 错误：  上面的错误是因为自己写了错误的HQL语句：       Str
Entity not mapped 错误
第一行代码
07-18 858
   对于使用jpa、hibernate这两个框架来说，可能经常一不注意，就会出现这个问题。最近突然遇到这个问题，感觉挺好玩，就记录下来。   一般出现报错， 肯定是先看控制台或者日志，看看有什么错误信息，然后就发现了这个entity not map的错误，一开始是以为实体类的某个字段与数据库映射错误或者@Table(name=“xxx”)中的表名和数据库中没有对应，然后经过仔细检查，发现好像没有...
解决返回JSON报错：HttpMessageNotWritableException: Could not write JSON: Infinite recursion (StackOverflowE
"✧treasure mountain✧"
04-15 9799
问题描述： 持久层框架用的是JPA 在Controller返回JSON数据到前端的时候 出现了这个StackOverflowError的错误 即 在将对象转换为JSON格式的数据的时候出现了无限递归调用的情况 如下图： org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON: ...
Hibernate问题记录
Ably_Clove
04-20 1365
使用hibernate遇到一些问题，罗列出来作为札记备忘。 遇到了如下的错误信息： [ERROR,Dispatcher] Exception occurred during processing request: Could not commit Hibernate transaction; nested exception is org.hibernate.Transaction
Hibernate出现表名is not mapped问题
南_茗的博客
06-19 1282
排查这三点，完美解决Hibernate出现表名is not mapped问题。
Hibernate 中出现 users is not mapped 问题
weixin_42716620的博客
10-23 237
Hibernate 中出现 users is not mapped 问题： 解答：HQL语句中表名应该是ORM映射的类名，所以应该改成： (如果是用注解生成实体类，那就是注解的那个类)String sql = "select u.password fromUser u where u.username='" +user.getUsername()+ "'"; 　　User.hbm...
关于Hibernate 中出现 XXXX is not mapped 问题
baidu_37031847的博客
04-01 2134
出现该问题的原因可能是一下两点 1，如果使用的是this.createQuery(hql)方法，则from表名要是你映射的对应实体类的名称，而不是你数据库里面的表名 2，可能是实体类没有被扫描到 ...
Hibernate出现 is not mapped
无解
01-13 382
1. .java文件中使用的表名字应该是bean类中属性的名字 2. xml配置文件中设置的列属性<property name="name" type="string"> 引号中的name与bean中的属性大小写不一致 <column name="name"。。。。> 中name与主句库中的字段名字不一致 3. java文件使用sql语句时应该使用bean中的属性名称，而不是原始数据库中的字段名称 ...
关于Hibernate 中出现 XXX is not mapped 问题
无解
08-24 246
（1）from表名应为映射的对应实体类的名称，而不是数据库里面的表名 （2）没有在xml中没有添加映射<value>xxx/xxx.hbm.xml<value>
Hibernate 中出现 xxx表 is not mapped xxx的问题
hy565319583的博客
08-15 246
遇到这个问题，发现是没有好好理解hibernate 实体类 数据库 原来hibernate的hql语句中的字段是你实体类中的，不是数据库表的字段，所以才会有这种错误 总结：为了避免不必要的错误，最好实体类和数据表的字段写一样，这样就不容易犯错了 ...
hibernate:XXX is not mapped问题
qq_21644383的博客
05-06 388
hibernate 版本不同，创建SessionFactory方法不同 hibernate5 创建方法为： StandardServiceRegistry standardRegistry = new StandardServiceRegistryBuilder() .configure().build(); Metadata metadata = new Metadata
Hibernate XXX is not mapped
qq_42617840的博客
05-09 345
Hibernate 有两种创建SQL的方式： 1、使用表名 Query query = session.createSQLQuery(hql); 2、使用对象名 Query query = session.createQuery(hql); 当sql中使用的是表名而使用的是第二种创建方式时就会报映射错误
org.hibernate.hql.ast.QuerySyntaxException: is not mapped解决办法
热门推荐
云想衣裳花想容
03-04 2万+
is not mapped这个异常的抛出主要有几个方面： 1、首先要检查的就是不是表名，这个应该大家都知道，hql语句对大小写很严格，因此请注意大小写；你的hql语句中的from是实体类而 2、你的hibernate配置文件中没有加入相应的映射文件； 3、如果上面两方面检查了都没问题，但是还有错，那就是hql语句有错了，好好检查一下，仔细点，不行就重新写一遍，放到数据
org.hibernate.hql.ast.QuerySyntaxException is not mapped
最新发布
03-12
org.hibernate.hql.ast.QuerySyntaxException是Hibernate框架中的一个异常类，表示HQL查询语法错误或实体类未映射的异常。 当在Hibernate中执行HQL查询...3. 检查数据库连接是否正常，确保Hibernate能够连接到数据库。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值