Attempting to connect to Firebird server from Ubuntu

English
, , , ,
#1

Hi all,
I am attempting to connect to an existing firebird database on a remote server. OS details are
Ubuntu version: Ubuntu 18.04.3 LTS

Java version: openjdk 11.0.5 2019-10-15

OpenJDK Runtime Environment (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04)
OpenJDK 64-Bit Server VM (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04, mixed mode, sharing)

LibreOffice version: 6.3.4.2.0+

LibreOffice/Tools/Options/Advanced/Java = Java Private Build Version 11.0.5
~/snap/libreoffice/163/jaybird-full-3.0.8.jar
Enable experimental features (maybe unstable)

When I use the connect dialog box and set JDBC driver class to org.firebirdsql.jdbc.FBDriver I get the error message “The JDBC driver could not be loaded”. I get this error message for every driver class including “com.sun.star.comp.sdbc.firebird.Driver” which I can see in the Expert Configuration dialog box.

I know that the database exists and I’m able to connect using FlameRobin.

Note that if I click “Class Path…” button again it has forgotten the paths I had already set.

I am sure that the error source is sitting on the chair:(

Mick

Java is installed in /snap/libreoffice/163/usr/lib/jvm and not in /usr/lib/jvm which seem to be standard.

#2

Are you sure, you really clicked the radio button:
JavaRadioButton-2019-12-29-142432.png?

#3

Yes I’ve done that many times. I’ve been trying to get Base working for months now

#4

@Mikcaau,

What exactly have you placed in Class Path?

#5

/home/mick/Documents/Projects/Jaybird-3.0.6-JDK_1.8/jaybird-full-3.0.6.jar

#6

Having re-read you question, have my doubts about using snap versions for this which is the main reason for not addressing this sooner. Have primarily used TDF versions and currently have multiple local DB servers running including Firebird.

Don’t believe I can help further if you are using snap.

#7

How can I remove SNAP?

#8

Removed SNAP (software uninstall - How to remove snap store from Ubuntu? - Ask Ubuntu) and DB connection works perfectly and computer is faster overall
Thanks to all for advice

Mick

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.