Domain Object:
class Project {
private int numberOfWorkers;
private String name;
}
class Worker {
private Project project;
}

The usual mapping is done in hbm.xml's. I am running the following query:
SELECT project, COUNT(worker) FROM Worker worker GROUP BY worker.project;

I want to assign COUNT(worker) to Project.numberOfWorkers through mapping, the query itself or some other mechanism preferably not looping through the results.

How can this be done in Hibernate? Thanks.