Re: [Hsqldb-user] version compatibility

[Fred T. <fr...@us...>]

There is backward compatibility but forward compatibility is not
guaranteed. With CREATE TABLE there should be a way to edit the script
file to make it work with an older version. You can report it in the
Help forum.

It would be better to move to version 2.3.3 which will be
released shortly.

Fred

On Sat, Jun 27, 2015, at 18:46, Brian Young wrote:
> Hello, is there a document anywhere that talks about forward
> compatibility between different HSQL versions?
>
> We have databases created with version hsqldb-2.3.2 that are yield
> errors (an example below) when opening with 2.2.8.
>
> at org.hsqldb.lib.HashMap.get(Unknown Source) at
> org.hsqldb.SchemaManager.findSchemaObject(Unknown Source) at
> org.hsqldb.SchemaManager.getSchemaObject(Unknown Source) at
> org.hsqldb.ParserDQL.readTypeDefinition(Unknown Source) at
> org.hsqldb.ParserDDL.readColumnDefinitionOrNull(Unknown Source) at
> org.hsqldb.ParserDDL.compileCreateTableBody(Unknown Source) at
> org.hsqldb.ParserDDL.compileCreateTable(Unknown Source) at
> org.hsqldb.ParserDDL.compileCreate(Unknown Source) at
> org.hsqldb.ParserCommand.compilePart(Unknown Source) at
> org.hsqldb.ParserCommand.compileStatement(Unknown Source) at
> org.hsqldb.Session.compileStatement(Unknown Source) at
> org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source) at
> org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) at
> org.hsqldb.persist.Log.processScript(Unknown Source) at
> org.hsqldb.persist.Log.open(Unknown Source) at
> org.hsqldb.persist.Logger.openPersistence(Unknown Source) at
> org.hsqldb.Database.reopen(Unknown Source) at
> org.hsqldb.Database.open(Unknown Source) at
> org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at
> org.hsqldb.DatabaseManager.newSession(Unknown Source) at
> org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) at
> org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) at
> org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
>
> ----------------------------------------------------------------------
> --------
> Monitor 25 network devices or servers for free with OpManager!
> OpManager is web-based network management software that monitors
> network devices and physical & virtual servers, alerts via email & sms
> for fault. Monitor 25 devices for free with no restriction. Download
> now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o[1]
> _________________________________________________
> Hsqldb-user mailing list Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user


Links:

  1. http://ad.doubleclick.net/ddm/clk/292181274%3B119417398%3Bo