From: <glassfish_at_javadesktop.org>
Date: Thu, 10 Jul 2008 12:20:00 PDT

Hi,

I'm not sure, but you may want to try with these other EJBQL queries:

SELECT OBJECT(cr) FROM CategoryRoot cr, Catalog ca
WHERE cr NOT MEMBER OF ca.categoryRoots
AND ca.catalogId = ?1


SELECT OBJECT(pg) FROM ProductGroup AS pg, IN(pg.catalogs) ca, CrossSellGroup cg
WHERE ca.catalogId = ?1
AND pg NOT MEMBER OF cg.productGroups
[Message sent by forum member 'jmarine' (jmarine)]

http://forums.java.net/jive/thread.jspa?messageID=285776