Subject Re: [firebird-support] Connect Libreoffice Base with Firebird
Author Drew Jensen
Post date 2019-05-09T21:23:48Z
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