From: <glassfish_at_javadesktop.org>
Date: Mon, 07 Jul 2008 10:31:55 PDT

Hi,

I think 'IN' keyword was used for EJB entity navigation, but in a different way.

Suposing "ProgramProductSTG" entity has a many-to-one relationship with ProductCatalogView (by "productId"), I think you could rewrite the EJBQL statement as:

SELECT DISTINCT OBJECT(pcv) FROM ProgramProductSTG ppstg, IN(ppstg.productId) pcv WHERE ppstg.bpomPrgNbr = ?1 ORDER BY pcv.bpomProdFamCd


I hope it works for you.
[Message sent by forum member 'jmarine' (jmarine)]

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