This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes How criteria working for Criteria.setMaxResults(10) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How criteria working for Criteria.setMaxResults(10)" Watch "How criteria working for Criteria.setMaxResults(10)" New topic

How criteria working for Criteria.setMaxResults(10)

Rajan Nath

Joined: Nov 27, 2007
Posts: 22
I am using criteria, for pagination. The application get slow as for every page it brings all the records although (through display tag) only 10 records displayed.
when I used Criteria.setMaxResults(10), it brings only 10 records, I want to know is Hibernated firing query to bring only 10 records from database.
I am not able to see in any thing related with that in generated HQL.

Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968

If you add the following to your hibernate.cfg.xml file, you should be able to see the sql being generated:

This will also provide more debug information and variables being used for the insertion in your code. This is a log4j setting for Hibernate:

Let us know what you see!

-Cameron McKenzie
Rajan Nath

Joined: Nov 27, 2007
Posts: 22
Thanks Cameron,
I am using the show_sql . The query generated I am able to find out but the query is not contains any thing due to which only 10 records fetched.
Can any body send how exactly the sample query will generate by using setMaxResult
Have you checked out Aspose?
subject: How criteria working for Criteria.setMaxResults(10)
jQuery in Action, 3rd edition