Can't Create Database

KAC352 · December 3, 2020, 8:29pm

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

anon73440385 · December 3, 2020, 9:46pm

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.

KAC352 · December 8, 2020, 8:00pm

Thanks, but not experienced to try all that

KAC352 · December 9, 2020, 4:10pm

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.

KAC352 · December 6, 2020, 2:35pm

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.

anon73440385 · December 6, 2020, 3:24pm

Are you executing:

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

?

KAC352 · December 7, 2020, 2:24pm

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?

anon73440385 · December 7, 2020, 2:26pm

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

KAC352 · December 7, 2020, 2:29pm

I didn’t use blank in JVM, thanks

KAC352 · December 7, 2020, 2:34pm

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

anon73440385 · December 7, 2020, 2:43pm

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).

KAC352 · December 7, 2020, 2:48pm

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.

anon73440385 · December 7, 2020, 2:53pm

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

KAC352 · December 8, 2020, 7:58pm

OK, thanks for the help.