I am using hibernate. In that I want to fetch data from 3 different tables for that my hbm.xml file look like this:-
<class name="com.netechinc.forms.TenderForm.TenderAwardDetailsSearchForm" table="TENDER"> <id name="pk_tender_id"> </id> <property name="tender_no" column="tender_no" type="java.lang.String"/> <property name="tender_date" column="createdate" type="java.lang.String"/> <join table="tender_details"> <key column="Tender_Id"/> <property name="work_no" column="work_no" type="java.lang.String"/> </join> </class> Here I am fetching data from table TENDER and TENDER_DETAILS. its working fine but when I use following code :- <class name="com.netechinc.forms.TenderForm.TenderAwardDetailsSearchForm" table="TENDER"> <id name="pk_tender_id"> </id> <property name="tender_no" column="tender_no" type="java.lang.String"/> <property name="tender_date" column="createdate" type="java.lang.String"/> <join table="tender_details"> <key column="Tender_Id"/> <property name="work_no" column="work_no" type="java.lang.String"/> </join> <join table="works_info"> <key column="pk_work_id"/> <property name="work_name" column="work_name" type="java.lang.String"/> </join> </class> to fetch the data from 3 table it does not give me any results. Plese help me -- Warm regards Kunal -- You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en