|Subject||Re: [firebird-support] Connect Libreoffice Base with Firebird|
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.
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->OptionsOpen 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/firebirdjdbcIn the the dialog I clicked on Add Archive and browsed to that folder and selected./home/drew/firebirdJDBC/jaybird-full-3.0.5.jarClick 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 JDBCwith 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.
On Thu, May 9, 2019 at 3:48 PM Peter Milesson miles@... [firebird-support] <email@example.com> wrote:
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>.
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
> 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.