org.hibernate.QueryException: could not resolve property:

最新推荐文章于 2019-01-01 19:20:21 发布
原创 最新推荐文章于 2019-01-01 19:20:21 发布 · 1.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#hibernate #Hibernate #J2EE #j2ee #j2EE #jpa #JPA #shh

本文详细分析了一个HQL查询过程中出现的异常，即在查询语句中属性与实际实体类中定义的属性不一致的情况，并提供了相应的修改建议。通过修改查询语句中的属性名，确保它们与实体类属性相匹配，从而解决了查询错误。
org.hibernate.QueryException: could not resolve property: account of: entity.KpsysLog [from entity.KpsysLog log where log.account like '%%' and log.table_name like '%%' and log.AuthorityID=0] 
    org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)
    org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:75)
    org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1465)
    org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:315)
    org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:487)
    org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:611)
    org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263)
    org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:210)
    org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:117)
    org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:113)
    org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:880)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1330)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4471)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4088)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2047)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1972)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:831)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:617)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
    org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
    org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
    org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
    org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)
    org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80)
    org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:93)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.springframework.orm.jpa.JpaTemplate$CloseSuppressingInvocationHandler.invoke(JpaTemplate.java:404)
    $Proxy19.createQuery(Unknown Source)
    org.springframework.orm.jpa.JpaTemplate$9.doInJpa(JpaTemplate.java:313)
    org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:184)
    org.springframework.orm.jpa.JpaTemplate.executeFind(JpaTemplate.java:151)
    org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:311)
    org.springframework.orm.jpa.JpaTemplate.find(JpaTemplate.java:307)
    personnel_dao.impl.KpsysLogDaoImpl.qiuerylist(KpsysLogDaoImpl.java:28)
    personnel.service.impl.KpsysLogServiceImpl.queryList(KpsysLogServiceImpl.java:32)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    $Proxy15.queryList(Unknown Source)
    jsp_entity.SysLog.searchlog(SysLog.java:257)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:446)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:285)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:238)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:238)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:90)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:544)
    org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    java.lang.Thread.run(Thread.java:619)

原因：hql查询语句中属性与实体类中定义的属性不一致
修改前的代码：
hqlquery="from KpsysLog log where log.account like '%"+account+"%' and log.table_name like '%"+tablename+"%' and log.AuthorityID like '%"+authorityID+"%'";
修改后的代码：
hqlquery="from KpsysLog log where log.usert.account like '%"+account+"%' and log.table_name like '%"+tablename+"%' and log.authority.AuthorityID like '%"+authorityID+"%'";
 
 
KpsysLog引用了user_table和Authority两个类的主键属性，而且在KpsysLog类的私有属性中，定义了user_table类的实例uert和Authority类的实例authority;
org.hibernate.QueryException: could not resolve property 错误解析
litlit023的专栏
11-30 1997
本文前三条内容转自----http://blog.csdn.net/jsjxieyang/article/details/5863238 原因1：程序相关set,get方法没写对，或者是映射文件 出错了。请仔细检查。   原因2：程序变量名包涵 下划线"_", hibernate可能无法解析，从而报错。   原因3：也是我遇到的问题。在多条件查询中，               
org.hibernate.QueryException: could not resolve property
weixin_33759269的博客
02-01 407
2019独角兽企业重金招聘Python工程师标准>>> ...
常见Hibernate报错处理：出现“org.hibernate.QueryException: could not resolve property”和 is not mapped和could no...
weixin_34348111的博客
10-17 1343
　　正确写法： 　　@Override @SuppressWarnings("unchecked") public List<Device> queryOSDevice(String cpu){ String sql = null; if(cpu.equals("os_xp")){ sql = "from "+t...
could not resolve property（无法解析属性）
热门推荐
谢彬の优快云专栏
04-01 6万+
could not resolve property（无法解析属性） 顾名思义在写hql语句的时候，属性写错了！ 请检查大小写，是实体类的，不是数据库表的！ 一个一个检查，仔细看！
Caused by: org.hibernate.QueryException: could not resolve property
漂泊的心的专栏
09-21 6161
<br />案例：Caused by: org.hibernate.QueryException: could not resolve property: id     （id为hql语句中的实体类的字段）<br /> <br />原因分析：1.Hibernate的错误提示信息可能不够准确，最好仔细检查hql语言（我就是c.creatorId = :cid 写错成：c.creatorId := cid）<br />2.字段映射出问题，检查变量名是否对应
org.hibernate.QueryException: could not resolve property：artical_uid
shijiujiu33的博客
01-01 544
今天在使用hibernate查询数据库的时候，报了这个异常。出错的语句是在 detachedCriteria.add(Restrictions.eq("artical_uid",user.getUid()); 这是因为我数据库artical这张表关联了user这张表，然后想根据用户查询文章，使用上面的查询语句就报错了。 org.hibernate.QueryException: could no...
org.hibernate.QueryException: could not resolve property的解决办法
Coder Wang
09-22 8656
could not resolve property: cust_name of: domain.Customer could not resolve property: cust_name of: domain.Customer; nested exception is org.hibernate.QueryException: could not resolve property: cust_...
hibernate报错：org.hibernate.QueryException: could not resolve property
yasashikokoro的博客
05-08 818
hibernate报错：org.hibernate.QueryException: could not resolve property错误：错误原因：不能解析属性，hql语句中的linkMens与配置中不一致解决方案：将上述hql语句中的linkMens改为LinkMens...
could not resolve property(无法辨别的属性)
05-10 2万+
org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: packagetype of: com.telecone.domain.Packageinfo[from com.telecone.domain.Packageinfo  p where 1=1 and p.packag
异常org.hibernate.QueryException: could not resolve property的原因 解决办法
极品小肥羊的博客
07-13 4万+
异常org.hibernate.QueryException: could not resolve property的原因 解决办法 异常消息如下所示： org.hibernate.QueryException: could not resolve property: task_no of: edu.cust.entity.Task at org.hibernate.persiste
org.hibernate.QueryException: could not resolve property错误的解决方法
weixin_30481087的博客
10-27 1284
出现这个异常，大多是因为我们在HQL和SQL语句的使用上造成混淆。因为Hibernate使用的是hql语法，而sql语法和它是有区别的。当然了，加入表的字段和映射成hbm.xml文件中属性字段一样的话，就很少发生这样的情况。比如：ID是表的字段，那么在hbm.xml文件中也是ID，做检索的时候就不能发生问题了。但是，加入我的表的字段是Person_Name,那么在hbm.xml文件中可能就是per...
出现“org.hibernate.QueryException: could not resolve property”错误的解决
干勾鱼的优快云博客
01-13 1万+
使用hibernate执行查询时，有时候会出现：org.hibernate.QueryException: could not resolve property的问题，这是由于HQL和SQL的语句使用不同造成的。hibernate使用hql语法，而sql语法与hql是不一样的。使用hql时，字段名要与hbm.xml文件中的“name”的值保持一致：<propery name="Count" colu
org.hibernate.QueryException: could not resolve property: processInstanceId of:参数问题
FromNowOnUntilTheEnd
11-19 454
报异常： org.hibernate.QueryException: could not resolve property: processInstanceId of: com.notice.entity.Notice 参数问题，原因： 1、前端传入的参数为null 2、传入的参数不合格式...
org.hibernate.queryexception: could not resolve property
04-09
这个错误出现在 Hibernate 中，意思是无法解析实体中的属性。通常是因为实体类中的属性与 Hibernate 的映射文件不匹配或者查询语句中使用了错误或不存在的属性。需要检查实体类和映射文件的属性名是否一致，或者在查询语句中使用正确的属性名。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值