First I ran JBoss and tried to connect to the default DB by
...
Connection con = DriverManager.getConnection
(jdbc:hsqldb:hsql://localhost:1701);
...
Connection was established as expected.
Next, I DID set password in hsqldb-ds.xml in deploy directory but same code as above runs without throwing any exception.
How can I effectively set password so any connection require correct username-password pair?
Thanks.
I'd ask on the hsql list.
Typically this is done using sql statements
create user
grant
etc.