How criteria working for Criteria.setMaxResults(10)

[Rajan Nath]

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.

Thanks
Raj

[Cameron Wallace McKenzie]

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

<hibernate-configuration>
<session-factory>
 
<!-- stuff left out-->
 
<!-- this will show us all sql statements -->
<property name="hibernate.show_sql">
true
</property>
 
</session-factory>
</hibernate-configuration>

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

   
log4j.logger.org.hibernate.type=debug
 

Let us know what you see!

-Cameron McKenzie

[Rajan Nath]

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