Hi, Remember though that HQL is affecting on the entity or persistence object
not the DB object. bb On Tue, Jun 1, 2010 at 10:07 AM, Shiv Shankar <mca.shivshan...@gmail.com>wrote: > Very useful Link > > > On 5/31/2010 8:18 PM, jitesh dundas wrote: > > 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 > > > > -- > With Regards, > Shiv Shankar > > -- > 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