I run Base on a Windows laptop and there it functions well. I also have it installed on my Desktop under Ubuntu MATE (20.4). There, as soon as I try to access anything in Base, I get the following error message (first part translated from Swedish):
“Unable to connect to the external data source. Could not find any SDBC-driver for the URL ‘sdbc:embedded:hsqldb’ at /build/libreoffice-|K8RQh/libreoffice-7.5.1-rc2/connectivity/source/commontools/dbexception.cxx:413”
What is the problem and how can I solve it?
Ubuntu doesn’t install all packages of LO by default. Have a look at the available packages of LO and install all of this packages.
One problem is Java. Several maintainers for linux avoid to install Java and therefore remove the dependencies to Java. As the default database for LibreOffice is written in Java itself, it is often not included.
.
To fix, check first, if your LibreOffice is installed as snap. You can not extend a snap with “external” .deb-packages via apt.
Maybe use an installed LibreOffice instead of snap.
.
Maybe using another database, wich doesn’t require Java will work. But the default report-engine in LibreOffice is also written in Java and you will need to avoid jdbc-connections…
I tried to uninstall Base, and reinstalled it from the repository. The only effect was that I got a slightly newer version of LO. The problem remains.
Have a look at Tools → Options → LibreOffice → Advanced. Is any Java runtime environment available there?
I first assumed that that the problem was that the JDK was not installed. I installed it but it made no difference.I have two versions of JRE installed (Ubuntu and Oracle). It seems that the Oracle version is the one running right now.
What happens if you run
sudo apt install libreoffice-base
I got the following message: "libreoffice-base is already the newest version (4:7.6.7-0ubuntu0.20.04.1-lo1). Then comes a long list of packages that have been automatically installed and are no longer necessary. The problem remains.
Can you locate the database driver hsqldb.jar? Mine is /opt/libreoffice24.2/program/classes/hsqldb.jar. Your installation directory might be in /usr/lib/.
No, that is not there.
Have a look here: HSQLDB and LibreOffice on Ubuntu.
Seems it isn’t installed complete, because “Base” could also connect to any other database. So the packages from Ubuntu don’t install HSQLDB by default. Might be also Firebird is missing.
On my Ubuntu-PC, additional packages for the distributed Debian packages are:
libreoffice-base
libreoffice-base-drivers
libreoffice-sdbc-hsqldb
RobertG
Have a look here: [HSQLDB and LibreOffice on Ubuntu ]
This Seems to have solved the problem. Ass far as I can see Base now works as it should. A great thank you for the help.