Re: Version 1.00 release - problems with converting pre-release databases

[Tobias Downer <toby@xxxxxxxxx>]

Dmitri Livotov wrote:
> Hi Tobias,
> 
> I tried to upgrade database engine in our test system. Previous database 
> was 0.94h-lb2 beta, approx from March 2-5th, with improved streamable 
> blob support and changed and frozen database format. Version 1.0 did not 
> open old data, converter tool also failed.
> 
> Any ideas how to pickup previous data without data-loss ?

I'm sorry about that.  There is a minor problem with the convert from 
this version.  Below is the patch;

In src/com/mckoi/database/Database.java in the 'convertToCurrent' method 
change the following line;

         out.println("Version 1.3 found.");
         out.println("Converting database to version 1.4 schema...");

         // Create/Update the conglomerate level tables.
         conglomerate.updateSystemTableSchema();

         // Commit the changes so far.
         connection.commit();

To the following;

         out.println("Version 1.3 found.");
         out.println("Converting database to version 1.4 schema...");

         // Create/Update the conglomerate level tables.
         conglomerate.updateSystemTableSchema();

         // Commit the changes so far.
         connection.commit();

         // Create/Update the system tables that are present in every
         // conglomerate.
         createSystemTables(connection);

         // Commit the changes so far.
         connection.commit();

Recompile com/mckoi/database/Database.java and update mckoidb.jar.  That 
should update the system function table correctly.  This problem only 
affects the 0.94-lb2 release and some CVS builds with streamable object 
support.

The reason a convert is necessary is because there was an important 
field that was missing from the frozen format and it was really 
important that we put in and we had to make another format version with 
the change.  Sorry about the inconvenience.

Toby.