Hello,

Is there an easy way of counting records that where selected in a named query, before i get the results in a collection??

I want to count the number of records before I apply my paging, using
setFirstResult
setMaxResults



I know that I can do it with criteria, buy using
criteria.setProjection(Projections.rowCount());

thank you

I'd be interested to see a more "correct" solution, but i've implemented a little wrapper in my DAO that will run a



and then



You dont get the precompiled goodness from that, and you're running the query twice... but it works just fine for how I need to use it.

I don't know of a better way to do it from a Query object.

From hibernate documentation

You can count the number of query results without actually returning them:
( (Integer) session.iterate("select count(*) from ....").next() ).intValue()

You can find the size of a collection without initializing it:
( (Integer) session.iterate("select count(*) from ....").next() ).intValue();

/Ashwani

Is this example from the documentation a bit out of date? I don't see any iterate() method for a org.hibernate.Session for Hibernate3. There seems to be a deprecated method for Hibernate2 with the org.hibernate.classic.Session.

So for Hibernate3, I think the solution (and documentation) should read:

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

Unless I'm mistaken,



does the same thing!

yea, I also noticed this. The documentation does not seem to be updated as per hibernate 3.0