The required properties for setting up a HSQL datasource with glassfish are
user, password and database.
When i did a standalone DataSource test like
org.hsqldb.jdbc.jdbcDataSource ds = new org.hsqldb.jdbc.jdbcDataSource();
ds.setUser("sa");
ds.setPassword("newpassword");
ds.setDatabase("jdbc:hsqldb:hsql://localhost");
Connection con = ds.getConnection();
i was able to successfully get a connection.
[Message sent by forum member 'sm157516' (sm157516)]
http://forums.java.net/jive/thread.jspa?messageID=318082