I just installed Libre and tried to use the database

When I try to create tables it comes up with a message telling me can’t connect to db as no Java installation found. I have ticked the use Runtime environment and the Advanced messages tell me it is already installed. I updtaed the JRE. What is wrong please. tearing my hair out.

Which operating system are you using and if you installed LibreOfffice 32-bit you need a JRE 32-bit as well. And if LibreOfffice is 64-bit you need a JRE 64-bit. And if you are on macOS you need a JDK, and if your are using LibreOffice 7.0.x you need JDK 12.0.2 exactly. That’s why we need a bit more technical information to find your way through that jungle.

My OS is Big Sur. I did instal JDK but it was 15.0.1 so wrong one. I didn’t see 12.0.2 available. So looks like I need to uninstall 15 and get 12? Can you point me to correct page please. I updated my JRE to latest version on offer. 9.0.2. And liber was 64 bit. And Libre office was 7.0.3. Thank you.

Hello to everyone who took the time to answer me. I am so grateful - the instructions for installing version 12 of jdk which Opaque sent me worked and I am now busy testing out the Database app. I was determined I wasn’t going to purchase Access - it is too expensive. thanks a million.

Hello,

according to your info - here is a procedure that worked for me:

Here is a procedure that worked for me to install (and use) 12.0.2:

  • Stop (Quit) LibreOffice
  • Uninstall/Remove your current JDK from /Library/Java/JavaVirtualMachines/
  • Open a Terminal (Launchpad - Search for “Terminal”)
  • cd Downloads
  • curl -O https://download.java.net/java/GA/jdk12.0.2/e482c34c86bd4bf8b56c0b35558996b9/10/GPL/openjdk-12.0.2_osx-x64_bin.tar.gz
  • sudo mkdir -p /Library/Java/JavaVirtualMachines/ (password requied)
  • sudo tar -xvf openjdk-12.0.2_osx-x64_bin.tar.gz -C /Library/Java/JavaVirtualMachines/
  • Start LibreOffice
  • LibreOffice -> Preferences -> LibreOffice > Advanced and check Java/JRE

Hope that helps.

Hello Opaque, I am so grateful - the instructions for installing version 12 of jdk which you sent me worked and I am now busy testing out the Database app. thanks a million.

If the answers works for you, please consider to click the check mark (:heavy_check_mark:) next to the answer. Thanks in advance …