H2 is an embeddable RDBMS written in Java.
Patch release to fix Issue #3883 Performance regression in 2.2.222
Changes since 2.1.214 release:
Important bugs and regression fixes discovered after 2.1.212 release:
Numerous bugs and regression fixes discovered after 2.1.210 release:
Two security vulnerabilities in H2 Console (CVE-2022-23221 and possible DNS rebinding attack) are fixed.
Persistent databases created by H2 2.0.x don't need to be upgraded. Persistent databases created by H2 1.4.200 and older versions require export into SQL script with that old version and creation of a new database with the new version and execution of this script in it.
Critical security issue with H2 console is fixed.
Also important changes included:
Multilple regression fixes discovered after 2.0.202 release,
There are no persistence changes between 2.0.202 and 2.0.204, so jar file swap is enough, if database had been upgraded to 2.0.202 already, otherwise please read the message below:
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible. The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2. Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.
Besides many dozens of fixed bugs, performance improvements, more adherence to a standard SQL syntax and type system, there are
Some new features:
MVStore changes:
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible. The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2. Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.
Some new features:
Incompatible changes:
Other changes:
Known issues:
See change log for the complete list of changes.