Hi,
There is a need for us to load all associated child objects for the given parent object id. Lets say I have Orders table and UnitDetails as child table. If i write query like "select * from Orders where orderNumber = 1045", can i get all associated child objects as well ? what are the things I shld do in xml file for this?

Regards
Nagesh G


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I assume that in your mapping file for Order contains a collection or sorts to hold the UnitDetails objects and assuming you are using Hibernate 3.

Using HQL:
session.createQuery("select o from Orders as o fetch join o.unitDetails").list()

Using CriteriaAPI:
session.createCriteria(Orders.class).setFetchMode("unitDetails", FetchMode.JOIN).list();

By default you should not enable join fetching in the mapping file for those cases where you want to lazy load the child collection.