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就可以了。

相关推荐
©️2020 CSDN 皮肤主题: 博客之星2020 设计师:CY__ 返回首页