Forum Stats

  • 3,733,362 Users
  • 2,246,748 Discussions
  • 7,856,667 Comments

Discussions

sqlcl v18.3.0, 18.2.0 cannot identify jre

Illia Baranenko
Illia Baranenko Member Posts: 1
edited October 2018 in SQLcl

having difficulty running sqlcl v18.3.0 and 18.2.0 at Win 2012 standalone server-jre 1.8.0_181, jre 1.8.0_181. JAVA_HOME and PATH are configured. java -version resolves correctly. \sqlcl-18.3.0\bin\sql.exe produces "this application requires a java runtime environment 1.8.0_150". launch4j log has "Resource 1: ..\..\jdk\jre", "Check launcher: c:\tools\sqlcl-18.3.0\bin\..\..\jdk\jre\bin\java.exe (not found)". Is it l4j bug? https://sourceforge.net/p/launch4j/bugs/188/. Any ideas for workaround?

Answers

  • Glen Conway
    Glen Conway Member Posts: 859 Gold Badge
    edited October 2018

    The rules (through SQLcl 17.4) used to be as discussed in , but with the 18.x releases some things have changed as I noted in

    Since I cannot find any SQLcl documentation stating exactly how the JRE is found, and there is no known simple way to force the use of a  specific JRE, we are stuck with playing around.  So, for example, to force SQLcl to startup using a public Java 11 jdk (not jre), I just

    set PATH=set JAVA_HOME=

    then

    sql hr/hr

    (with lots of error messages going to the console, probably because Java 11 is not supported) but then

    show java

    (which sends even more error messages to the console) eventually displays

    Java Detail-----------java.home= C:\Program Files\Java\jdk-11java.vendor= Oracle Corporationjava.vendor.url= http://java.oracle.com/java.version= 11--------------------------------------------------------------------------------os.arch= amd64os.name= Windows 10os.version= 10.0path.separator= ;file.separator= \line.separator=

    ...etc...

    Of course, since I have the latest 1.8.0_181 JRE pushed from Oracle I do not have a problem, this is all hypothetical for me, but users with machines configured for older Java JREs, for whatever reason, really do need guidance from the SQL Developer team.  Just my 2 cents.

Sign In or Register to comment.