How can we get the full resultset size when paging?

murrumbeena · **Posted:** Sun Apr 04, 2004 12:38 pm

as title.
when we use query.setFirstResult(n),it will cut down the part of result set.so how can we get the total result size when paging using only one hql?

thanks all

emmanuel · **Posted:** Mon Apr 05, 2004 7:50 am

You can't since Hibernate use JDBC APIs to reduce resultset size.
You can count the number of query results without actually returning them:

Code:

( (Integer) session.iterate("select count(*) from ....").next() ).intValue()