Hi, Try read :
http://docs.jboss.org/hibernate/stable/core/reference/en/html/mapping.html#mapping-declaration thx bb On Sun, May 2, 2010 at 8:03 PM, Kunal Raikar <kunal...@gmail.com> wrote: > Yeah I know that's the problem, Any Idea what to do in such cases. > > Thanks > > regards > Kunal > > On Sun, May 2, 2010 at 2:51 PM, Prabhat Jha <jha.mprab...@gmail.com>wrote: > >> I see these lines in your code: >> >> <join table="works_info"> >> <key column="pk_work_id"/> >> <property name="work_name" column="work_name" type="java.lang.String"/ >> > >> >> But the main class Tendor doesnt contain any thing which will join >> this table with Works_Info. >> >> Thanks, >> >> Prabhat >> >> >> Kunal Raikar 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<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 >> > > > > -- > 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
