java - HQL 缺少关键字

Question

我已经寻找了几个小时，但找不到以下查询中缺少的内容:

SELECT count(*) FROM Request r JOIN r.status status WHERE r.uniqueId = '123456'

我收到以下异常:

java.sql.SQLSyntaxErrorException: ORA-00905: missing keyword

Answer 1

根据Doc，我认为您错过了关键字AS:

SELECT count(*) 
FROM Request r INNER JOIN 
     r.status AS status -- AS missed
WHERE r.uniqueId = '123456'