| Summary: | SQL query produces no output in database with external HSQLDB driver (Windows-only) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jason Paul Kazarian <jpkazarian> |
| Component: | Base | Assignee: | Julien Nabet <serval2412> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | ilmari.lauhakangas, jpkazarian, lionel, serval2412 |
| Priority: | medium | Keywords: | bibisected, bisected, regression |
| Version: | 7.5.0.0 alpha0+ | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=153317 | ||
| Whiteboard: | target:24.2.0 target:7.6.3 | ||
| Crash report or crash signature: | Regression By: | Julien Nabet | |
| Attachments: |
LibreOffice Base tables. Unzip to C:\WatchBase.
database file with hsqlembedded |
||
|
Description
Jason Paul Kazarian
2023-09-27 01:46:50 UTC
Created attachment 189841 [details]
LibreOffice Base tables. Unzip to C:\WatchBase.
This is the database that works with SQL Workshop J yet not Tools -> SQL in LibreOffice base.
You are using an external connection to a HSQLDB. Tried to extract and open WatchBase.odb, but it can't work, because external driver is missing here. Please copy the table into an internal database so everybody could try it without any problem. The attachment works. One *must* download the file to C:\. Then right click on WatchBase.zip and select Extract all... which creates the folder C:\WatchBase. In that folder there is a Driver subdirectory. Double click on WatchBase.odb and it loads. By the way, I do *NOT* experience this bug with 7.4.7.2. So this is a bug with 7.5.6.2. Can't get it working under Linux. Won't install a separate JDBC-driver for HSQLDB. So I can't help here. Connection to the database does not work on macOS. I get the following error message when opening the ODB in the unzipped folder. Code d'erreur: 1000 La classe de pilote "org.hsqldb.jdbcDriver" n'a pas pu être chargée.Le chemin de classe du pilote supplémentaire est "file:///C:/WatchBase/driver/hsqldb.jar". Tried changing the file path to point to the location of the unzipped folder on my macOS system, but still get : La classe de pilote "org.hsqldb.jdbcDriver" n'a pas pu être chargée.Le chemin de classe du pilote supplémentaire est "file:///C:/WatchBase/driver/hsqldb.jar". This appears to be a Windows only bug requiring the use of a separately configured hsqldb.jar Bibisected with Windows 7.5 repo to 6d0470ee00cbf9f9d293c92f92a759cdacbebef0 tdf#153317: direct SQL: try to detect Bit field in Mysql/MariaDB (In reply to Jason Paul Kazarian from comment #3) > The attachment works. One *must* download the file to C:\. Then right click > on WatchBase.zip and select Extract all... which creates the folder > C:\WatchBase. > > In that folder there is a Driver subdirectory. Double click on WatchBase.odb > and it loads. > ... On LO 7.5.6.2 from Debian x86-64, the file loads but when clicking on "Tables", I got: The connection to the data source "WatchBase" could not be established. SQL Status: S1000 Error code: -29 File input/output error //C:/WatchBase/WatchBase Tables\wbase.properties java.io.FileNotFoundException: /C:/WatchBase/WatchBase Tables\wbase.properties.new (No such file or directory) at ./connectivity/source/drivers/jdbc/Object.cxx:173 Could you create an embedded HSQL DB and put the content in it so it'll be easier to reproduce this? Created attachment 190160 [details]
database file with hsqlembedded
On Windows 10 with master sources updated some days ago, I could reproduce this.
I copied the tables, queries, forms, reports in a brand new odb file with hsql embedded.
It seems hsql calls JDBC part and when calling getBytes method it throws an exception, I don't know why. So here's an ugly hack here: https://gerrit.libreoffice.org/c/core/+/157849 Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ad5659d10f20ff39f455e5f19f32b4f9f3078245 tdf#157465: getBytes may trigger an exception with hsql It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Patch for 7.6 branch waiting for review here: https://gerrit.libreoffice.org/c/core/+/157877 Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-6": https://git.libreoffice.org/core/commit/9ae4fe4e9ec27ef632fb73004db90ec86b1cb6b6 tdf#157465: getBytes may trigger an exception with hsql It will be available in 7.6.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |