I wrote the .size and .absolute methods on QueryResults to do exactly
what you are asking for. It works, and it is scalable.
-----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.
i never used the methods, but i would be interested in getting
feedback for usability/performance
especially for method absolute().
regards,
lars
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
