password protecting hypersonic db

[cconnelly]

I am having trouble figuring out how to password protect the Hypersonic database that ships with jboss 3.05. My assumption is that I would need to change the "Password" attribute of "org.jboss.resource.connectionmanager.RARDeployment" in "hsqldb-service.xml" file, and then change the password under "HsqlDbRealm" in the "login-config.xml" file. Unfortunately this does not work.

It seems any change I make to "login-config.xml" regarding the password has no effect on the way that jboss connects to the datasource, meanwhile changing the password on the in "hsqldb-service.xml" seems to break my ability to connect to the data source.

What am I doing wrong?

[cconnelly]

Figured out the answer. You have to log into the database and manually type the "set password" command, to setup the password within the database. I thought that was controlled by the jboss configuration file for some reason.