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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Regarding fetching the records based on a fetchsize limit