Summary: | Database Connection: JDBC-Connection with DuckDB fails | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Robert Großkopf <robert> |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | ||
Priority: | medium | ||
Version: | 24.2.2.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Robert Großkopf
2024-04-05 14:06:13 UTC
This error also results on Windows 10, and when setting the JDBC connection to an pre-existing and persistent DuckDB database, eg: `duckdb: C:\Users\Me\Documents\my_database.db` Confirming also with: Version: 7.6.4.1 (AARCH64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 8; OS: Mac OS X 14.4.1; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded In many ways, the behaviour is similar to using SQLite. An in memory database can be created and using Tools > SQL allows you to create a table and insert test data (e.g. using the statements from https://duckdb.org/docs/api/java.html) However, it is impossible to display any of the database objects, use queries, use the wizards, etc. For example, trying a query via the SQL query option leads to an error that displays Could not load content of data prepareStatement Turning on/off the design mode leads to the following error: The database contains neither a table nor a query named "items". Confirming FWIW, when I unload, and the reload the ODB file, I see exactly the same message as @Robert. "getTypeInfo" not supported in JDBC driver, see: https://github.com/duckdb/duckdb-java/blob/main/src/main/java/org/duckdb/DuckDBDatabaseMetaData.java Now I don't know if having this method implemented in JDBC is mandatory for LO or if we could find a way to make it optional. |