Hi to all,

Is there a way to make hibernate return rows from a query within a given row boudary (for example row 1-5), so that paging can be made simple? It should work database-independent too..

Thanks already.

Hi,

you can use
i) query.setMaxResults(n) ;
ii) query.setFirstResult(m) ;

You can have a look at scrollableResultSets.
http://www.hibernate.org/hib_docs/v3/re ... pagination
----------------------------------------------------
Rate the reply if you find it helpful