Is this valid EJB-QL?
Posted
by Yishai
on Stack Overflow
See other posts from Stack Overflow
or by Yishai
Published on 2010-04-22T14:23:08Z
Indexed on
2010/04/29
2:47 UTC
Read the original article
Hit count: 484
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?
© Stack Overflow or respective owner