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: 18.104.22.168.0+
LibreOffice/Tools/Options/Advanced/Java = Java Private Build Version 11.0.5
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:(
Java is installed in /snap/libreoffice/163/usr/lib/jvm and not in /usr/lib/jvm which seem to be standard.