Skip to main content Skip to complementary content

Upgrading the H2 database from 1.x to 2.x version

The H2 database driver is upgraded to version 2.1.210, following CVE issues. The database built by driver version 1.4.196/1.4.200 is not compatible with version 2.1.210. To upgrade the database, you need to backup the database with the old H2 driver and restore this backup on the new driver.


  1. Prepare the database drivers:
    • The old one (h2-1.4.196.jar/h2-1.4.200.jar).
    • The new one (h2-2.1.210.jar).
  2. Backup the database using the Script tool:
    // use the h2-1.4.196.jar/h2-1.4.200.jar to backup the current h2 db:talend_administrator to file:
    java -cp .\h2-1.4.200.jar -url 
    -user tisadmin -password tisadmin -script -options compression zip
  3. Restore the backup to the new database using the RunScript tool:
    // use the h2-2.1.210.jar to restore the backup file: to new db: talend_administrator_new
    java -cp .\h2-2.1.210.jar -url 
    -user tisadmin -password tisadmin -script -options compression zip
  4. Update the file name to Talend Administration Center will use this new file which works with the 2.1.210 driver.
    Also update <ApplicationPath>/WEB-INF/classes/ file with the correct JDBC URL:
    For more information on how to upgrade, backup, and restore the H2 database, see

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!