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

    Starting failed jboss:database=localDB,service=Hypersonic

    western541

      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?

        • 1. Re: Starting failed jboss:database=localDB,service=Hypersoni
          thejavafreak

          What is the full stack error?

          • 2. Re: Starting failed jboss:database=localDB,service=Hypersoni
            srubio

            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
              western541

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