Yep, I had the same problem with hsqldb. The default system will not commit any hsqldb tables or data to the hdd out of the box, and you have to modify the way JBoss uses the hsql create statement to chnage this.
I switched to MySQL to fix it.
oh man, that sucks. I will have to add the tables to the scriptfile directly then. I'm forced to use hsql... thanks for the input!