Result from Projections on Criteria queries

momania · **Posted:** Tue Nov 22, 2005 5:23 pm

Can someone explain me why with Projections added to a Criteria query, you get a Object[] as a result in de List result ?

I was using the Projections this afternoon and the documentation on how to implement them are very complete, but they do not mention the processing of the result.

After some debugging I found out that it returned a Object[] in the List.

I'd suspected just a regular List to iterate, or even better: a Map .. ie:

Code:

List results = session.createCriteria(Cat.class)
    .setProjection( Projections.projectionList()
        .add( Projections.avg("weight").as(avgWeight" )
        .add( Projections.max("weight").as(maxWeight" )
    )
    .list();
Map projection = (Map)results.get(0);
BigDecimal avgWeight = (BigDecimal)projection.get("avgWeight");
// etc..

momania · **Posted:** Tue Nov 29, 2005 4:11 am

*kick*

Does anyone have any opinion about this? :)

ramnath · **Posted:** Wed Nov 30, 2005 5:00 am

your query is Scalar Query (with Average, Max, SUM Aggregate function), return array (Object[] ). For more info look into the below link
http://www.hibernate.org/hib_docs/refer ... larqueries

momania · **Posted:** Wed Nov 30, 2005 11:05 am

true, but that only describes the HQL and not the Criteria.

I'm just curious why there isn't some sort of method us can use on aggregated Criteria query's to get a map with the result.