Support H2 with database format v3 — v 2.2.220

[metzing]

Is your feature request related to a problem? Please describe.
Starting with version 2.2.220 H2 database writes the files with version v3. This version is currently not supported by DBeaver, resulting in an error message when trying to open the file.

Describe the solution you'd like
I would like to be able to open H2 database files that are written in format v3.

Describe alternatives you've considered
We have reverted to H2 v2.1.214 to retain the compatibility with DBeaver, though it has a security vulnerabilty.

Additional context

• Maven artifact
  
• PR increasing write version

[E1izabeth]

Thank you for request.

[metzing]

Hey,

I can see this was removed from the 23.1.5 milestone.
Is there any blockers, anything I can assist with? When can we expect the feature?

Thanks,
Marton

[Destrolaric]

@metzing, Hi,
The breaking changes in the minor version raised some questions, so we had some delays. We are planning to look at this issue again in this release.

[metzing]

Thanks for the update

[metzing]

Hello again, now I see it was put into the won't do bucket - may I ask why?

This feature would be very nice for our team as we find your tool very versatile, working with S4/HANA Cloud and local DB files as well.

I can also see the open PR for it, seems to be just including another driver into your config. I don't see the reason why that would be a breaking change or too large effort. Let me know if I can assist in any way.

Thanks,
Marton

[travnja3]

I had the same issue and used Driver Manager to add the new driver, and now I'm able to open version 3 files without any issue.

[metzing]

Thanks for the idea @travnja3, I was also able to configure a custom driver using the Driver Manager.

Instructions:

1. Open the Driver Manager under Database > Driver Manager
2. Create a new configuration using the New button
3. Fill the info in the Settings tab like so (based on the configuration in dbeaver/dbeaver#20676 add h2 v3 #20835):
   
4. On the Libraries tab, press Add Artifact
5. In the Edit Maven Artifact popup, fill the info of the H2 maven artifact:
   
6. Select the new item in the list, and press the Download/Update button, then Download in the new popup
7. Press the Find Class button, the Driver class should be selected automatically:
   
8. Again based on dbeaver/dbeaver#20676 add h2 v3 #20835 I've also set the following parameters in the Advanced parameters tab:
   • Parameters > Omit catalog = [v]
   • Queries > Get active database = SELECT SCHEMA()
   • Queries > Set active database = SET SCHEMA = ?
   • Queries > Shutdown database = shutdown
9. Save the new driver configuration
10. When creating a new connection, select the new custom driver in the first step, and configure as usual.

[metzing]

@E1izabeth @Destrolaric @arhayka any news on this please? Why is it in the won't do bucket?