After configuring a BASE JDBC connection file to DuckDB as DuckDB_JDBC.odb, the following error results:
The connection to the data source “DuckDB_JDBC” could not be established.
Invalid Input Error: Unrecognized configuration property “Type”.
[NB: searched for, but did not succeed in locating, a translation key of Base or LO error messages, to better diagnose which configuration setting the word ‘Type’ refers to in this error message.]
The .odb connection file was configured as follows:
- ‘Connect to an existing database’ → JDBC;
- Entered the DuckDB connection string syntax as jdbc:
duckdb:C:\Users\Me\Documents\MyDuckDBdatabase.dband alternately attempted same without the .db extension - Entered JDBC driver class as
org.duckdb.DuckDBDriver. NB: Test Connection button returns ‘The JDBC driver was loaded successfully.’ - Skipped entry of User Name as not required by DuckDB. NB: Connection Test button returns ‘The connection was established successfully.’
- Save file as DuckDB_JDBC.odb. Close LibreOffice.
- Re-launch the .odb file. Base opens with ‘Forms’ option selected on left. When attempting to select ‘Tables’ option, Base returns the error pop-up:
The connection to the data source “DuckDB_JDBC” could not be established.
Invalid Input Error: Unrecognized configuration property “Type”.
NB: When attempting to manually configure the .odb file using Edit->Databases->Connection Type, the ‘Enter DBMS/driver-specific connection string here’ field is empty. Re-entering the connection string, hitting ‘Finish’ to exit the dialogue, and re-opening the dialogue, the field is once again empty.
NB: in Edit->Databases->Properties, the same setting (DBMS connection string) shows as set correctly, and this persists after closing and reopening the dialogue.
NB: Confirmed that database and the single table it contains exist by via successful DuckDB cli query and confirmed JDBC functioning correctly via successful DBeaver JDBC connection to the target DuckDB database and table using same .jar.
LO Version: 7.6.6.3 (X86_64) / LibreOffice Community
Windows 10.0
Java: (LO Tools->Options->Advanced): Java Runtime Environment Oracle 17.0.7 64 bit. NB: java version selection toggle button is selected.
Class Path populated with path to DuckDB .jar at: C:\Users\Me\AppData\Local\DuckDB\DuckDB Java 0.10.1\duckdb_jdbc-0.10.1.jar
DuckDB .jar downloaded as:
https://repo1.maven.org/maven2/org/duckdb/duckdb_jdbc/0.10.1/duckdb_jdbc-0.10.1.jar
Database created with DuckDB v0.10.1 CLI version.
Edit to add more information:
Fiddling around with the setting under Edit->Databases including the Advanced Settings toggles, it was possible to use Tools->SQL to execute SELECT * FROM table LIMIT 10; and this returned the expected result. Unfortunately which settings led to this isn’t clear, and it was a one-moment event that is proving very difficult to replicate.