Bug 139538 - Cannot load HsqlDB other than 1.8.0
Summary: Cannot load HsqlDB other than 1.8.0
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected)
6.3 all versions
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2021-01-11 13:25 UTC by prrvchr
Modified: 2022-06-24 13:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description prrvchr 2021-01-11 13:25:41 UTC

On LibreOffice (6.x and 7.x and maybe even 5.x) under Linux, if you have installed the package: libreoffice-sdbc-hsqldb (which installs libhsqldb1.8.0-java), then it is impossible to load a hsqldb.jar driver other than version 1.8.0.

How to reproduce:

- Install the extension HsqlDBDriverOOo from the download link: https://github.com/prrvchr/HsqlDBDriverOOo/releases/download/v0.0.3/HsqlDBDriverOOo.oxt

Go to: Tools -> Options -> Base drivers -> HsqlDB driver, and see the driver version:

- If packages: libreoffice-sdbc-hsqldb and libhsqldb1.8.0-java are installed, version displays 1.8.0.

- If the packages: libreoffice-sdbc-hsqldb and libhsqldb1.8.0-java are not installed, version displays 2.5.1 which is the version of the hsqldb.jar file supplied with the extension.

To work around this problem, I wrote another extension HsqlDBembeddedOOo, available on this link: https://github.com/prrvchr/HsqlDBembeddedOOo/releases/download/v0.0.3/HsqlDBembeddedOOo.oxt, allowing LibreOffice users on Linux to use the HsqlDB Embedded functionality and a newer version of the HsqlDB driver simultaneously.

OpenOffice and LibreOffice on Windows do not seem to be affected by this malfunction.
Comment 1 Julien Nabet 2021-01-11 18:10:02 UTC
Noticing your interest in this part, would you be interested in contributing directly in LO?
Indeed, it seems you already did quite a good part of the job:
- analyzed the pb
- proposed a fix (even if it's an extension in Python and not native C++ code).

In order you have an idea, here's a link:

Here are the steps:
1) Retrieve source code with git
2) Build the code (it can take some hours depending on the power of your machine and the options you give to the build)

3) Provide license statement
4) Create an account on gerrit

And you're ready to hack!

Here are some other hints to help:
- to search the code:
   - https://opengrok.libreoffice.org/
   - "git grep" which will be faster than a simple "fgrep"

Part (all?) of HSQLDB support in LO is in:

Now the pb is, except Lionel that I put in cc and who has almost no time now for LO, I don't know who will be able to review your patches and so will be able to push them on git repo.

Lionel: of course if prrvchr is interested in contributing, would you be interested in "mentoring"/"reviewing" him or know someone who may do it?
Comment 2 Alex Thurgood 2022-06-24 09:51:42 UTC
(In reply to prrvchr from comment #0)

> How to reproduce:
> - Install the extension HsqlDBDriverOOo from the download link:
> https://github.com/prrvchr/HsqlDBDriverOOo/releases/download/v0.0.3/
> HsqlDBDriverOOo.oxt

@pvrrvchr : just so you know, I downloaded and installed your latest OXT from github on the macOS (Arm) version of LibreOffice and it seems to work OK - great stuff ! Thanks !
Comment 3 prrvchr 2022-06-24 13:10:50 UTC
Hi Alex,

Nice to know that it work on macOS (Arm) version of LibreOffice.
Your welcome, enjoy...