Re: [castor-dev] Paging result set with OQL

[lars.gersmann]

Title: �޽���

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/castor-dev@exolab.org/ 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