Hi David & miguel ,
I am also facing same problem i tried using setFirstResult() & setMaxResult as well.But my requirement is slightely different.
If 100 records are fetched,25 records per page i want to show it like
<prev 1 2 3 4 next> ,i can not determine how many page numbers i sholuld show if i used above mentioned two methods as they limit result size itself.
What should i do to get size of result according to which i will show pageNumbers & on click of each number i will fetch & show query result of that page by using setFirstResult() & setMaxResults().
i am using struts-hibernate3,& criteria in hibernate.
Any Help!!! :roll: