HSQLDB just gone?

mlabonte · December 5, 2006, 2:16pm

Okay, so after a few hiccoughs I got the server running. It went down last night so we could change it’'s location. We tested a power down before moving it just to make sure it came back up fine, it did. But now here I am onsite and it seems to have corrupted…

When starting the server everything goes as per normal, but instead of giving me the expected login screen to the admin console, it asks me to redo the setup! And worse still, when trying to use the embedded database option it fails! I have no SQL server, nor is one in the budget, so I really need this embedded database up and running!

The specific error is:

A connection to the database could not be made. View the error message by opening the “/logs/error.log” log file, then go back to fix the problem.

And the log file entry reads:

2006.12.05 09:08:31 org.jivesoftware.database.EmbeddedConnectionProvider.start(EmbeddedConnectionPro vider.java:79) Error starting connection pool.

java.io.IOException

at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:120)

at org.jivesoftware.database.EmbeddedConnectionProvider.start(EmbeddedConnectionPr ovider.java:75)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:441)

at org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dsettings_jsp._js pService(setup_002ddatasource_002dsettings_jsp.java:157)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:830)

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:471)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.http.HttpServer.service(HttpServer.java:909)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2006.12.05 09:08:31 org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConne ctionProvider.java:46) Error: EmbeddedConnectionProvider.getConnection() wascalled before the internal pool has been initialized.

2006.12.05 09:08:31 org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:452)

java.lang.NullPointerException

at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:626)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:446)