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 [email protected] [firebird-support] <[email protected]> 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 [email protected] > [firebird-support] wrote: > > > > On 9-5-2019 14:01, Peter Milesson [email protected] [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/ > <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 > > > >
