I need to edit the content of a MDB file under Debian Linux 12 with LibreOffice 25.2.
I tried to use the solution mentioned in the documentation (relying on UCanAccess) without success: I added the loader folder containing ucanload.jar into the classpath of the JRE and I obtained the error message “Impossible to load the JDBC driver” when I clicked on the button “Test the class”:
Exception in thread "Thread-0" java.lang.NoClassDefFoundError: net/ucanaccess/jdbc/UcanloadDriver
Caused by: java.lang.ClassNotFoundException: net.ucanaccess.jdbc.UcanloadDriver
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:525)
Unlike what the documentation advises, I added ucanload.jar into the classpath instead of its folder, the JDBC driver was successfully loaded, I got rid of the ClassNotFoundException.
I used jdbc:ucanaccess:///home/gouessej/Downloads/KAR.MDB in the jdbc field, but I got the error message “Impossible to establish the connection”.
Then, I tried to use the LibreOffice extension named jdbcDriverOOo, I added the instrumentation JAR manually as my version number of LibreOffice is below 25.8 and I got the error message “Impossible to establish the connection”. I entered the URL ///home/gouessej/Downloads/KAR.MDB for the file /home/gouessej/Downloads/KAR.MDB, the log shows that this extension uses it to create the JDBC URL xdbc:ucanaccess:///home/gouessej/Downloads/KAR.MDB. OpenJDK 21.0.9 (the JDK, not only the JRE) is installed on this machine, I tried with a JRE too.
How can I solve the problem? In my humble opinion, there’s at least one trivial documentation bug to solve.