Hibernate version: 2.1.8

Hi all

Does anyone know if it's possible to use the SELECT NEW() syntax in HQL to retrieve an object if the constructor takes a collection...

e.g. something like:

SELECT NEW MyCat(cat.age, cat.kittens)
FROM Cat cat
WHERE cat.age = 2

i.e. Cat has a number of properties including:
int age;
Set kittens;
String colour;
...etc.

with MyCat having the constructor:
void MyCat(int age, Set kittens) {
this.age = age;
this.kittens=kittens;
}


...I'm struggling with the HQL syntax, and the best I can get is a single kitten object (not a collection) being passed to the MyCat constructor.

Many thanks,
ive

Not sure why your doing this but you could pass the whole Cat into the constructor and assign the attributes that way.

Thanks for the reply, pksiv...

This Cat/MyCat obviously doesn't make any sense, but I need to know if the concept can work...

Basically (due to not wanting to break an existing system), I want to only fetch some of the attributes (mostly of associated objects (to Cat in this case)), without implementing proxies on any objects...

Is this a viable option? ... or am I on the wrong track!?

I built a simple test for this and tried several different query strings and it appears that in order to properly retrieve the collection, you have to do a join. And by doing a join, your results has more than one row per new MyCat(), each constructed with a different kitten. Seems like this functionality is