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.
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:
- "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?