http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html
http://www.javalobby.org/articles/hibernate-query-101/ hope this helps... thanks, jd On Sun, May 30, 2010 at 2:44 PM, Kunal Raikar <kunal...@gmail.com> wrote: > Hi Ali > I don't want to include SQL query in hbm.xml file but I want a tool which > convert sql query into xml mapping so that I can use it in hbm.xml file. > > 2010/5/30 Ali Ekber Çelik <aekberce...@gmail.com> > >> Hi Kunal, >> >> <query name="getYourSqlName"> >> <![CDATA[ >> SELECT item >> FROM student item,school template >> WHERE template.tmplName = :templateCode >> AND template.serno = item.tmplSerno >> AND item.itemValue = :templateValue >> ]]> >> </query> >> >> >> simply you can use this codein your hbm.xml file.And dont forget to call >> this sql code in your java class with sqlname "getYourSqlName". >> >> >> >> 2010/5/30 Kunal Raikar <kunal...@gmail.com> >> >> >>> Hi Ben >>> Can you please explain step by step sql to hbm converting process after >>> installing Hibernate tool in eclipse? >>> >>> regards >>> Kunal >>> >>> On Sun, May 30, 2010 at 11:43 AM, Benedict Aluan <mclave...@gmail.com>wrote: >>> >>>> Hello, >>>> >>>> You can use Eclipse and install Hibernate Tools plugin. >>>> >>>> Regards >>>> Ben >>>> >>>> >>>> On Sat, May 29, 2010 at 10:02 PM, Kunal Raikar <kunal...@gmail.com>wrote: >>>> >>>>> I am new to Hibernate. I want to know how to convert SQL query into >>>>> hibernate mapping so that I can make use of hbm.xml file instead making >>>>> use >>>>> of manual sql query. >>>>> >>>>> Is there any converter through which we directly convert sql query into >>>>> hbm.xml mapping >>>>> >>>>> -- >>>>> 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 >>>> >>>> >>>> >>>> >>>> -- >>>> Good design is more important than the underlying technology. >>>> >>> >>> >>> >>> -- >>> 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 >>> >> >> >> >> -- >> >> >> Ali Ekber ÇELİK >> +905556129172 >> > > > > -- > 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