If I want to implement Pagination(search results spanning multiple pages like Goooooogle.." in my Web-tier for the search results, would hibernate provide any easy way to do this.

I saw setFirstResult() method in the documentation and was wondering if thiw was for pagination to return a subset of the queries?

How does this work in case of "lazy" initialization model where the entities are not created?

-anand

As you have found the query class has the setFirstResult and the Max partner. This allows you to create a paging dataset when you execute the query. How it talks to the database (the SQL generated) is dependent on the dialect. Not sure what you mean in relation to lazy objects. Its the same with Load or standard find etc you get the objects you have requested in the HQL query if any relationships are lazy then they will not be loaded. I suggest you just try it.