[Libreoffice-bugs] [Bug 140268] New: Adding jar for HSQLDB JDBC driver breaks embedded HSQLDB

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140268

            Bug ID: 140268
           Summary: Adding jar for HSQLDB JDBC driver breaks embedded
                    HSQLDB
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: michael at vonglasow.com

In order to connect to an external HSQLDB database via JDBC (e.g. a DB running
in server mode), I need to get a current HSQLDB JAR and add it to the
classpath, as for any JDBC driver.

However, when I do that and open a DB which uses the embedded HSQLDB engine, I
cannot access any tables, presumably due to a conflict between the two HSQL
versions—one that is bundled with LO for the embedded DB, and the other I need
for JDBC. If I need both use cases (external and embedded HSQLDB), I constantly
have to adapt my configuration, and it is impossible to open two different
kinds of DB side by side.

Granted, embedded HSQLDB is deprecated, but that doesn’t mean databases using
that engine are going away overnight—migration may be complex and require a lot
of manual intervention, so we’ll still need that support for quite a while.

However, I suppose the HSQLDB engine which ships with LO already includes a
JDBC driver (it’s bundled into the jar, unless you have made some heavy
modifications to it). So the solution would be to let the user to select that.
Users would be constrained to that particular version of HSQLDB, but that
should not be an issue when connecting to an instance running in server mode
(and that could be used as a workaround to access an external HSQLDB file which
is not compatible with the bundled HSQL version).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210208/d82fb3cf/attachment.htm>