Hi Mark,

Your suggestion doesn't work for me. The error message is:

A driver is not registered for the URL firebirdsql:oo://<server>//<path_to_database.fdb>.

Best regards,

Peter

 

On 9-5-2019 14:01, Peter Milesson miles@... [firebird-support] wrote:
> Hi folks,
>
> I have used LibreOffice base with the JDBC-connector. Install Java, and
> then install the required components of Jaybird (jaybird-full-3.0.5.jar,
> connector-api-1.5.jar, antlr4-runtime-4.7.1.jar). Jaybird can be
> downloaded from http://firebirdsql.org/en/jdbc-driver/. I use OpenJDK 8
> for Windows from Azul systems (https://www.azul.com/downloads/zulu/).
> It's free to download and use, compared to Oracle Java. It works well
> enough.
>
> Register the .jar files in LibreOffice, Tools->Options->Advanced->Class
> Path and use Add archive.
>
> When setting up the Base Databse for JDBC, the following must be entered:
>
> Data source: firebirdsql://<server>//<path_to_file.fdb>
> JDBC driver class: org.firebirdsql.jdbc.FBDriver

It would be better to use firebirdsql:oo://<server>//<path_to_file.fdb>

The firebirdsql:oo: sub-protocol addresses some problem with metadata
when used with LibreOffice/OpenOffice.org.

Mark
--
Mark Rotteveel