I have enabled TCP/IP connections for the Hypersonic database following the "Getting started" guide. I disabled the "localDB" MBean and changed the dependency accordingly.
It all went fine, there are no errors on startup and shutdown, and I can connect with both the DatabaseManager in the JMX console as well as from some other database tool.
Then I changed the password for user "sa" by connecting with the DatabaseManager and issuing a "set password" command, and updated the password in both conf/login-config.xml and deploy/hsqldb-ds.xml.
After a restart this seems to have went OK, but whenever I shutdown JBoss AS i get the following error message:
14:28:17,928 INFO [ConnectionFactoryBindingService] Unbound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' from JNDI name 'java:DefaultDS' 14:28:17,950 WARN [HypersonicDatabase] Stopping failed jboss:service=Hypersonic java.sql.SQLException: Access is denied at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:806)
Just a follow-up:
It seems the issue is not critical, at least I can say that persistent messages are still there after a restart of JBoss AS.
Anyway, I have switched to MySQL now, works fine without problems.