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]>
