Upgrading the H2 database after changing H2 driver from 1.4.196 to 1.4.200 - 8.0

Talend Data Management Platform Migration and Upgrade Guide

Version
8.0
Language
English (United States)
EnrichDitaval
Data Management Platform
Product
Talend Data Management Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend Identity and Access Management
Talend JobServer
Talend Log Server
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
The H2 database driver is changed from version 1.4.196 to 1.4.200 from Talend 7.3.x. The database built by driver version 1.4.196 is not compatible with version 1.4.200. To upgrade the database, you need to backup the database with the old H2 driver and restore this backup on the new driver.

Procedure

  1. Prepare the H2 database driver, h2-1.4.196.jar and h2-1.4.200.jar.
  2. Backup the database with the using the Script tool:
    // use the h2-1.4.196.jar to backup the current h2 db:talend_administrator to file: tac_backup.zip
    java -cp .\h2-1.4.196.jar org.h2.tools.Script -url "jdbc:h2:file:D:/Tomcats/tacdb/migrate/talend_administrator;MV_STORE=FALSE;AUTO_SERVER=TRUE;LOCK_TIMEOUT=15000" -user tisadmin -password tisadmin -script tac_backup.zip -options compression zip
  3. Restore the backup to the new database using the RunScript tool:
    // use the h2-1.4.200.jar to restore the backup file: tac_backup.zip to new db: talend_administrator_new
    java -cp .\h2-1.4.200.jar org.h2.tools.RunScript -url "jdbc:h2:file:D:/Tomcats/tacdb/migrate/talend_administrator_new;MV_STORE=FALSE;AUTO_SERVER=TRUE;LOCK_TIMEOUT=15000" -user tisadmin -password tisadmin -script tac_backup.zip -options compression zip
  4. Update the talend_administrator_new.h2.db file name to talend_administrator.h2.db. Talend Administration Center will use this new file which works with the h2-1.4.200 driver.
    For more information on how to upgrade, backup, and restore the H2 database, see https://h2database.com/html/tutorial.html#upgrade_backup_restore.