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

Filed under:
|
|
|
|

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

Related posts about ejbql

Related posts about java