I have the same question.
Can anyone help me?
Ok, I got it!
Start HSQL Database Manager,
Select "Type: HSQL Database Engine In-Memeory" and "URL: jdbc:hsqldb:/hypersonic/localDB", then re-execute myStoreSchema.script and myStoreSchema.data
I did exactly what you suggested, but I still get the same error.
Anyone else get it to work?
I got it...but without the localDB.
What I did was I went and modified hsqldb-ds.xml
Comment out the following lines
It doesn't save though...but I got it to work for testing / tutorials etc.
I did both and none of them worked for me...
Your solution works.
Jboss 3.2.3 (default)