https://bugs.documentfoundation.org/show_bug.cgi?id=139538
--- Comment #6 from [email protected] --- (In reply to prrvchr from comment #0) > Hi, > > 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/ > https://snow-rider.io/ > 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. Remove Default HSQLDB Package: sudo apt remove libreoffice-sdbc-hsqldb libhsqldb1.8.0-java LibreOffice will then use the newer driver from your extension. Use HsqlDBembeddedOOo Extension: This extension enables both embedded HSQLDB functionality and updated drivers. Custom Driver Path: Specify the new driver path in LibreOffice settings, if configurable. Note for Windows and OpenOffice Users As you observed, this issue doesn’t affect Windows or OpenOffice installations, likely because they do not rely on the libhsqldb1.8.0-java package by default. -- You are receiving this mail because: You are the assignee for the bug.
