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