Bump h2 from 1.3.173 to 2.0.206 in /jpa/datasourcedefinition-webxml-pu by dependabot[bot] · Pull Request #485 · javaee-samples/javaee7-samples

Version 2.0.206

Critical security issue with H2 console is fixed.

Also important changes included:

Version 2.0.204

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.

Version 2.0.202

Besides many dozens of fixed bugs, performance improvements, more adherence to a standard SQL syntax and type system, there are

Some new features:

• Complete re-work of INFORMATION_SCHEMA to be more in-line with the standard
• Support for new types: ARRAY, ROW, JAVA_OBJECT
• Numerous bit, string, array and system functions implemented
• Standard-based access to generated keys
• JDBC 4.2 compliance
• Support for JDK 7 is dropped
• PageStore is discontinued

MVStore changes:

• Descending MVMap and TransactionMap cursor
• Disk space reclamation algorithm improvements

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.

Version 1.4.200

Some new features:

• JSON data type; JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG, and JSON_ARRAYAGG functions; JSON predicate
• TIME WITH TIME ZONE data type
• BITNOT, LSHIFT, and RSHIFT functions