JBoss failing to start with Wrong database file version erro

ejbengine Jul 8, 2007 5:54 AM

I'm running jboss-4.0.5.GA and when I try to start the server , I get the following error message :

[ServiceController] Problem starting service jboss:service=Hypersonic,database=localDB
java.sql.SQLException: Wrong database file version
at org.hsqldb.jdbc.jdbcUtil.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(Unknown Source)

and

11:10:49,849 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss:service=Hypersonic,database=localDB
State: FAILED
Reason: java.sql.SQLException: Wrong database file version
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:service=Hypersonic,database=localDB
State: FAILED
Reason: java.sql.SQLException: Wrong database file version
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

What could be causing this?

1. Re: JBoss failing to start with Wrong database file version

peterj Jul 8, 2007 12:28 PM (in response to ejbengine)

When you shutdown the app server, Hypersonic creates two files in the server/xxx/data/hypersonic directory (where xxx is the configuration name, such as 'default'). It would appear that one or both of those files has been corrupted. You can remove that directory and the app server should start without errors. Of course you will lose any data that was stored in that database, but then you should not use Hypersonic to store important data anyway.
Actions