posted 17 years ago
try creating a constructor parametrised constructor of cats
like
cats(birthdate,id,color,sex,weight,cattype){
...
...
}
and then firing HQL query like
select new *.*.*.cats(cats.birthdate,
cats.id,
etc,
(select type from cattype where cattypeid in cats.id) as cattype
)
from cats
I am using this type of queries in my application and they works...
however you might face problem as these objects are not properly associated and cached in session....