Re: [h2] Problem upgrading from h2 version 2.1.214 to 2.2.220

2023-08-02 Thread Andreas Reichel
Greetings. You will need to Export to SQL Script and Create new DB from SQL Script. I wrote an UI that can help you with that: https://manticore-projects.com/H2MigrationTool/index.html There is an online version for testing small databases: http://h2migrationtool.manticore-projects.com/ Cheers

[h2] H2 as an embedded database in LibreOffice / OpenOffice Base

2023-08-02 Thread prrvchr
It is possible to integrate any JDBC database into LibreOffice or OpenOffice Base. This integration has already been done for the HsqlDB database and SQLite JDBC with the HsqlDriverOOo and SQLiteOOo extension. I

Re: [h2] Problem upgrading from h2 version 2.1.214 to 2.2.220

2023-08-02 Thread Noel Grandin
You are going to need to do a dump/restore for this upgrade. Elsewhere on this group someone posted a link to a different tool that they wrote that helps with migration - that might be useful. I just normally code up some batch/shell files and run the backup and restore tools. -- You received

[h2] Problem upgrading from h2 version 2.1.214 to 2.2.220

2023-08-02 Thread Fredrik Sjögren
When we have upgraded the h2 library we get following error trying to open the existing databases: *Unsupported database file version or invalid file header in file "/path/to/database.h2.mv.db" [90048-220] 90048/90048* We use a file based database ("jdbc:h2:file:...") Creating new databases