Can't Create Database

When I try to create a db I get this error:The connection to the data source “New Database2” could not be established and SQL Status: HY000, No Java installation could be found. Please check your installation.

I’ve installed JDK 15 twice now too. No problem with writer or calc. At a loss, new today with LibreOffice, any help greatly appreciated.
Kenny

Mac running Catalina V 10.15.7
Java 15.0.1 -x64
LO V7.0.3.1

Hello,

this is bug tdf#135479 - LO Complains about missing JDK when accessing any Java functionality, despite recognizing JDK on macOS under Preferences

See especially comment #9 of the bug report, which states that JDK 12.0.2 is working.

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.

Thanks, but not experienced to try all that

To help others here is what worked for me.
Removed LO, and Java, then
Installed LO 6.4.7, Java 8 Update 271 the ran JDK 15.0.1

Now I’m able to create a data base in base.
Thanks to all for their help.

When I try to uninstall JDK I get this error:
~ % /Library/Java/JavaVirtualMachines/
zsh: permission denied: /Library/Java/JavaVirtualMachines/
~ %

And I know I’m logged in as with Admin right. Any suggestions?

EDIT: I was able to get LO 6.4 to work great so problem solved.

Are you executing:

  1. cd /Library/Java/Java VirtualMachines/
  2. sudo rm -r <whatever_the_current_jdk_is_here> (check using ls -l)

?

No, I didn’t use cd/, when I did use it I got “no such file or directory”. So even though I installed twice it isn’t there. So I guess I have to look when it got installed next?

Sorry cd /Library/Java/JavaVirtualMachines/ (had a blank in my command)

I didn’t use blank in JVM, thanks

Do I need to create a folder Java off the Library folder and place downloaded JDK file there before installing?

See my answer which has step: sudo mkdir -p /Library/Java/JavaVirtualMachines/ (which assures that it is available, if it is not there. But you told that you have installed Java 15.0.1, which is in contradiction to your last statements that the directory doesn’t exist - I can’t see your system; I need to rely on your statements).

Just noticed that when I use Finder I can see the complete path
Library/Java/JavaVirtualMachine but doesn’t show in Terminal. Could I be doing something incorrect in terminal? Please excuse my confusion this is kinda greek to me.

May be some Apple / macOS security stuff denying Terminal app full disk access.

OK, thanks for the help.