DuckDB (https://duckdb.org/) offers a JDBC-connection to connect to an existing DuckDB or will create a DB in memory. Download https://repo1.maven.org/maven2/org/duckdb/duckdb_jdbc/0.10.1/duckdb_jdbc-0.10.1.jar to connect. Put this file in class path of LO. Class is org.duckdb.DuckDBDriver. Write in jdbc-connection 'duckdb:'. This would run a DuckDB in memory. You could test the class - works. You could test the connection - works. You could try to open tables folder and get Invalid Input Error: Unrecognized configuration property "Type" at /home/buildslave/source/libo-core/connectivity/source/drivers/jdbc/Object.cxx:173 Same driver runs without any problem together with DBeaver. So this one seems to be a special buggy behavior of LO. See: https://ask.libreoffice.org/t/input-on-establishing-base-jdbc-connection-to-duckdb-on-windows-10/104331 My System: OpenSUSE 15.6 64bit rpm Linux, LO 24.2.2.2
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.
Created attachment 195374 [details] trino jdbc
Same bug with Trino jdbc look at the .png