Le 30 mai 10 à 11:14, Kunal Raikar a écrit :

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.
I don't know a tool to do this, but you can probably write one shell script yourself based on a mysqldump of the tables with --xml option, since it gives the structure of the table at the beginning of the xml file.

Michèle Garoche


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
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
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
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

Reply via email to