Two Laptop Bag
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
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
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