From: <glassfish_at_javadesktop.org>
Date: Thu, 10 Jul 2008 10:10:58 PDT

Hi,

Here are the queries that are working fine in weblogic but throw an error in glassfish when migrating. I couldn't find a way to convert them into glassfish supported ejb-ql.

SELECT OBJECT(cr) FROM CategoryRoot cr
                                                WHERE cr.categoryRootId
                                                        NOT IN (SELECT cr_sub.categoryRootId FROM Catalog ca,
                                                                        IN (ca.categoryRoots) cr_sub
                                                                        WHERE ca.catalogId = ?1 )


SELECT OBJECT(pg) FROM ProductGroup AS pg
                                                 WHERE pg.catalogs.catalogId = ?1
                                                 AND NOT EXISTS (SELECT OBJECT(cg) FROM CrossSellGroup cg
                                                                                  WHERE cg.productGroups.productGroupId = pg.productGroupId)



Thanks
Suneel
[Message sent by forum member 'suneelgv' (suneelgv)]

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