File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
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-2015