I am currently setting up Ant build script to generate database schema from Hibernate. The ant task I use is <hibernatetool />. The database is HSQLDB standalone version integrated with my standalone application.

During the build process I want to create database with schema in a subdirectory of my application directory, which is specified through an Ant property. However, hibernatetool takes db location from hibernate.cfg.xml file (hibernate.connection.url property). Are there anyway that I can specify the the connection url through Ant property in my build script?

Hi Ejel,

I'm using hibernatetool as well. Here's a slice of my build file:

<target name="hibernate-base" depends="remove">
<antcall target="warning">
<param name="taskname" value="${taskname}"/>
</antcall>

<xdoclet2>
<!-- defines the files handled by xdoclet2 -->
<fileset dir="${src.dir}">
<include name="**/*.java"/>
</fileset>

<!-- defines the processing files to build hibernate .hbm.xml mapping files -->
<component
classname="org.xdoclet.plugin.hibernate.HibernateMappingPlugin"
destdir="${basedir}/src"
version="${hibernate.version}"
encoding="${hibernate.encoding}"/>

<!-- defines the processing to create a hibernate .cfg.xml file -->
<component
destdir="${src.dir}"
classname="org.xdoclet.plugin.hibernate.HibernateConfigPlugin"
jdbcdriver="${jdbc.driver}"
jdbcpassword="${jdbc.password}"
jdbcurl="${jdbc.url}"
jdbcusername="${jdbc.username}"
dialect="${hibernate.dialect}"
cacheprovider="${hibernate.cache.provider_class}"
cacheusequerycache="${hibernate.cache.use_query_cache}"
jdbcpoolsize="${hibernate.connection.pool_size}"
jdbcbatchsize="${hibernate.jdbc.batch_size}"
jdbcisolation="${hibernate.connection.isolation}"
showsql="${hibernate.show_sql}"
version="${hibernate.version}"
encoding="${hibernate.encoding}"/>

</xdoclet2>

<hibernatetool destdir="${webinf.dir}/sql">
<configuration configurationfile="${src.dir}/hibernate.cfg.xml"/>
<hbm2ddl export="false" update="false" drop="true" create="true" delimiter=";" outputfilename="${ddl.file}" format="true"/>
</hibernatetool>
</target>

...and you can include all of the properties mentioned with a tag like this:
<property file="${basedir}/hibernate.properties"/>