Hi Suneel,
What is also absurd is that sometimes it's possible to help GlassFish to generate the correct SQL statements with only changing the order of conditions (to previously concrete the other ejbs, before comparing their fields/relations).
I think you had get the desired results with this other EJBQL statement:
SELECT OBJECT(o) FROM Category o ,Category category
WHERE category.categoryId = ?1
AND category.parentCategoryId = o.parentCategoryId
AND o.categoryRootId = ?2
ORDER BY o.displayOrder
Would you want to try the proposed statement?
If it works, it could be a similar problem you had with "NOT MEMBER OF" operator (
http://forums.java.net/jive/thread.jspa?threadID=45567&tstart=0)...
And it may be worth to open an issue ?
[Message sent by forum member 'jmarine' (jmarine)]
http://forums.java.net/jive/thread.jspa?messageID=293608