Based on my reading of the EJB QL BNF grammar in EJB 3.0 spec, it looks like sub query in the WHERE clause is not permitted. So the following is not allowed.
(SELECT cr_sub.categoryRootId FROM Catalog ca,
IN (ca.categoryRoots) cr_sub
WHERE ca.catalogId = ?1 )
Likewise EXISTS is not supported in EJB QL either.
Sunil: Do the suggested rewrite of the queries posted in this thread work ?
[Message sent by forum member 'sekhar' (sekhar)]
http://forums.java.net/jive/thread.jspa?messageID=286604