The solution:
copy hsqldb.jar to $GLASSFISH_HOME/domain/$DOMAIN/lib/
Use org.hsqldb.jdbc.jdbcDataSource for "Datasource classname"
And the "additional properties":
username: yourusername
password: yourpassword
database: jdbc:hsqldb:hsql//your_server/your_db
It looks like easy now... But sincerely, it makes me cry :-)
[Message sent by forum member 'rageice' (rageice)]
http://forums.java.net/jive/thread.jspa?messageID=275997