#5 hsqldb file version conflict in jboss 3.2.5

v0.2.1
closed-fixed
Carlos Saltos
7
2004-10-02
2004-10-02
Carlos Saltos
No

hsql connection fails attemping to access a different
file version.

2004-10-02 16:40:25 ERROR (crawler.Crawler:69) - Unable
to create store
java.sql.SQLException: Wrong database file version
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.check(Unknown Source)
at org.hsqldb.Trace.check(Unknown Source)
at org.hsqldb.Log.open(Unknown Source)
at org.hsqldb.Database$Logger.openLog(Unknown
Source)
at org.hsqldb.Database.open(Unknown Source)
at org.hsqldb.Database.<init>(Unknown Source)
at
org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at
java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.oxyus.store.Store.open(Store.java:107)
at
org.oxyus.crawler.Crawler.<init>(Crawler.java:64)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at
java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at
org.quartz.core.JobRunShell.initialize(JobRunShell.java:135)
at
org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:335)

Discussion

  • Carlos Saltos
    Carlos Saltos
    2004-10-02

    • status: open --> closed-fixed
     
  • Carlos Saltos
    Carlos Saltos
    2004-10-02

    Logged In: YES
    user_id=281986

    this happen with containers with has old versions of hsqldb.

    the database is created now with the current hsqldb version
    used in the container in the web module loading time.

    old versions of hsql may not have sequence support, so
    internal sequence is implemented in oxyus when database
    native sequences fails.