Hello all,

I need some advice on how to map a parent/child relation where the children are stored in a collection(list) in the parent. The children are a very large number so loading them all is quite undesirable and totally unnecessary. Here is a basic definition of the participants:


I tried making the collection of children "lazy" but as soon as I try to access the 100-th child (they are much much more), the whole collection is fetched into memory and all the children are instantiated.

Any ideas are welcome!

Best regards,

Petar

One option is to do without the collection and use HQL or criteria queries instead to only fetch what is needed.

Hello Sergey,

Sorry, I somehow did not get an e-mail about your post!



I was wondering is there any technical hinderance in providing the feature I am seeking ? I looked at the IList implementation for a list collection and at any attempt to access anything in the collection, the whole collection was being fetched without any attempt to be smart about it. And I am pretty sure you guys are a smart bunch :)
May be you just have too many things to do ...

Best regards,

Petar

It is implemented in Hibernate 3, so eventually it will get ported over, but right now there are other things to do.