Ask Your Question
1

Attempting to connect to Firebird server from Ubuntu

asked 2019-12-29 09:25:06 +0200

Mikcaau gravatar image

updated 2020-01-05 05:12:06 +0200

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.

edit retag flag offensive close merge delete

Comments

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

Opaque gravatar imageOpaque ( 2019-12-29 14:26:31 +0200 )edit

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

Mikcaau gravatar imageMikcaau ( 2020-01-01 02:37:17 +0200 )edit

@Mikcaau,

What exactly have you placed in Class Path?

Ratslinger gravatar imageRatslinger ( 2020-01-05 04:48:55 +0200 )edit

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

Mikcaau gravatar imageMikcaau ( 2020-01-05 04:57:10 +0200 )edit

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.

Ratslinger gravatar imageRatslinger ( 2020-01-05 06:10:35 +0200 )edit

How can I remove SNAP?

Mikcaau gravatar imageMikcaau ( 2020-01-05 07:06:07 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-01-05 11:50:28 +0200

Mikcaau gravatar image

Removed SNAP (https://askubuntu.com/questions/10359...) and DB connection works perfectly and computer is faster overall Thanks to all for advice

Mick

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-29 09:25:06 +0200

Seen: 194 times

Last updated: Jan 05 '20