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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Regarding fetching the records based on a fetchsize limit
 
Similar Threads
paging with mysql and java
inserting data in mysql in sorting order of date column
Inverse this where condition
Want clarification for some of the methods of Criteria class of org.hibernate
resultset