Ant + HSQLDB - Seperate Process

[Gregg Bolinger]

I am starting HSQLDB via ant using the following:

<target name="hsqldb.start" description="Starts local HSQLDB server" >
   <echo message="Starting HSQLDB" />
   <java fork="true" dir="${basedir}" classname="org.hsqldb.Server" failon-error="true">
      <classpath>
<path refid="library.path" />
      </classpath>
      <arg value="-database.0" />
      <arg value="file:${db.dir}/${db.name}" />
      <arg value="-dbname.0" />
      <arg value="${db.name}" />
   </java>
</target>

This works however if I start it in IDEA the process just sits so when writing some tasks where I need the DB to start, I do some work, and then I shut it down, the process halts after HSQLDB starts. The rest of the dependent tasks never execute until I shut HSQLDB down.

Notice I am already using fork = "true". I'm wondering if there is somethinge else I can do so that the process doesn't hold up execution of all the other tasks.

Maybe this isn't an Ant problem?

[Jaikiran Pai]

The "fork" will just create a new JVM for the DB server. I think you will also have to set the "spawn" to true so that it will create a new process.

[Gregg Bolinger]

Originally posted by Jaikiran Pai:
The "fork" will just create a new JVM for the DB server. I think you will also have to set the "spawn" to true so that it will create a new process.

Spawn won't work because of the child elements of the java task. Already tried it.

Thanks.

[Martijn Verburg]

Hi Gregg,

I'm curious, have you tried running this outside of IDEA? I've been tried up by Eclipse's handling of ANT forks in the past...

[Gregg Bolinger]

Originally posted by Martijn Verburg:
Hi Gregg,

I'm curious, have you tried running this outside of IDEA? I've been tried up by Eclipse's handling of ANT forks in the past...

Yes. It still blocks the ant process from completing.

[Fadjer One]

Hi men,

This a task to create, start , launch, configure and stop an HSQLDB database. I hope this help.

   <project name="SOFTX" default="buildNewDB" basedir=".">

    <description>
        Créer une nouvelle de données pour SOFTX 5
    </description>

	<property file="build_bdd.properties"/>

    <path id="classpath">
        <pathelement path ="${connector.dir}"/>
        <pathelement path ="${logic.engine.bin.dir}"/>
        <pathelement path ="${logic.engine.config.dir}"/>
        <pathelement path ="${logic.engine.hibernate.dir}"/>
        <fileset dir="${logic.engine.lib.dir}" includes="*.jar"/>
    </path>

    <target name="cleanDataDir">
    	  <echo message="Cleaning 'data' directory..." />
    	  <delete>
    	  	<fileset dir="${basedir}/data" includes="*"/>
    	  </delete>
    </target>
    <target name="startDB">
    	<echo message="Starting Data Base..." />
        <java fork="true"  spawn="true" classname="org.hsqldb.Server" classpathref="classpath">
            <arg  line="-database.0 file:data/SOFTX5_bdd -dbname.0 SOFTX5_bdd"/>
        </java>
    </target>

    <target name="generateSOFTXSQL">
    	<echo message="Generating SOFTX SQL..." />
        <taskdef name="schemaexport"
            classname="org.hibernate.tool.hbm2ddl.SchemaExportTask"
            classpathref="classpath"/>
        <schemaexport
            haltonerror="yes"
            config="${logic.engine.hibernateconfig.file}"
            quiet="yes"
            text="yes"
            drop="no"
            create="yes"
            delimiter=";"
            output="${sql.dir}/bdd_script.sql">
        </schemaexport>
    </target>

   <target name="configDB">
        <echo message="Config new Data Base..." />
        <sql
            classpathref="classpath"
            driver="org.hsqldb.jdbcDriver"
            url="jdbc:hsqldb:hsql://localhost/SOFTX5_bdd;ifexists=true"
            userid="sa"
            password="">
            <transaction  src="${sql.dir}/configBdd.sql"/>
        </sql>
    </target>

    <target name="executeSQL">
    	<echo message="Execute SQL on new Data Base..." />
        <sql
        	autocommit="true"
        	print="true"
            classpathref="classpath"
            driver="org.hsqldb.jdbcDriver"
            url="jdbc:hsqldb:hsql://localhost/SOFTX5_bdd;ifexists=true"
            userid="SOFTX5_user"
            password="SOFTX5_user">
            <transaction  src="${sql.dir}/bdd_script.sql"/>
            <transaction  src="${sql.dir}/dropUnusedConstraints.sql"/>
            <transaction  src="${logic.engine.SOFTX.config.sql}"/>
        	<transaction>SHUTDOWN</transaction>
        </sql>
    	<echo message="SQL Executed on data base..." />
    </target>


	<target name="buildNewDB" depends="cleanDataDir, startDB, generateSOFTXSQL, configDB, executeSQL" description="Build new SOFTX 5 DB" />

</project>