A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Database data retrieval in many steps?
Joined: Apr 02, 2008
Aug 03, 2009 07:57:17
I want to retrieve result set from database, If the result set is huge then I want to retrieve some part of total result set and retrieve the remaining in next sequence of retrievals.
My question here is
In my first database hit ,I retrieve the first set of the result,
In the second database hit, How it can refer the same result?? And retrieve the remaining part ?
Joined: Apr 26, 2008
Aug 03, 2009 09:37:24
I think ResultSet fetchSize would be a good place to start.
author & internet detective
Joined: May 26, 2003
Aug 03, 2009 17:14:38
Try searching for "paging" in this forum.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
It is sorta covered in the
JavaRanch Style Guide
subject: Database data retrieval in many steps?
Performance issue if I do not retrieve the rest of result set
Does a servlet continue processing after I hit Stop?
SQL SELECT statement with strings?
How can i group certain columns in a ResultSet
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014