Hi,

Am using Hibernate 2.1, JDK 1.4.2, and running the ant task SchemaExportTask, get the following and the ddl is not being generated.

Buildfile: D:\eclipseProjs\Hibern8Xmpl\build\build_1.xml
db-schema:
[schemaexport] log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment).
[schemaexport] log4j:WARN Please initialize the log4j system properly.
BUILD FAILED: file:D:/eclipseProjs/Hibern8Xmpl/build/build_1.xml:99: Schema text failed: org.dom4j.DocumentException: Error on line 1 of document : Document root element is missing. Nested exception: Document root element is missing.
Total time: 931 milliseconds

Appreciate any leads,
Thanks

....the ant code used, reference to the previous post

<target name="db-schema">

<taskdef name="schemaexport"
classname="net.sf.hibernate.tool.hbm2ddl.SchemaExportTask"
classpathref="project.class.path"/>

<schemaexport
properties="${proj.bin}/hibernate.properties"
quiet="no"
text="no"
drop="no"
delimiter=";"
output="${proj.build.dir}/example_schema.sql">

<fileset dir="${proj.bin}">
<include name="*.hbm.xml"/>
<include name="*.class"/>
<include name="*/*.zip" />
<include name="*/*.properties" />
</fileset>

</schemaexport>
</target>

RTFM. You should only include the hbm.xml files in the fileset.

Thanks for the response,

Excluding
<include name="*.class"/>

from the fileset gives the following:

Buildfile: D:\eclipseProjs\Hibern8Xmpl\build\build_1.xml
db-schema:

[schemaexport] log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment).
[schemaexport] log4j:WARN Please initialize the log4j system properly.
BUILD FAILED: file:D:/eclipseProjs/Hibern8Xmpl/build/build_1.xml:99: Schema text failed: net.sf.hibernate.MappingException: persistent class [dbdemo.Address] not found
Total time: 1 second

I've checked that all the required libraries are in
classpathref="project.class.path", essentially the /hibernate/lib directory

and the log4j.properties and hibernate.properties files are in the same directory as *.class and *.hbm.cml

You should have the mapped classes in your classpath (the one that load the SchemaExport task I guess).

Thanks for all your responses, my problem was setting up the required classpath as was pointed out by 'emmanuel'. From another post it was gleaned that SchemaExportTask expects the persistent classes in a jar file.

The following seems to work :), would appreciate any comments for improvements

<!-- ================================================================== -->
<!-- Export Database Schema from mapping files -->
<!-- ================================================================== -->

<target name="setup_schemaExport_classpath">
<!-- persistent classes are expected to be in a *.jar file -->
<!-- with the proper package heirarchy -->
<echo message="-- creating persistentClasses.jar file --" />
<jar jarfile="${proj.build.dir}\persistentClasses.jar"
basedir="${proj.bin.dir}"
includes="**/*.class"/>
<echo message="" />

<!-- create the class path for the SchemaExportTask -->
<echo message="- creating schemaExportTask classpath -" />

<path id="schemaExport.class.path">
<!--path for the hibernate jar/-->
<pathelement path="${hibernate.jar}"/>
<!--path for the hibernate lib jars/-->
<fileset dir="${hibernate.lib}">
<include name="**.jar"/>
</fileset>
<!--path for the persistentClasses.jar/-->
<fileset dir="${proj.build.dir}">
<include name="**.jar" />
</fileset>
</path>
</target>

<target name="generate_db_schema" depends="setup_schemaExport_classpath">

<echo message="------- running db_schema --------" />
<taskdef name="schemaexport"
classname="net.sf.hibernate.tool.hbm2ddl.SchemaExportTask"
classpathref="schemaExport.class.path"/>

<schemaexport
properties="${proj.bin.pkg}/hibernate.properties"
quiet="no"
text="yes"
drop="no"
delimiter=";"
output="${proj.build.dir}/example_schema.sql">
<fileset dir="${proj.bin.pkg}">
<include name="**/*.hbm.xml"/>
</fileset>
</schemaexport>
</target>

The above does not export the schema to the database, to enable the export the following (higlighted) is required:

<target name="setup_schemaExport_classpath">
<!-- persistent classes are expected to be in a *.jar file -->
<!-- with the proper package heirarchy -->
<echo message="-- creating persistentClasses.jar file --" />
<jar jarfile="${proj.build.dir}\persistentClasses.jar"
basedir="${proj.bin.dir}"
includes="**/*.class"/>

<echo message="" />

<!-- create the class path for the SchemaExportTask -->
<echo message="- creating schemaExportTask classpath -" />

<path id="schemaExport.class.path">
<!--path for the hibernate jar/-->
<pathelement path="${hibern8.jar.file}"/>
<!--path for the hibernate lib jars/-->
<fileset dir="${hibern8.lib.dir}">
<include name="**.jar"/>
</fileset>
<!--path for the persistentClasses.jar/-->
<fileset dir="${proj.build.dir}">
<include name="**.jar" />
</fileset>
<!--path for the database jar/-->
<fileset dir="${db2.jars.dir}">
<include name="**/*.jar"/>
</fileset>
</path>
</target>

<target name="generate_db_schema" depends="setup_schemaExport_classpath">

<echo message="------- running db_schema --------" />
<taskdef name="schemaexport"
classname="net.sf.hibernate.tool.hbm2ddl.SchemaExportTask"
classpathref="schemaExport.class.path"/>

<schemaexport
properties="${bin.pkg.dir}/hibernate.properties"
quiet="no"
text="no"
drop="no"
delimiter=";"
output="${proj.build.dir}/example_schema.sql">
<fileset dir="${bin.pkg.dir}">
<include name="**/*.hbm.xml"/>
</fileset>

</schemaexport>