Hibernate version:2.1.8

I've got what seems to be a common problem using Criteria. It doesn't support aggregation. I've read several forums which reference a count() method of Criteria that is available via a patch. What I've read indicates it is available in either 2.1.7 or 2.1.8, however I can't seem to find it. I only need this for basic constrained count functionality and would love to know how to access this method. Any help would be appreciated.

Thanks.
Bob

The documentation states that projections and aggregations are only available through HQL for version 2.1.x

It looks like criteria.count existed for a moment but that it has been removed from the API.

Read at the bottom (maybe that's the patch you were refering to)
http://opensource.atlassian.com/project ... wse/HB-474


If you upgrade to hibernate version 3.0, it does support aggregations through its criteria API.

If this is the case, you do that using criteria.setProjection(Projections.count("field"))

Good luck

That was one of the postings I had read. Looks like it was fleeting and I have to use HQL. Thanks for taking the time to respond.

Bob