I tried to use HSqlDb with nukes (JBoss 4.0.0 + Nukes2.0). For that i had changed "nukes-ds.xml" to have.
... <jndi-name>NukesDS</jndi-name>
<connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class> ...
Also i had created the objects in HSQLDB using the DDLs from "setup.ddl" that i had build at nukes-2.0\core\output\resources. (Of course i had to change the Sqls for HSQLDB syntax ).
The Nukes deployment went well (Except the error : INFO [ServiceConfigurator] Problem configuring service jboss:service=Mail) and i am able to access the portal page at http://localhost:8080/nukes/.
I think the DB connectivity is OK since i could see the user details entered in table "JBP_USERS" in HSQL DB, when i tried to create new user. But i get the following errors :
ERROR [JDBCExceptionReporter] Unexpected token: LAST_INSERT_ID in statement [SELECT LAST_INSERT_ID()]
ERROR [JDBCExceptionReporter] could not insert: [org.jboss.nukes.core.impl.user.UserImpl]
I guess "LAST_INSERT_ID()" is a MySql function. Can you let me know what other configuration (for HSqlDB) i have to do ?. Or is it not possible to use HSQLDB with the above JBoss\Nukes versions ???