File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Regarding fetching the records based on a fetchsize limit Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding fetching the records based on a fetchsize limit" Watch "Regarding fetching the records based on a fetchsize limit" New topic
Author

Regarding fetching the records based on a fetchsize limit

Keerthi Kumar
Ranch Hand

Joined: Apr 20, 2009
Posts: 105
Hi All,

I have a requirement where I need to fetch the queries from the database first and then from those fetched queries, I need to select the records based on the limit size specified. i.e. if a select query returns 500 records and the limit size is 200, from that 500, I need to select the first 200 records. Hibernate has been used now.

Please help me to resolve this.


Cheers,
Keerthi Kumar N
 
Don't get me started about those stupid light bulbs.
 
subject: Regarding fetching the records based on a fetchsize limit
 
Similar Threads
Want clarification for some of the methods of Criteria class of org.hibernate
resultset
Inverse this where condition
inserting data in mysql in sorting order of date column
paging with mysql and java