3 Replies Latest reply on Dec 18, 2006 2:08 PM by Frank Smith

    Starting failed jboss:database=localDB,service=Hypersonic

    Frank Smith Newbie

      I am receiving the following error when starting JBoss4:

      Starting failed jboss:database=localDB,service=Hypersonic
      java.sql.SQLException: General error: java.lang.NullPointerException

      I am running the application under Eclipse, using the JBoss4 server.

      The applications continue to run fine, however.

      I had this problem once before, and I found a search entry which described fixing the problem by deleting an apparently corrupted file and then restarting the Application, which recreated the file correctly: this fixed the problem.

      As I remember, it was somehow related to ColdFusion (I have both ColdFusion and Java apps running under the same JBoss4 server), but I could be wrong. No rap on ColdFusion, which is a nice product, just that I think it may be related.

      However, I can't find the search entry anymore.

      Can anybody help, please?

        • 2. Re: Starting failed jboss:database=localDB,service=Hypersoni
          Sergio Rubio Newbie

          I came across the same problem this today (error suddenly popped up and not being able to find the solution which I know I found before via search), but thankfully had saved off the problem/resolution in a text file. Here's the magic that worked for me:

          This means that the Hypersonic database (the internal datastore that handles JMS messages) has become corrupt. To fix this problem, shutdown all @task servers in the cluster and delete the contents of the JBOSS_HOME/server/default/data/hypersonic directory. These files will be recreated once JBoss is restarted.

          Here's a little more of the stack for others to see:
          10:44:05,087 WARN [ServiceController] Problem starting service jboss:database=localDB,service=Hypersonic
          java.sql.SQLException: User not found: SA
          at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
          at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
          at org.hsqldb.jdbcDriver.getConnection(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:761)
          at org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:611)
          at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:557)

          • 3. Re: Starting failed jboss:database=localDB,service=Hypersoni
            Frank Smith Newbie

            That solved it. Thanks much! Once again, user forums ROCK!