Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
sqlcl v18.3.0, 18.2.0 cannot identify jre

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