Fehlerbehebung
Die verwendete Version hat Schwachstellen:
h2-1.4.190.jar cpe:2.3:a:h2database:h2:1.4.190:*:*:*:*:*:*:*
Daten-Migration
Erzeugen eines Dump-Files mit der alten Version:
mkdir backup
mv ./tmp/h2* backup/
mvn org.apache.maven.plugins:maven-dependency-plugin:2.1:get \
-Dartifact=com.h2database:h2:1.4.199 -DrepoUrl=central
java -cp ~/.m2/repository/com/h2database/h2/1.4.199/h2-1.4.199.jar \
org.h2.tools.Script \
-url jdbc:h2:./backup/h2 \
-user user -password passwd
Einspielen des Dump-Files in eine neue Datenbank.
mvn org.apache.maven.plugins:maven-dependency-plugin:2.1:get \
-Dartifact=com.h2database:h2:2.1.210 -DrepoUrl=central
java -cp ~/.m2/repository/com/h2database/h2/2.1.210/h2-2.1.210.jar \
org.h2.tools.RunScript \
-url jdbc:h2:./tmp/h2 \
-user user -password passwd \
-options "FROM_1X"
From http://www.h2database.com/html/migration-to-v2.html:
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible.
>
There exists a migration tool H2MigrationTool (https://github.com/manticore-projects/H2MigrationTool) available in GitHub, but it hasn't been tested by our team. Use at your own risk.
>
The official way to upgrade is to export it into SQL script with the SCRIPT command (https://h2database.com/html/commands.html#script) USING YOUR CURRENT VERSION OF H2.
Then create a fresh database USING THE NEW VERSION OF H2, then perform a RUNSCRIPT (https://h2database.com/html/commands.html#runscript) to load your data. You may need to specify FROM_1X flag, see documentation of this command for details.
Test
Update, kein zusätzlicher Test.