Hi. In Section "14.15. Tips & Tricks":
You can count the number of query results without actually returning them: ( (Integer) session.iterate("select count(*) from ....").next() ).intValue() I don't find any session.iterate() method... Maybe it should read: ( (Integer) session.createQuery("select count(*) from ....").iterate().next() ).intValue() Regards -- -=-=-=-=-=-=-=-=-=-=-=-=- Andrés González. http://coyotevil.blogspot.com _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev