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