Hi,
I recently encountered a strange behaviour using HSQL 1.8.0.10. Apparently, when hsqldb.jar is in a directory containing "!" (without quotes) the init will fail with this exception:
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class org.hsqldb.Trace
at org.hsqldb.Database.reopen(Unknown Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
at org.hsqldb.DatabaseManager.newSession(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbc.jdbcDataSource.getConnection(Unknown Source)
at org.hsqldb.jdbc.jdbcDataSource.getConnection(Unknown Source)
Changing the directory (not the classpath, I'm using relative classpath) of hsqldb.jar will work.
I guess this isn't quite normal. My machine is a WinXp Profesional with java 6.