CAS persistance via MS SQL and HSQLDB

[Andrew Bruno]

Hi

I am trying to configure CAS to use either MS SQL or HSQLDB

I've successfully configured it to use MS SQL (our production db) but
I am struggling to get it working with HSQLDB in memory db for local
development.  I have verified that the local hsqldb exists with
Squirrel.

2008-09-10 20:01:18,049 WARN  [SettingsFactory.java:117] : Could not
obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (User not found: )
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)


Does anyone have any ideas or pointers?

Thanks
Andrew