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 🙂





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s