Is there any way to do following
get and fetch object with it's related collections by one jdbc call
using syntax like this


SELECT new Class1(c.prop1,c.prop2,c.collect1) from Class1 c


where c.collect1 some collection (List?,Set? or ...)
How Class1 constructor must looks like?
What type of collections supperted?

HSQL expression may be quite different, but the main idea to
get object with related collections using (select new ...(...)) syntax