SQL Workbench/J fails to start when java 9-ea is present

[Vladimir Sitnikov]

$ echo $JAVA_HOME

/Library/Java/JavaVirtualMachines/jdk1.8.0_66.jdk/Contents/Home

$ /Applications/SQLWorkbenchJ.app/Contents/MacOS/JavaAppLauncher

*** Cannot run this application ***

SQL Workbench/J requires Java 8, but only 9-ea was found

If you do have Java 8 installed, please point JAVA_HOME to the location of your Java 8 installation.

or refer to the manual for details on how to specify the Java runtime to be used.

Can SQL Workbench/J support java 9 as well?

[Austin Arbor]

I had the same issue and found the cause to be due to lines 72-74 of WbStarter.java which parses the java version incorrectly for java 9 versions (see http://openjdk.java.net/jeps/223).  I'm not sure why the system property "java.version" is being set to 9-ea, since the application is getting launched by the java8 JRE, but either way, I have let the support team know and hopefully it will get integrated into the next release. For now, I run the command "java -jar /Applications/SQLWorkbenchJ.app/Contents/Java/sqlworkbench.jar </dev/null &>/dev/null &" and it launches correctly.

[Nick Reddel]

You can specify the JVM for the app like this:

ln -s /Library/Java/JavaVirtualMachines/jdk1.8.0_152.jdk /Applications/SQLWorkbenchJ.app/Contents/PlugIns/jdk1.8.0_152.jdk

and edit /Applications/SQLWorkbenchJ.app/Contents/Info.plist, adding:

<key>JVMRuntime</key>

<string>jdk1.8.0_152.jdk</string>

[James McMurray]

Thanks Nick, this worked perfectly!

[Vicky Raj]

This worked for me as well... Thanks :)