[hibernate-dev] Pagination: An approach for retrieving results / page count in single query

[Already posted to hibernate-users, but no responses.] Hi, I have pagination working, but am doing so with two queries; one to get the results page and a second one to get the total count. I'd like to do this in a single query: Is it possible to build a criteria, so my results set includes columns for each of the properties on my bean, plus an additional column which has the row count (downside: this is duplicated for each row in the page). I figured I could build a projection like this to return all the beans properties plus the row count. private Projection getProjectionsForBeanAndRowCount() { ClassMetadata classMetadata = session().getSessionFactory().getClassMetadata(modelClass); ProjectionList projectionList = Projections.projectionList(); projectionList.add(Projections.rowCount()); String[] propertyNames = classMetadata.getPropertyNames(); for (String propertyName : propertyNames) { projectionList.add(Projections.property(propertyName)); } return projectionList; } ..and then write a ResultsTransformer to process these results, instantiating a class like:- public class PageResult { Object bean; int rowCount; } ..but it seems that by the time ResultsTransformer is called, you already have the bean instantiated. Is there a way I can jump in at a slightly lower level, like at a single row of the result set, the level where the results bean's are built? Any info much appreciated. All the best, Jon