wood burning stoves
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 REST with Spring (video course) this week in the Spring 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: http://aspose.com/file-tools
subject: Controling the size of resultset
It's not a secret anymore!