Re: Beware: DatabaseManager silently upgrades db file format
"Loyall, David" <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <FCEE4469EE8B234199968ECA9B0661E230EC754B@STNEEX10MB01.stone.ne.gov> |
> 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