S
shaji
Hi:
Hibernate supports the pagination in the following way.
Query q = sess.createQuery("from DomesticCat cat");
q.setFirstResult(20);
q.setMaxResults(10);
List cats = q.list();
Assume there are more than 50 records in db for the Query q. Hibernate
can return
the records from 20 to 30 in the above fashion.
Is there any trick to get the total number of records satisfying query
q?
Or should I use another query like "count(*) from DomesticCat cat"
seperately?
I need to show that "records 20-30 of total 56 records"
Thanks
-With best regards,
Shaji.
Hibernate supports the pagination in the following way.
Query q = sess.createQuery("from DomesticCat cat");
q.setFirstResult(20);
q.setMaxResults(10);
List cats = q.list();
Assume there are more than 50 records in db for the Query q. Hibernate
can return
the records from 20 to 30 in the above fashion.
Is there any trick to get the total number of records satisfying query
q?
Or should I use another query like "count(*) from DomesticCat cat"
seperately?
I need to show that "records 20-30 of total 56 records"
Thanks
-With best regards,
Shaji.