美文网首页
Hql连接查询的两个错误(Path expected for j

Hql连接查询的两个错误(Path expected for j

作者: 赵镇 | 来源:发表于2017-09-04 07:55 被阅读813次

1. Path expected for join!

Path expected for join! [SELECT count() FROM cn.com.jsoft.entities.TDSysnphoto p left join TDSysnotice s where p.snid = s.id]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [SELECT count() FROM cn.com.jsoft.entities.TDSysnphoto p left join TDSysnotice s where p.snid = s.id]

解决方案:这个错误的原因是Hibernate不认识join,我们需要将Left join改成,即可,‘,’也是连接查询

unexpected token on

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 153 [select cust.name,cust.sex,cust.birthday,cust.idType,cust.idNo,cust.phone,clu.physicalNo From

解决方案:在Hibernate中不允许存在on,将on改为Where就可以了。

相关文章

网友评论

      本文标题:Hql连接查询的两个错误(Path expected for j

      本文链接:https://www.haomeiwen.com/subject/rypsjxtx.html