Dear Friends,
I have 2 pojos and its mapping files as follows:
public class OutsourcedProduct
{
private Long id;
private Vendor toBeRepairedBy;
private Set outsourcedProductReceiptList = new HashSet();
......
......
getters and setters
}
public class OutsourcedProductReceipt
{
private Long id;
private OutsourcedProduct parentId;
......
......
getters and setters
}
<hibernate-mapping>
<class name="my.app.OutsourcedProduct" table="outsourced_product">
<id name="id" column="id">
<generator class="native" />
</id>
<many-to-one name="toBeRepairedBy" class="my.app.Vendor" column="toBeRepairedBy" not-null="true" />
<many-to-one name="parentId" class="my.app.ServiceEntry" column="parentId" not-null="true" />
<set name="outsourcedProductReceiptList" inverse="true" lazy="true" table="outsourced_product_receipt">
<key column="parentId" not-null="true" />
<one-to-many class="my.app.OutsourcedProductReceipt" />
</set>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="my.app.OutsourcedProductReceipt" table="outsourced_product_receipt">
<id name="id" column="id">
<generator class="native" />
</id>
<many-to-one name="parentId" class="my.app.OutsourcedProduct" column="parentId" not-null="true" />
</class>
</hibernate-mapping>
I want to access the vendor name of 'OutsourcedProduct' from 'OutsourcedProductReceipt'
outsourcedProductReceiptEntry.getParentId().getToBeRepairedBy().getVendorName()
What changes is required in the following query or in pojos and mpping files to acces the vendor name of
OutsourcedProduct?
query = _sessionFactory.getCurrentSession().createQuery("from
OutsourcedProduct inner join fetch outsourcedProduct.parentId
inner join fetch utsourcedProduct.toBeRepairedBy
where outsourcedProduct.parentId =
arentId order by
outsourcedProduct.id");
I am a newbie, any help regarding this is greatly appreciated. I am using hibernate 3.x
Thank you.
Sudheer