1 Reply Latest reply on Jul 8, 2007 12:28 PM by Peter Johnson

    JBoss failing to start with Wrong database file version erro

    Jeff Mutonho Newbie

      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
          Peter Johnson Master

          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.