"Unable to load Java Runtime Environment" when starting SQLWorkbench/J

Question

I get Unable to load Java Runtime Environment when starting SQLWorkbenchJ.app.

I'm on macOS Catalina 10.15.2, and I installed the app with brew cask install sqlworkbenchj. My JDK 8 is installed using brew install adoptopenjdk8.

How do I solve this problem? SQLWorkbench/J does not provide any other helpful messages, even when I start it with open -a in the Terminal.

score 28 · Accepted Answer · answered Jan 31 '20 at 14:42

28

Luckily I found a hint on SQLWorkbench/J's forum

The fix was to add ...

<key>JVMRuntime</key>
<string>adoptopenjdk-8.jdk</string>

... to /Applications/SQLWorkbenchJ.app/Contents/Info.plist, and create a symlink to JDK8:

ln -s /Library/Java/JavaVirtualMachines/adoptopenjdk-8.jdk /Applications/SQLWorkbenchJ.app/Contents/PlugIns/

Voila!

answered Jan 31 '20 at 14:42

neu242

15,796
20
79
114

6

There is also the "java -jar /Applications/SQLWorkbenchJ.app/Contents/Java/sqlworkbench.jar /dev/null &" option in the same forum: https://groups.google.com/g/sql-workbench/c/cQN_epMyM1M/m/W759i5zxAgAJ – big lep Aug 25 '20 at 21:38
2

This should be the accepted answer for Big Sur and openjdk.jdk. – Tiago Franco Dec 23 '20 at 11:50
1

I had the same problem with JDiskReport and fixed it with your solution. Thanks! – NiMa Thr Apr 15 '21 at 02:01
Provided solution worked also for [ExecuteQuery.app](http://executequery.org) Thanks! – Michał Maciej Gałuszka Oct 22 '21 at 12:36

"Unable to load Java Runtime Environment" when starting SQLWorkbench/J

1 Answers1

Linked