The write format 3 is larger than the supported format 2

Problem: When trying to connect H2 database with DBeaver returns next error:

The write format 3 is larger than the supported format 2

Solution:

The problem is that is trying to connect H2 with a wrong driver, so is necessary to follow next steps:

  1. In DBeaver, in database menu go into ‘Driver Manager’ and copy existing ‘H2 Embedded V.2’ just clicking on copy button.
  2. Rename it with other name, for example ‘H2 embedded V.3’.
  3. Inside ‘H2 embedded V.3’ click on edit and inside tab ‘Libraries’ click on ‘Download/Update’ and choose version ‘v2.3.232’.
  4. Create a new connection using this new configuration.

Explanation:

Source: documentation

For more interesting tutorials & guides just check them HERE.

Leave a Reply

Your email address will not be published. Required fields are marked *