Hello Dmitri, Are you sure parent can't be NULL? I have similar finder to get root categories, i.e. categories that don't have a parent. I do it this way: SELECT OBJECT(c) FROM Category c WHERE (c.parent IS NULL)
Does it help? alex Monday, June 10, 2002, 3:17:11 PM, you wrote: DC> Alex, DC> Thanks. ok, well I'll post my problem then (o: DC> I have a SectionEJB, which has a relationship to itself (parent). I'm DC> trying to have an ejbSelect method, as follows: DC> <query> DC> <query-method> DC> <method-name>ejbSelectTopLevelSections</method-name> DC> <method-params> DC> </method-params> DC> </query-method> DC> <ejb-ql><![CDATA[SELECT OBJECT(s) FROM Section AS s WHERE DC> s.parent.name IS NULL]]></ejb-ql> DC> </query> DC> the Section ejb has a name field.... hopefully what I'm trying to do is DC> fairly self-explanatory.... am I missing something simple/obvious? DC> cheers DC> dim DC> ----- Original Message ----- DC> From: "Alex Loubyansky" <[EMAIL PROTECTED]> DC> To: "Dmitri Colebatch" <[EMAIL PROTECTED]> DC> Cc: <[EMAIL PROTECTED]> DC> Sent: Monday, June 10, 2002 10:09 PM DC> Subject: Re: [JBoss-user] status of self-relationships in jboss3 final >> Hello Dmitri, >> >> I haven't tried 3.0 final but my self-relationships work fine on >> rc.1/2/3 and 3.1.0alpha. >> >> alex >> >> Monday, June 10, 2002, 3:03:49 PM, you wrote: >> >> DC> hey all, >> >> DC> before I go to far, does anyone know what the status of self DC> relationships are in jboss3 final? I'm having a problem with an ejbSelect DC> method on an entity that has a n-1 relationship with >> DC> itself... >> >> DC> tia >> DC> dim >> >> -- >> Best regards, >> Alex Loubyansky >> >> DC> _______________________________________________________________ DC> Don't miss the 2002 Sprint PCS Application Developer's Conference DC> August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink DC> _______________________________________________ DC> JBoss-user mailing list DC> [EMAIL PROTECTED] DC> https://lists.sourceforge.net/lists/listinfo/jboss-user -- Best regards, Alex Loubyansky _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
