Using the Jaybird jdbc driver 2.2.5 (or 2.2.4), it is impossible to connect to an existing fdb file on OSX from LibreOffice. Using these instructions : http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase with : URL connection string : jdbc:firebirdsql:oo://localhost/path/to/test.fdb?defaultHoldable fails to connect. The driver gets loaded when tested : org.firebirdsql.jdbc.FBDriver but when attempting to open a table, enter user and password (system defaults) the following error is displayed : Connection to "Jaybirdtest" datasource impossible. Can not establish connection to external datasource. An unknown error has occurred. The driver is probably missing.
Note that I have tried both adding the Jar to the classpath, or simply adding the folder containing all the jaybird Jars, but the result is the same.
As Robert has reported success with the jdbc driver on Linux, this is probably OSX specific
Regression over LO 3672 where the jaybird 224 Java 1.6 driver functions
Adding Stephan, as this looks to be a Java 1.8 support problem
Tested on OSX 10.10 There is something very weird going on with Java classpath management. As I mentioned above, I managed to create a working ODB with LO 3672, which links to the 1.6 JDK jaybird 224 driver in the classpath. Note that LO 3672 recognises that JDK 1.6 is installed in the Java preferences. However, I can also successfully open this same file in LO 4322, which not only does not reference the 1.6 224 jaybird driver, but additionally only recognises a 1.80_25 system JDK.
Note that my initial attempts on LO 4322 to create and connect use the 1.8 jdbc drivers - unfortunately, these are the ones that a user will logically take with an installed 1.8 JDK
After much trial and tribulation, finally resolved this so closing as wfm