hbm2dll: no schema export to hsql database

thilo · **Joined:** Thu Jul 27, 2006 3:44 am **Posts:** 4

hsql: 1.8.0.4
hibernate: 3.1.3
hibernate-tools: 3.2.0beta6a

Hi to all,
I've got an ant task to export my database schema directly to the database:

Code:

<taskdef name="hibernatetool" classname="org.hibernate.tool.ant.HibernateToolTask" classpathref="hibernatetoolpath" />
<target name="db.schematodatabase" 
   <hibernatetool destdir="${dir.database.dll}">
      <configuration propertyfile="${dir.configuration}/hibernate.properties">
         <fileset dir="${dir.src}">
            <include name="*.hbm.xml"/>
         </fileset>
      </configuration>
      <hbm2ddl export="true" drop="true" />
   </hibernatetool>
</target>

If I'm using hsql, the schema won't export to the database, the log doesn't show any error messages. But if I'm using postgres, it works as expected!

Is it me, or is it a bug ?

Any hints are welcome!
Cheers,
Thilo

max · **Posted:** Thu Jul 27, 2006 5:31 am

did you put a log4j.properties/xml into the claspath to actually se the logging ?

thilo · **Joined:** Thu Jul 27, 2006 3:44 am **Posts:** 4

Max, thank you for your quick replay?

yep, I've got the full log. The strange thing is, if the hsqldb is empty, I get the nomral info log statements about table creation etc. But nothing is happend to my database. But if my database has the required schema (I've imported it by hand), I got correct error statements like :

Code:

[hibernatetool] Error #1: java.sql.SQLException: Table already exists: SITE in statement [create table SITE]
[hibernatetool] java.sql.SQLException: Table already exists: SITE in statement [create table SITE]
[hibernatetool]         at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[hibernatetool]         at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
[hibernatetool]         at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
[hibernatetool]         at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:306)
[hibernatetool]         at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:265)
[hibernatetool]         at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:188)
[hibernatetool]         at org.hibernate.tool.ant.Hbm2DDLExporterTask.execute(Hbm2DDLExporterTask.java:57)
[hibernatetool]         at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:160)
[hibernatetool]         at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[hibernatetool]         at org.apache.tools.ant.Task.perform(Task.java:364)
[hibernatetool]         at org.apache.tools.ant.Target.execute(Target.java:341)
[hibernatetool]         at org.apache.tools.ant.Target.performTasks(Target.java:369)
[hibernatetool]         at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[hibernatetool]         at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[hibernatetool]         at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[hibernatetool]         at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[hibernatetool]         at org.apache.tools.ant.Main.runBuild(Main.java:668)
[hibernatetool]         at org.apache.tools.ant.Main.startAnt(Main.java:187)
[hibernatetool]         at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[hibernatetool]         at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)

I'm confused about, if the database is empty, I get the normal messages about table creation and so on, but really nothing is happend!

max · **Posted:** Thu Jul 27, 2006 7:38 am

my guess is that the sql is correctly executed but that hsqldb in your configuration does not peform a shutdown correctly to leave the tables there.

this is a quirk of HSQLDB and look in its documentation for ways to solve it.

thilo · **Joined:** Thu Jul 27, 2006 3:44 am **Posts:** 4

max, it seems you are right. but it is a tricky bit to solve this!

should I post my solution, if I would find one?

max · **Posted:** Thu Jul 27, 2006 2:17 pm

sure - and i bet it has to do with enabling shutdown true ;)

thilo · **Joined:** Thu Jul 27, 2006 3:44 am **Posts:** 4

Max, you are great!

I've just added hibernate.connection.shutdown=true and it runs as expected! I thought I've read the whole hibernate manual, but the shutdown property was new for me.

Thank you very much for your help!
Thilo

max · **Posted:** Fri Jul 28, 2006 3:46 am

its not a hibernate property, but a property for the hsqldb connection.