I have the following table to store structured free-form data:



The table is mapped to a hibernate class OrderData with fields:

List<OrderData> children;
OrderData parent;

using lazy="false" and cascade="all-delete-orphan". This works without problems but causes hibernate to send a lot of queries to validate that every children-List is initialized.

Is there a way to read the complete tree and initialize the parent/children properties using a simple query like "from OrderData where group.id = 1" (perhaps using the internal methods of the hibernate PersistentCollection classes) and keeping the cascade functionality?

As far as I understand if your class and mapping define child-parent relationship (one-to-many in your case) it will be loaded automatically.

If you use lazy initialization then loading of children may be delayed until you use them. In this case you should have a valid session associated with the parent.

Hi xflower, thanks for your reply.

Lazy loading does not help here, as the full tree is traversed in detached state afterwards, so I need everything loaded anyways.

This is the snippet from my OrderData.hbm.xml:



[/code]

Not sure if this what you are asking , anyways

You can use fetch in your query

from OrderData o where o.group.id = 1 left join fetch o.children........





----------------
Dont forget to rate

Hi scarface,

yes, thats correct, but in this particular case there are already multiple (7) joins and fetch joins with other directly and indirectly linked tables in my query, and using left join fetch would end in 7 additional left joins for every layer of the tree.

It would greatly reduce the database load and traffic if the above can be realized.