Hi,

I'm trying to map the result of a query to a value object. The query returns mainly aggregates and there is no object with the proper XML for it.

A solution would be to create a view in the database and then map it directly to the object (using the standard mapping files) but, since creating a view might not be allowed in our project, I'm looking for another way to do this.

Do you know how you can map the result of a query that returns agreggates to a bean object with just the properties for the columns returned ? The idea is to avoid using lists, which are error-prone, and use instead a formal value object.

Any comments would be really welcome.

Regards,

- Juancho

Use AliasToBeanTransformer to map result to a Bean Object. While creating the query, do create an alias which corresponds to Bean property.

Eg: You bean class name: xyz.java
Attributes in bean class : maxCount, maxResults

Criteria c = session.createCriteria(xyz.class,"xyz");
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("dbmaxCount", "maxCount");
projectionList.add(Projections.property("dbmaxResults", "maxResults");
c.setProjection(projectionList);
criteria.setResultTransformer(new AliasToBeanResultTransformer(xyz.class));
List l = c.list();

This will give you xyz object with the properties set.

Thanks,
Ram

That's exactly what I was looking for.

Thank you.