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

[Dmitri Livotov <dmitri@xxxxxxxxxxxxxx>]

Thanks, it works with this patch.

Again, my congratulations with the 1.0 release!
Great product and great job!

Dmitri

On Tuesday, May 6, 2003, at 01:12 Europe/Moscow, Tobias Downer wrote:

> 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.
>
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
>
--
Dmitri Livotov, Senior Software Engineer
Lucid Dream Software, Inc.
dmitri@luciddream.com
http://www.luciddream.com