<div dir="ltr"><div>Hi all,</div><div><br></div><div><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">LibreOffice have decided to no longer maintain the HsqlDB 1.8 embedded database and replace it with an embedded database based on Firebird.</span></span><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">I have chosen to rewrite the entire com.sun.star.sdbc/sdbcx and sdb layer in pure Java (i.e. jdbcDriverOOo).</span></span></span></div><div><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">I have chosen to port all databases, providing a JDBC driver with an integrated engine and the ability to create a new database upon connection if it doesn't exist, as an embedded database in LibreOffice. (ie: HyperSQLOOo, SQLiteOOo, JaybirdOOo, H2dbOOo and DerbyOOo).</span></span></span></div><div><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Since nothing was planned for this in LibreOffice I had to, with the precious help of some of you, publish the bug </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=156471">tdf#</a></span></span></span><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=156471">156471</a><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"></span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"> then a correction <a href="https://gerrit.libreoffice.org/c/core/+/154989">PR#</a></span></span></span><a href="https://gerrit.libreoffice.org/c/core/+/154989">154989</a><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"> to support </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">integrated databases in a generic way.</span></span></span><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Although this fix was released on 2023-07-28, it will not be available until version 24.2, </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">almost six months later.</span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Now I have overcome a problem that all LibreOffice UNO components written in Java have, namely the inability to deploy Java SPI services.</span></span> <span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">This was overcome thanks to the use of Java instrumentation with <a href="https://bugs.documentfoundation.org/show_bug.cgi?id=165774">tdf#</a></span></span></span><a href="https://bugs.documentfoundation.org/show_bug.cgi?id=165774">165774</a><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"> </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">and the deprecated </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"> </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><a href="https://gerrit.libreoffice.org/c/core/+/181159">PR#</a></span></span></span><a href="https://gerrit.libreoffice.org/c/core/+/181159">181159</a> <span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"> and then again and finally <a href="https://gerrit.libreoffice.org/c/core/+/183280">PR#</a></span></span></span><a href="https://gerrit.libreoffice.org/c/core/+/183280">183280</a>.</div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Again, this new functionality will only be usable with version 25.8, which is not even available yet, even though the latest version of jdbcDriverOOo is capable of offering these new services. </span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">And unfortunately, no one really helped me, but rather deliberately complicated things...</span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">I would like to point out that it was very difficult and long to implement from a human point of view, given the few lines of code it contains, and I even thought at one point that you were going to refuse this PR... I had to prepare two in order to achieve my goals.</span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">In short, all this doesn't really correspond to collaboration but more to an unhealthy competition that I can't explain.</span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">This sounds very similar to your <a href="https://www.reddit.com/r/linux/comments/ja0q8v/open_letter_from_libreoffice_to_apache_openoffice/">Open Letter from LibreOffice to Apache OpenOffice</a></span></span></span><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">, which I believe was requesting more space for LibreOffice.</span></span><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">I'm asking you for exactly the same thing: please give me a little space... and give me a mentor...</span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Sincerely,</span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb">Pierre Vacher</span></span></span><span class="gmail-ZSCsVd"></span></div><div aria-hidden="true" class="gmail-UdTY9 gmail-WdefRb"><div class="gmail-kO6q6e"></div></div><div class="gmail-XL3Kf gmail-XExWNc"><div class="gmail-a8FIud gmail-X0rvP"><div><div class="gmail-dig2sb"><span></span></div></div></div></div><div class="gmail-XL3Kf gmail-XExWNc"><div class="gmail-a8FIud gmail-X0rvP"><div></div></div></div><div class="ebT7ne gmail-VOLvac gmail-sMVRZe"><div class="gmail-F0pQVc"></div></div><div class="gmail-VO9ucd"><div class="gmail-aJIq1d" dir="ltr"><span></span><div class="gmail-m0Qfkd"><span><br></span></div></div></div><br></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div class="gmail-lRu31" dir="ltr"><span class="gmail-HwtZe" lang="en"><span class="gmail-jCAhz gmail-ChMk0b"><span class="gmail-ryNqvb"><br></span></span></span></div><div aria-hidden="true" class="gmail-UdTY9 gmail-WdefRb"><div class="gmail-kO6q6e"><br></div></div></div></div>