Hql连接查询的两个错误（Path expected for join!和unexpected token on）

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 join!和unexpected token on）的全部内容，更多相关Hql连接查询的两个错误（Path内容请搜索靠谱客的其他文章。