don't recall the exact setting, but you'll need to add "mem" to the connection URL - this indicates to HSQL that you want full in-memory mode. Not sure what to do in JBoss specifically, but this is how we run our unit/integration tests.
The hsqldb-ds.xml file included in the starter kit includes a commented-out line to set up the in-memory database:
But I also did try replacing it with:
Both seem to work in terms of creating an HSQL instance. I assume it's in-memory because I don't think I can connect to it using the HSQL management client.
However, my problem is that I don't know how to initialize this environment once it does get started.
None of the tables are populated with the demo data, and without the client, I'm not sure I can manually insert or run scripts. I'm not even sure the jBPM tables have been created: during JBoss startup, all of the tables are reported as "not found" but I'm not sure if they've been created or not as part of startup.
to do it with an in mem db you'll also have to set the hibernate config to autocreate the tables for you. see the hibernate docs on how to do this.