Hypersonic java.sql.SQLException: User not found: SA

[Arkie]

If you are running JBoss and encounter this error:

ERROR [org.jboss.jdbc.HypersonicDatabase] Starting failed
jboss:database=localDB,service=Hypersonic
java.sql.SQLException: User not found: SA
        at org.hsqldb.Trace.getError(Unknown Source)
        at org.hsqldb.Trace.error(Unknown Source)
        at org.hsqldb.UserManager.get(Unknown Source)
        at org.hsqldb.UserManager.getUser(Unknown Source)
        at org.hsqldb.Database.connect(Unknown Source)
        at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
        at org.hsqldb.jdbcConnection.(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:812)
        at
org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:623)
        at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:593)
       
etc..

try to remove the directories "tmp" , "work" , "data" in: X:\jboss-4.2.3.GA\server\default and run JBoss again, this will enable you to rebuild the database and JBoss should run without the " User not found: SA" error. I suspect that this happens when you are closing the JBoss application server while it's still trying to read/write data to the Hypersonic database. Solved my problems.