Ask Your Question

Can't Create Database

asked 2020-12-03 21:29:14 +0200

KAC352 gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-12-06 15:35:09 +0200

KAC352 gravatar image

updated 2020-12-11 18:40:06 +0200

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.

edit flag offensive delete link more


Are you executing:

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


Opaque gravatar imageOpaque ( 2020-12-06 16:24:14 +0200 )edit

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?

KAC352 gravatar imageKAC352 ( 2020-12-07 15:24:00 +0200 )edit

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

Opaque gravatar imageOpaque ( 2020-12-07 15:26:01 +0200 )edit

I didn't use blank in JVM, thanks

KAC352 gravatar imageKAC352 ( 2020-12-07 15:29:31 +0200 )edit

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

KAC352 gravatar imageKAC352 ( 2020-12-07 15:34:17 +0200 )edit

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

Opaque gravatar imageOpaque ( 2020-12-07 15:43:38 +0200 )edit

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.

KAC352 gravatar imageKAC352 ( 2020-12-07 15:48:04 +0200 )edit

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

Opaque gravatar imageOpaque ( 2020-12-07 15:53:32 +0200 )edit

OK, thanks for the help.

KAC352 gravatar imageKAC352 ( 2020-12-08 20:58:43 +0200 )edit

answered 2020-12-03 22:46:48 +0200

Opaque gravatar image

updated 2020-12-03 22:50:19 +0200


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

edit flag offensive delete link more


Thanks, but not experienced to try all that

KAC352 gravatar imageKAC352 ( 2020-12-08 21:00:40 +0200 )edit

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 gravatar imageKAC352 ( 2020-12-09 17:10:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-03 21:29:14 +0200

Seen: 133 times

Last updated: Dec 11 '20