Hi Drew,

What you describe, is exactly how my JDBC connector is set up since ancient times, and what I suggested to the OP. I always use the latest production Jaybird, Java (OpenJDK8) and LibreOffice.

My standard data source is jdbc:firebirdsql://<server>//<path_to_file.fdb>, and driver is org.firebirdsql.jdbc.FBDriver. This works with a local Firebird server under Windows, as well as remote Firebird servers under Linux. Your suggestion does not work with databases on a remote Linux server, only with local databases under Windows.

I use the LibreOffice Base occasionally, and never experienced any problems so far.

Best regards,

Peter

 

Right - not finding the class path.

OK, you will need to tell LibreOffice where that JDBC driver is located first.

To do that:

In LibreOffice select menu Tools->Options

Open the LibreOffice section in the dialog box and select Advanced.

On this dialog along with selecting your flavor of Java you will see three buttons on the right side, one of which is 'Class path'

Click on that and another dialog opens, with three buttons on the right, 'Add Archive', 'Add Folder' and Remove.

I tend to use Add Archive (but Add folder works)

In my case I downloaded jaybird 3.0.5 driver files and put them in a directory /home/drew/firebirdjdbc

In the the dialog I clicked on Add Archive and browsed to that folder and selected.

/home/drew/firebirdJDBC/jaybird-full-3.0.5.jar

Click OK on the dialog, Click Ok on the first dialog.

Libreoffice will prompt you to restart the application for that to take hold, do so.

Now when you create a new Base, connected to an existing database type JDBC

with JDBC driver class: org.firebirdsql.jdbc.FBDriver it will load fine. 

there is button to test the driver before  you save the Base configuration, just to be sure.

Best wishes,

Drew

On Thu, May 9, 2019 at 3:48 PM Peter Milesson miles@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

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 09.05.2019 17:41, Mark Rotteveel mark@... [firebird-support] wrote:

 

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