Ok, so QueryByMtoNCriteria is not the answer, as I suspected, but then -
what is?
----- Original Message -----
From: "Jakob Braeuchi" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 4:52 PM
Subject: Re: Query on collections
> hi rudi,
>
> QueryByMtoNCriteria is mainly used for internal stuff.
>
> jakob
> ----- Original Message -----
> From: "Rudi Alberda" <[EMAIL PROTECTED]>
> To: "OJB Users List" <[EMAIL PROTECTED]>
> Sent: Thursday, October 03, 2002 1:48 PM
> Subject: Query on collections
>
>
> > Hi all,
> >
> > I have a question regarding queries on m:n relations. Suppose I have two
> > classes which are associated in OJB through a m:n relation, objects of
> type
> > 'A' and 'B'. 'A' has a property called 'bees' returning all objects of
> type
> > 'B', 'B' has a property called 'as' which returns all 'A' objects.
> > This all works nicely in OJB, storing, updating, deleting. But now I
want
> to
> > query. I have an object of type 'B' and I want to know which objects of
> type
> > 'A' are associated to it. In other words, I'd like a query which results
> in
> > a collection of 'A' objects for which 'B' is in the collection 'A.bees'.
> > How would this work?
> > I cannot simply go and create a query like:
> >
> > Criteria c = new Criteria();
> > c.addEqualTo("bees", B);
> > Query q = new QueryByCriteria(B.class, c, false);
> > broker.getCollectionByQuery(q);
> >
> > because bees is a collection. Will Criteria.addIn work? And if this
> doesn't,
> > what will?
> > I have looked at QueryByMtoNCriteria but the documentation of this was
> > rather unclear.
> > Also, I might be able to use Criteria.addExists, but I need to refer to
a
> > field from the main query in the subquery, otherwise my subQuery isn't
of
> > much use.
> > Help!
> >
> >
> > --
> > To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
> >
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
