db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zithulele Basil Shange" <zithule...@cibecs.com>
Subject Large Resultset
Date Tue, 28 Feb 2006 15:37:49 GMT
I have a DB (Derby) having 100's thousands of rows. I would like to select
row using a condition and be able to page them. The problem is that if I
page them in memory I get an outofmemory error or the rowset returns a
couple of thousands instead of all the rows matching the condition. 
 
Is there a way of retrieving a large amount of data rows and be able to page
them as well?
 
I have tried to limitting the results by setMaxRows but paging them is a
problem.
 
Regards
Zithulele

Mime
View raw message