hi edith,
the prefetch stuff can be found in query.html in the doc directory.
in the ojb.properties you can only define the limit for the IN statement.
crit = new Criteria();
crit.addOrderByDescending("id");
crit.addOrderByAscending("geburtsDatum");
crit.addPrefetchedRelationship("konti"); <<<<<<<<
query = new QueryByCriteria(Person.class, crit);
hth
jakob
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 2002 3:34 PM
Subject: [query prefetching] How can I make it work ?
>
> Hello,
>
> Query prefetching is implemented in OJB.
> However, I have not found in the docs (Prefetched RelationShips)
> how I can get it work. I use the ODMG API and Oracle database.
>
> I only found the property PrefetchInLimit in OJB.properties and set it at
> -1,
> but I see that OJB still generates as many SQL queries as objets in the
> relationships when I select an object that is involved in "to n"
> relationships
>
> Thanks for help,
>
> Edith.
>
>
>
>
>
> ----------------
> Les donnees et renseignements contenus dans ce message sont personnels,
confidentiels et secrets. Ce message est adresse a l'individu ou l'entite
dont les coordonnees figurent ci-dessus. Si vous n'etes pas le bon
destinataire, nous vous demandons de ne pas lire, copier, utiliser ou
divulguer cette communication. Nous vous prions de notifier cette erreur a
l'expediteur et d'effacer immediatement cette communication de votre
systeme.
> The information contained in this message is privileged, confidential, and
protected from disclosure. This message is intended for the individual or
entity adressed herein. If you are not the intended recipient, please do not
read, copy, use or disclose this communication to others; also please notify
the sender by replying to this message, and then delete it from your system.
>
>
> --
> 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]>
