1 Reply Latest reply on Oct 16, 2005 7:22 PM by dode

    "Access is denied" when stopping service Hypersonic on shutd

    dode

      Hello,

      I have enabled TCP/IP connections for the Hypersonic database following the "Getting started" guide. I disabled the "localDB" MBean and changed the dependency accordingly.

      It all went fine, there are no errors on startup and shutdown, and I can connect with both the DatabaseManager in the JMX console as well as from some other database tool.

      Then I changed the password for user "sa" by connecting with the DatabaseManager and issuing a "set password" command, and updated the password in both conf/login-config.xml and deploy/hsqldb-ds.xml.

      After a restart this seems to have went OK, but whenever I shutdown JBoss AS i get the following error message:

      14:28:17,928 INFO [ConnectionFactoryBindingService] Unbound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' from JNDI name 'java:DefaultDS'
      14:28:17,950 WARN [HypersonicDatabase] Stopping failed jboss:service=Hypersonic
      java.sql.SQLException: Access is denied
       at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
       at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
       at org.hsqldb.jdbcDriver.connect(Unknown Source)
       at java.sql.DriverManager.getConnection(DriverManager.java:525)
       at java.sql.DriverManager.getConnection(DriverManager.java:171)
       at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:806)
      


      Did I forget to update the password somewhere else or what I did I do wrong?

      When I revert to the blank password this error is gone.

      Thanks,
      Torsten