Problems using hbm2ddl. Can't find a solution on the net

alzamabar · **Posted:** Wed Aug 03, 2005 10:00 am

Hi, I'm trying to run hbm2ddl to have the sql scripts to generate my tables off the persistence classes generated automatically. I'm using an Ant task to generate the sql script. The hbm2ddl runs but I get two types of errors:

1) If I don't include the class files into the <fileset> for the hbm2ddl task, I get the following exception:

2) If I include the class files in the <fileset> with the following:

Code:

 <fileset dir="${maven.build.dir}/classes/org/je  
      <include name="**/*.hbm.xml" />
      <include name="**/*.class" />
 </fileset>      

Then I obtain the following exception:

Hibernate version: 2.1

Name and version of the database you are using: MySQL 4.1.7-nt

I'm running on Windows XP SP2 with all the .jar files coming with Hibernate 2.1 in the classpath.

I looked everywhere on the net, but couldn't find a reason why I should get the above error.

This is the content of one of the files (for the Category class):

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping
>
    <class
        name="org.jemos.hbm.vo.Category"
        table="CATEGORIES"
    >

        <id
            name="id"
            type="long"
        >
                <column
                    name="ID" 
                />
            <generator class="increment">
              <!--  
                  To add non XDoclet generator parameters, create a file named 
                  hibernate-generator-params-Category.xml 
                  containing the additional parameters and place it in your merge dir. 
              --> 
            </generator>
        </id>

        <set
            name="childCategories"
            lazy="true"
            inverse="true"
            cascade="delete"
            sort="unsorted"
        >

            <key
                column="PARENT_ID"
            >
            </key>

            <many-to-many
                class="org.jemos.hbm.vo.Category"
                column="ID"
                outer-join="auto"
             />

        </set>

        <set
            name="items"
            lazy="true"
            inverse="true"
            cascade="none"
            sort="unsorted"
        >

            <key
                column="CATEGORY_ID"
            >
            </key>

            <many-to-many
                class="org.jemos.hbm.vo.Item"
                outer-join="auto"
             />

        </set>

        <property
            name="name"
            type="java.lang.String"
            update="true"
            insert="true"
        >
            <column
                name="NAME" 
                length="64"
            />
        </property>

        <many-to-one
            name="parentCategory"
            class="org.jemos.hbm.vo.Category"
            cascade="none"
            outer-join="auto"
            update="true"
            insert="true"
            column="ID"
        />

        <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-Category.xml
            containing the additional properties and place it in your merge dir.
        -->

    </class>

</hibernate-mapping>

There is no funny character, nor spaces or blank lines before the beginning of the document.

I'd appreciate some help, also becuase I'm trying to 'introduce' Hibernate as persistence mechanism in the company where I work in replacement of entity beans. I already got the 'DB-to-Java' feature working, now I'd need to 'Java-to-DB' feature to work as well, otherwise I doubt that my colleagues would approve such change.

Thanks for any help,

max · **Posted:** Wed Aug 03, 2005 10:20 am

the fileset is for mapping files - not class files.

class files goes into your classpath.

alzamabar · **Posted:** Wed Aug 03, 2005 11:46 am

Finally! You saved me :) I've been working three days on this and I couldn't find out why I was having that error. So it was related to the class file being included in the fileset. I now included the jar containing the class files into the classpath and it works fine.

I cannot tell you how grateful I am.

Thank you very much.

fruti · **Joined:** Sat Sep 17, 2005 9:58 am **Posts:** 1

I was playing with the same problem for a prety long..I am an ant newbie either..I did exacly what you said and it works finally!

Here is my build.xml

<project name="hibernate-tutorial" default="schemaexport">
<property name="proj.name" value="Message"/>
<property name="library.dir" value="D:/dev/lib" />
<property name="hibernate.cfg.file" value="${basedir}/hibernate.cfg.xml"/>
<property name="source.dir" value="${basedir}/src" />
<property name="build.dir" value="${basedir}/build" />
<property name="classes.dir" value="${build.dir}/classes"/>

<path id="libraries">
<fileset dir="${library.dir}">
<include name="**/*.jar" />
</fileset>
<fileset dir="${build.dir}">
<include name="**/*.jar"/>
</fileset>
</path>

<target name="clean">
<delete includeemptydirs="true">
<fileset dir="${build.dir}" includes="**/*"/>
</delete>
<mkdir dir="${build.dir}" />
<mkdir dir="${classes.dir}"/>
</target>

<target name="compile" depends="clean, copy-resources">
<javac srcdir="${source.dir}" destdir="${classes.dir}" classpathref="libraries" />
</target>

<target name="copy-resources">
<copy todir="${build.dir}">
<fileset dir="${basedir}">
<include name="*.xml"/>
<include name="*.dtd"/>
<exclude name="build.xml"/>
</fileset>
</copy>
</target>

<target name="classes.package" depends="compile">
<zip destfile="${build.dir}/${proj.name}.jar">
<fileset dir="${classes.dir}">
<include name="**/*.class"/>
</fileset>
</zip>
</target>

<target name="schemaexport" depends="classes.package">
<taskdef name="schemaexport"
classname="org.hibernate.tool.hbm2ddl.SchemaExportTask"
classpathref="libraries" />
<schemaexport
config="${hibernate.cfg.file}"
quiet="no" text="yes" drop="no"
delimiter=";"
output="${proj.name}.sql"
>
</schemaexport>
</target>
</project>

Notice classes.package target !

max · **Posted:** Sat Sep 17, 2005 10:42 am

it is not required that you zip your files into a .jar/.zip - just add the classes directory to the classpath.

ramin_farhanian · **Joined:** Thu Nov 24, 2005 2:19 am **Posts:** 10

deleted

max · **Posted:** Tue Jan 03, 2006 10:25 am

We don't have any knowledge about any hibernate plugin to Maven.

/max