How to retrieve results from DB in sections

[bthale]

I have a query that sometimes returns a ResultSet that is too large for memeory (yes, I have added the java params to set the memory as high as possible, but still crashes). Is there a way to limit the size and still retrieve everything in segments or sessions?
Example, the full results will return 10,000 rows, but it's too large so I want to get 5,000 rows, then the next 5,000 rows. We are using Spring jdbc classes and I can't seem to find a way to do it using getMoreResults and setMaxRows

 

[tom62]

It depends on the type of database that you are using, for example in MySQL you could create a streaming Resultset to retrieve one record at the time.

For more info, see:

http://javaquirks.blogspot.com/2007/12/mysql-streaming-result-set.html

 

[bthale]

No - using IBM DB2

 

[Diancecht]

What do yo mean with "seem to find a way"? What did you try so far?

Cheers,
Dian