Hibernate version:
3.1

i want to select the "root entity", some properties and some projection (avg/min/max) values trough the Criteria API (query is constructed at runtime so Criteria would be more convenient).

i can do folowing:



and would get a List of Arrays where index 0 is a Person.class and index 1 is a Double.

but now i need to get the Car, the Owner plus the max of the price. can i do this with the Criteria API ? or do i need to use HQL (i think select c, o, max(c.price) from Car c join fetch c.owner as o..... should do the trick)


thanks for your help

You now get an array with owner and max price???
How would like this to be returned?

maybe you could change your code to something like :



Than wyou would get an array with
index 0 : Car index 1 Person, index 2 Double

Good luck!

no, unfortunately this wont work since Proectsions.property is looking for mapped properties and not alias -> i will get some thing like "could not resolve property car in class Car".

i tried the HQL version (select c, max(c.price) from Car c) and this does not work because of some troubles in the group by clause (not in agregate function or groub by).


thanks for your help


pascal