expecting IDENT错误解决办法

最新推荐文章于 2022-05-23 16:26:02 发布

angel豆蔻年华

最新推荐文章于 2022-05-23 16:26:02 发布

阅读量2.4k

点赞数

分类专栏： hibernate 文章标签： hibernate

本文链接：https://blog.csdn.net/u012635819/article/details/20751463

版权

hibernate 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

今天的开发爆出如下错误。

org.hibernate.hql.ast.QuerySyntaxException: expecting IDENT,found '*' near line 1, column 10 [select a.* fromcom.jyzq.hr.bean.Archive a,com.jyzq.hr.bean.Employeee,com.jyzq.hr.bean.Department d where a.contractEndDate = :date anda.status = 'A' and a.empId = e.id and e.status = 'A' and e.type ='A' and e.deptid=d.id and d.type='A']
atorg.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
atorg.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hi

原因是hql语句报错。

hql:select a.* from Archive a,Employee e,Department d wherea.contractEndDate = :date and a.status = 'A' and a.empId = e.id ande.status = 'A' and e.type = 'A'

把hql改为如下形式，则编译通过。一切正常

select a from Archive a,Employee e,Department d wherea.contractEndDate = :date and a.status = 'A' and a.empId = e.id ande.status = 'A' and e.type = 'A'

select 后面为对象 a .而非 a.*