Hibernate version: 3.0.5

I've written a generic method to perform a count on a Criteria object using the Projections API.

However, although it does return the correct count, when using the criteria again to perform the actual query to get the data, it causes the wrong entity to be returned.

Please can any one advise on how to perform a count on a criteria using projections, without adversely affecting the criteria's ability to perform the normal non projection query.

Here's the method as it stands:

public final int count(Criteria criteria) {
int count = 0;

if(criteria!=null) {
count = (Integer) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

// remove the projection so the criteria can be used normally again
criteria.setProjection(null);

return count;
}


Thanks.

Do you need to set the projection to null? Since setProjection() (and other Criteria operations) return a Criteria object, I assumed they weren't modifying the original Criteria object.

I looked in CriteriaImpl.java and I was way off. I did notice that setResultTransformer(PROJECTION); is called an never reverted. You might try:

[/code]