Hi Kunal, You are welcome. You can also try out the netbean wizard for creating
the hibernate mapping files and pojo based on the existing database. It is a pretty cool tools. ( notes : you need to first create the corresponding hibernate config files and reverse engineering files for the respected db schema, all the wizards are existed in the netbeans ! ) rgds bb On Mon, May 3, 2010 at 8:09 PM, Kunal Raikar <kunal...@gmail.com> wrote: > Thank bb > Its really a useful link > > On Sun, May 2, 2010 at 7:34 PM, bambang passion < > bambang.teleinfocomproj...@gmail.com> wrote: > >> 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<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 For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en