The H2 database driver is upgraded to version 2.2.224, following CVE issues. The
database built by the old driver version is not compatible with version 2.2.224. To upgrade
the database, you need to backup the database with the old H2 driver and restore this backup
on the new driver.
Procedure
Backup Talend Administration Center
with H2 database:
Copy the following
/<tomcat_path>/webapps/org.talend.administrator into a backup
directory: <backup_directory_path>.
Unzip the database driver JARs:
The old one (h2.2.x.jar, for example).
The new one (h2-2.2.224.jar).
Open a terminal into
<backup_directory_path>/org.talend.administrator/WEB-INF/lib.
Enter the following command with the old version of the driver: java -jar
h2-2.x.jar.
Enter the following command in the console SCRIPT TO
'<backup_file_path>/backup.sql'; and click
Run.
This will export the content of the old database to a SQL file with the provided
name and at the given location.
Shut down the previous H2 server.
Open <tomcat_path>/webapps/ and remove all files in
/<tomcat_path>/webapps/org.talend.administrator/database.
To launch the H2 browser console at http://localhost:8082/., open a terminal inside
/<tomcat_path>/webapps/org.talend.administrator/WEB-INF/lib
and enter the following command: