I am a new user and want to start a database.
The connection to the external data source could not be established. No SDBC driver was found for the URL ‘sdbc:embedded:hsqldb’. I get this when I try to open a new database. What does it mean?
Edit [Opaque] Made title a summary and put old title’s text to details.
Have you got Java enabled? Please read:
If this is a Linux (Ubuntu-based) system, don’t forget to install the required JDBC driver package as well.
My system is Mac OS 10.15.4. So, I’ll try to install the required JDBC driver package.
@Basin - If you are on macOS - you probably missed to install JDK (and not JRE, which is not sufficient on macOS).
I installed JDK as the article “How to Install Java JRE/JDK” described above. But still get the same error.
I have no problem finding and running an existing database that I’ve created with, for example, Microsoft Access. I was trying to create a New Database from Base.
I use Actual Technologies for an ODBC driver. http://www.actualtech.com
They also have other drivers as well for
Access
Open Source Databases
Oracle
SQL Server.
Would one of these work with Base? I have contacted them but have not yet heard back from them.
installed JDK as the article “How to Install Java JRE/JDK” described above.
LibreOffice -> Preferences -> LibreOffice -> Adavanced -> Option: [x] Use a Java runtime environment ?@Basin : Let me guess, are you using LibreOffice Vanilla from the AppStore ?
If so, then you won’t be able to create any embedded hsqldb ODB files, as all Java functionality is deactivated with the LOVanilla app available from the AppStore. It won’t make any difference whether you have installed a JDK or not, the code is simply non-functional with that particular version of LO. Either create an embedded Firebird database (you need to activate the experimental options under LO Preferences), or alternatively, remove LOVanilla and download and install LO from the TDF download website, then activate recognition and selection of the JDK from within LO > Preferences > Advanced.
Re the Actual Technologies Driver, yes, you should be able to setup an ODBC connection using that driver, but it still requires you to have a database source backend, as ODBC is just the technology allowing you to access a database stored elsewhere (file, server, etc).
This error is due to the fact that LibreOffice Base is not running in a Java environment, to do this, you access tools, options and in advanced, enable the checkbox: use a Java runtime environment, the environments you have appear in the box installed on your machine, click on apply and accept; Base and perfect reboots
When I tried to go to tools there is not an options menu item. Only Tools>Customize and there is not an advanced option there.
@Basin - people here are used to Tools -> Options since most of 'em use Linux or Windows. Whenever you see anybody using this path translate to LibreOffice -> Preferences, if you are on macOS.
On linux, make sure this package is installed, it doesn’t seem to be automatic: libreoffice-sdbc-hsqldb.
I have a mac os 10.15.4
I went to Java to download but it said would not work with this updated version
I am on windows 10 64 bits with LO 64 bits and have the same problem.
I have two jre installed, when I choose to use jre 10, LO says it is defective, however when choose jre 8 it is then accepted for use!
Try to download and install either Oracle JDK 17 or Temurin OpenJDK 18.
Both of these are recognized by current production releases of LibreOffice.
Please bear in mind that if you are using Collabora Office from the Appstore, this will not work with any Java environment.