The properties that are to be set for the connection pool are "user", "password" and "database". According to the HSQL docs, the setDatabase method of the DataSource sets the database connection [b]URL[/b] attribute.
If you are using the "localhost-sa" urlid definition from the config file (sqltool.rc), specify the appropriate url (jdbc:hsqldb:hsql://localhost for this urlid) in the database property.
Hope this helps,
Shalini.
[Message sent by forum member 'sm157516' (sm157516)]
http://forums.java.net/jive/thread.jspa?messageID=268132