I'm using mysql, so I'm not sure I can help you precisely.
That's what I would do ...
stop
tomcat,
don't overwrite you database, but simply attach to the hsqldb script file, at the end of the file, the update script.
And just restart: it should work.
Ask for any doubt
[originally posted on jforum.net by enricod]