java - hibernate 期待 "all"，发现 'JOIN'

Question

我得到了

QuerySyntaxException: expecting "all", found 'JOIN' near line 1, column 50 [SELECT p FROM com.rr.model.Person p FETCH JOIN p.positions pos WHERE p.id=:id]

Hibernate 异常。将“JOIN”更改为“ALL”无济于事并会产生以下错误:

QuerySyntaxException: expecting "properties", found 'p' near line 1, column 54 [SELECT p FROM com.rr.model.Person p FETCH ALL p.positions pos WHERE p.id=:id]

发生了什么以及正确的查询应该是什么样子？

Answer 1

问题是我将语法切换为“FETCH JOIN”，形成了正确的语法:“JOIN FETCH”。正确的查询应该是这样的

 SELECT p FROM Person p JOIN FETCH p.positions pos WHERE p.id=:id

“ALL”的正确语法如下所示:

SELECT p FROM Person p FETCH ALL PROPERTIES WHERE p.id=:id