Select a collection in HQL

rexmadden · **Joined:** Sat Aug 30, 2003 1:05 pm **Posts:** 2

Hi,

After struggling with this for about an hour, I figure I'd ask if this was even possible in HQL. If I have a Person object with some simple properties (firstName, lastName) as well as a list (children) of Child objects. Is it possible to do a SELECT that would pull back the Child list as one of the array members. So:

SELECT person.firstName, person.children from Person;

In the result object[1] would then be a List, instead of individual Child objects.

gavin · **Posted:** Wed Nov 05, 2003 3:37 am

No, it is not possible. Would be very difficult to implement, too