I wrote the .size and .absolute methods on QueryResults to do exactly what you are
asking for. It works, and it is scalable.
m
-----Original Message-----
From: lars.gersmann [mailto:[EMAIL PROTECTED]]
Sent: Fri 3/15/2002 1:03 AM
To: [EMAIL PROTECTED]
Cc:
Subject: Re: [castor-dev] Paging result set with OQL
hi,
download the cvs version of castor.
you will find 2 new methods absolute() and size() in class QueryResults
which can be used to match your needs.
there is a mail from ned wolpert which explains a little bit more about these
functions.
see http://www.mail-archive.com/[email protected]/
<http://www.mail-archive.com/[email protected]/> for details.
i never used the methods, but i would be interested in getting feedback for
usability/performance
especially for method absolute().
regards,
lars
-----Ursprüngliche Nachricht-----
Von: 원 태웅 [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 15. März 2002 06:00
An: [EMAIL PROTECTED]
Betreff: [castor-dev] Paging result set with OQL
Hi,
I am new to Castor JDO and OQL and trying to build some pilot
application. The application displays 10 query result in one
page. If I use JDBC directly, I would use absolute() to directly
move cursor to the position I want, or, use sub query.
How can I implement that paging mechanism with JDO and OQL?
Loading every query result object to collection would not be the
answer
because query can return unknown(possibly very large) number of
result objects.
Won, Taewoong
<<winmail.dat>>
