Can't open existing h2.db

ccavanaugh / jgnash

jGnash Personal Finance

http://ccavanaugh.github.io/jgnash/

Other

139 stars 80 forks source link

Can't open existing h2.db #48

Closed henryken closed 6 years ago

henryken commented 6 years ago

Expected Behavior

Able to open the DB successfully

Actual Behavior

"Invalid password or tried to open the wrong file type"

Steps to Reproduce the Problem

Open existing H2 DB with new version 2.34.1
"Invalid password or tried to open the wrong file type"

Specifications

jGnash Version: 2.34.1
Operating System: Windows 10
Java Version 1.8

ccavanaugh commented 6 years ago

Two options.. open the last backup (zipped file), or revert back a release, save as an XML or simple binary file and it will open correctly in the new release. From there, you can save back to an H2 database.

I'm going to post a more detailed message in the user and devel Google Groups list today.

Root cause is your file is still using the old database schema and it takes manual intervention to upgrade. The ability it handle the old schema broke in this last release.