#5 hsqldb file version conflict in jboss 3.2.5

[Carlos Saltos]

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)

[Carlos Saltos]

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.