I did the new database wizard and get this error. I chose all the defaults (two options) and when the database opens I get the above error. The connection to the external data source could not be established. No SDBC driver was found for the url ‘sdbc:embedded:hsqldb’.
I did some searching and I have Java installed 11 and it seems to be working.
I’m using Ubuntu 19.10 with LO 6.3.2.2
D
Hello,
First insure you have the correct Java installed. See → FAQ.
Then verify settings. From menu Tools->Options under LibreOffice->Advanced Use a Java runtime environment needs to be selected. Then in the pane below valid installed version(s) will appear (can have multiple). Insure one is selected - dot is in circle in left column. If none appear you may have incorrect Java installed.
yes, I already did those items (I saw your response on other post). I also changed to firebird that fixed it. Interesting in that the other was default, HSQLDB. I also found I needed to install HSQLDB or something, that which I did. I can’t recall if that fixed it, I’m sure it didn’t.
I’m just concerned that I had to do all that to even get this to work, fresh clean install of LO base and recent upgrade to Ubuntu 19.10, I’ve used base years ago and never had to fiddle this much to get it to even work. With using the HSQLDB I was not able to see or use any wizards, the task area was blank. However, if I use firebird, everything seems to work as normal.
Different LO versions had different default databases. Curently (v6.3.3.x) is HSQLDB. This is mainly due to the number of outstanding Firebird issues and the complexity to get around some of them.
Many different databases you can use do not require Java (with exception of Wizards and Report Builder) - Firebird, MySQL, PostgreSQL and many more.
It is questionable as to what you needed to install (definitely should not be HSQLDB - another could cause problems) since I have been using Base for years without any such problem. Wizards and Report Builder require the installation of a correct JAVA even with Firebird. I suspect you may have this problem if the JAVA situation wasn’t resolved.
There is always the possibility of some corruption in the User Profile. A clean install of LO does not renew/replace/refresh this. To clear see → LibreOffice user profile.
The default installation of LO on Ubuntu does not generally install the required JDBC drivers or Java requirements for Base to function with Java database backends, including the default embedded hsqldb. This is a packaging decision by Ubuntu, not a decision by the LibreOffice project. You need to install these packages separately via the software installer UI, or else do things manually from the command line with apt-get.
libreoffice-sdbc-hsqldb:amd64 1:6.3.2-0ubuntu I installed this and it now works. Do I still need to install the JDBC driver? Which Java requirements or Java database backends would I need?