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

[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
Andreas

On Tue, 2023-08-01 at 06:35 -0700, Fredrik Sjögren wrote:
> 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 works well.
> 
> Has something changed so the files are not compatible?
> Any way to get around this in an easy way? The upgrade from version 1
> was a hassle for us earlier and we really wish not to do that again.
> Is there any way to get more information about why it gets this
> error?
> -- 
> You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to h2-database+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/619938c2-25f5-47cd-909c-c2cb1796464fn%40googlegroups.com
> .

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/b5d0656eae4b9ea262d51caa64c55c1878e7e87c.camel%40manticore-projects.com.

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

[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 think it is possible to do the same with H2. What do you think about it?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/9905b634-b8c3-433f-9623-745d707283b5n%40googlegroups.com.

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

[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 this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/CAFYHVnXe4bs6TeTUr0txR4eC9JV4pSfqV8htN7OZbdiP8CyecQ%40mail.gmail.com.

[h2] Problem upgrading from h2 version 2.1.214 to 2.2.220

[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 works well.

Has something changed so the files are not compatible?
Any way to get around this in an easy way? The upgrade from version 1 was a 
hassle for us earlier and we really wish not to do that again.
Is there any way to get more information about why it gets this error?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/619938c2-25f5-47cd-909c-c2cb1796464fn%40googlegroups.com.