Re: Beware: DatabaseManager silently upgrades db file format

We already have umpteen settings related to how to open databases. It
does not help when a user does not read the Guide which states what
happens when you open an old version database.

An old version database can be opened as readonly, or as read-write
which upgrades it. It is not possible to open an old version database as
read-write and save the changes in the old format.

The GUI app is just one app used to open databases. There are many
others too.

Version 1.7.x was a good product, but we have continued our work and
made a far superior product over the years.

Fred



On Fri, Oct 11, 2013, at 16:49, Loyall, David wrote:
> > From: Fred Toussi 
> > You can open those files as readonly. See the Properties chapter of the Guide on connection properties.
> 
> But, then I can't change the database contents.
> 
> How about this: only upgrade a database if the URL contains an 'upgrade'
> property set to true.
> 	jdbc:hsqldb:file:~/filedb;upgrade=true
> 
> If a database cannot be opened without an upgrade, issue an error message
> that says so.
> 
> As a reminder: my other idea was to put a prompt in the gui app itself.
> 
> Otherwise, I am sure I won't be the last person to successfully edit an
> old (1.7.x) hsqldb with the latest Manager GUI, only to find that the
> legacy application can't read the files afterwards.
> 
> Incidentally, hsqldb is a fine product!  Even version 1.7.x allows us to
> store 2gb+ of data in a portable way... (For better or worse...)  :)
> 
> Cheers,
> --Dave
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from 
> the latest Intel processors and coprocessors. See abstracts and register
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk