Error in Intelij h2 config The write format 1 is smaller than the supported format 2, spring boot app

H2 2.*.* cannot open database files created by H2 1.4.200 or older versions, you need to export them to SQL with the version that was used to create these files into SQL script (for example, with SCRIPT TO 'filename.sql' command), create a new database with the new version of H2 and populate it with data from this script (for example, with RUNSCRIPT FROM 'filename.sql' FROM_1X command).

See also the documentation: https://h2database.com/html/tutorial.html#upgrade_backup_restore

H2 2.*.* has a helper class org.h2.tools.Upgrade, it can be used by applications to upgrade their databases.

There is also a third-party upgrade tool: https://github.com/manticore-projects/H2MigrationTool

To fixed it in Intelij, version of H2 driver should be changed as following config:

It has also to do with the design of the connection.

Please check both these:

• the url to setup the connection
• the validation and export of schema DDL to the database with the good choice of the parameter of hibernate.hbm2ddl.auto