[jboss-user] [Installation, Configuration & Deployment] - 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)


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3994716#3994716

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3994716