HI, I suggesting you map them one by one ( i.e just one join-table per class )
Then you can query them using available hibenate queries Thats my thought rgds bb On Tue, Apr 27, 2010 at 7:39 PM, Kunal Raikar <kunal...@gmail.com> wrote: > 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<java-ee-j2ee-programming-with-passion%2bunsubscr...@googlegroups.com> > For more options, visit this group at > > http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en -- 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
