Is this valid EJB-QL?
- by Yishai
I have the following construct in EJB-QL several EJB 2.1 finder methods:
SELECT distinct OBJECT(rd) FROM RequestDetail rd, DetailResponse dr
WHERE dr.updateReqResponseParentID is not null
and dr.updateReqResponseParentID = ?1
and rd.requestDetailID = dr.requestDetailID
and rd.deleted is null and dr.deleted is null
IDEA's EJB-QL inspection flags the use of the two object FROM RequestDetail rd, DetailResponse dr with an inspection which says: Several ranged variable declarations are not supported, use collection member declarations instead (e.g. IN(o.lineItems))
The queries themselves function fine (as in return the expected results) on JBoss 4.2. Is IDEA all wet here, or is there a valid issue with the query? And what is the actual preferred alternative syntax for such a query?