<class name="Order" table="Order" >
<id name="ORDNUM" column="ORDNUM" >
<generator class="native">
</generator>
</id>
<property name="desc" column="desc" />
<many-to-one name="customer" column="customer_id"
outer-join="true" not-null="true" />
<bag name="items" lazy="true" inverse="true"
cascade="save- update">
<key column="item_Ord-no"/>
<one-to-many class="Item"/>
</bag>
</class>




HQL-
createQuery(
"from Order order "
+ " where order.ordnum = :no "
+ " order by order.ordnum desc")



Question-
Why does this not automatically retrieve customer without issuing an additional query? This needs 2 queries
If I use CriteriaAPI it works fine and need 1 query

thanks

I figured out the issue
I had to give


From Order inner join fetch customer
...

thanks everyone

I figured out the issue
I had to give


From Order inner join fetch customer
...

thanks everyone