Hibernate version:2.1.8

Full stack trace of any exception that occurs:... BUILD SUCCESSFUL!

Name and version of the database you are using:HSQLDB 1.8.0

As a newbie I started by checking other posts for what might have been an admittedly basic problem. Essentially I am having the same problem as outlined on http://forum.hibernate.org/viewtopic.php?t=940532. There were no solutions posted to this thread and I have not been able to contact the user for the solution they found subsequently.

As in this example, I am having trouble generating the SQL for the TRACK table into the HSQLDB file music.script when using Ant. Also it is not present when viewed in the HSQLDB gui. It appears to build in Ant fine. Even when a separate output file is stipulated in the build.xml file, with text set to ‘yes’, it outputs SQL to the stipulated file fine. Just not to the music.script file.

Any help is appreciated.

1)you cam edit the output file (change "Create TABLE" by "CREATE CACHED TABLE",etc). see hsql documentation.
2)see also:
http://opensource.atlassian.com/projects/hibernate/browse/HB-1398