Both the entity and scalar values in one Criteria Query

mehow · **Joined:** Sat Apr 07, 2007 12:08 pm **Posts:** 6

How do I use Criteria API to get both the root entity and some scalar values in one query? It seems that as soon as setProjection() is used, the root entity object is no longer retrieved (and there doesn't seem to be any Projection to fix that).

Example:

Code:

select cat, sum(kitten.weight) from Cat cat 
join cat.kittens kitten
group by cat

How do I make such a query using Criteria API? Listing all cat's properties doesn't seem like an elegant solution and it won't create a Cat object for me.

jarppe · **Joined:** Fri Oct 05, 2007 3:27 am **Posts:** 4

It seems that it is impossible...

jarppe · **Joined:** Fri Oct 05, 2007 3:27 am **Posts:** 4

It seems that it is impossible...