grrrr..... am I sure? not at all, lol.... yes, thats exactly what I want.... thanks for that
cheers dim ----- Original Message ----- From: "Alex Loubyansky" <[EMAIL PROTECTED]> To: "Dmitri Colebatch" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 10:21 PM Subject: Re[2]: [JBoss-user] status of self-relationships in jboss3 final > 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
