Home > Enterprise >  Error in Intelij h2 config The write format 1 is smaller than the supported format 2, spring boot ap
Error in Intelij h2 config The write format 1 is smaller than the supported format 2, spring boot ap

Time:04-12

While trying to connect H2 data source by URL in Intelij, following error occurs:

The write format 1 is smaller than the supported format 2

CodePudding user response:

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: enter image description here

  • Related