jboss Deployment Problem : java.sql.SQLException: User not found: SA

Some times while deploying J2EE applications in jBoss server the following error message will be encounter (partial trace) :

[org.jboss.system.ServiceController] Problem starting service jboss:service=Hypersonic,database=localDB
java.sql.SQLException: User not found: SA
    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:768)

Please follow the following steps to rectify the problem

  1. stop jboss server
  2. delete tmp, work and data folder from your <jBoss-home>/server/<servername>/

Hope the solution works for all 🙂

Cheers

Sasanka