File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Controling the size of resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Controling the size of resultset" Watch "Controling the size of resultset" New topic

Controling the size of resultset

Yogender Butola

Joined: Jul 19, 2004
Posts: 12
I want to control the size of result set. For example my query fetches 1500 hundred records. and I want first 300 records in the resultset. After processing the firs 300 records, I want the next 300 records and so on. How can I do this. Please help.
Please help with some code snippets.


Courage is not having the strenth to go on
It's the going on without having the strength.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
i think you should do it by putting some logic in your code.

its sounds like paging. so, i suggest you to go for paging some mechanism. you can find many threads here discussing paging stuff. you will find those threads in jsp forum most probably.
I agree. Here's the link:
subject: Controling the size of resultset
It's not a secret anymore!