Hi,
I have written one small hibernate application for testing the fetch join.
<set name="emps" lazy="false" fetch="join" order-by="deptno"
cascade="all">
<key column="DEPTNO" />
<one-to-many class="com.dcons.Emp" />
</set>
Normally if I use this , for parent one query and for childs n queries are excuting.
Even If I put the fetch=join also still (n+1) queries are executing.

SessionFactory sessionFactory = getHibernateTemplate()
.getSessionFactory();
Session session = sessionFactory.openSession();
resultList = session.createQuery("from Dept").list();
Above code I am using.

Please help me how to implement the fetch=join.
My output should be...execute the only 1 query or 2 queries one for parent and one for child.

Intersting is If I use Criteria or loadAll() methods only one query is executing.

Help me.............

Fetch settings as defined in the mapping file are normally not used by HQL queries (http://docs.jboss.org/hibernate/stable/ ... ing-custom). You'll need to specify in the query that you also want to fetch the associated entities in one go. Something like this:

Thanks for your reply.

is there any other way without writing the HQL left join fetch ??

Can this possible with the mappings?