For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Can you try with latest version of 1.8 java
Java SE Development Kit 8 - Downloads
#echo $JAVA_HOME
/u01/orabin/system/sqlcl/jdk_8u162/jdk1.8.0_162
#which java
/u01/orabin/system/sqlcl/jdk_8u162/jdk1.8.0_162/bin/java
#java -version
java version "1.8.0_162"
Java(TM) SE Runtime Environment (build 1.8.0_162-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.162-b12, mixed mode)
#/u01/orabin/system/sqlcl/dbtools-sqlcl-18.1.0/bin/sql
Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]
at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)
at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)
at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)
at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)
at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)
I do not get the "Access is denied"
I'm getting the same issue with sql 18.1.1 and java 1.8.0.72.
sql
java version "1.8.0_172"
Java(TM) SE Runtime Environment (build 1.8.0_172-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode)
Steve
I´ve opened a SR and the engineer confirmed that there is an issue with jline.jar in 18.1 version.
Workaround: replace jline.jar from 18.1 by the one provided by 17.4
The bug number is 28086841: SQLCL COMMAND FAILS TO START WITH ERROR JANSI (NOT FOUND IN JAVA.LIBRARY.PATH)
According to the engineer this bug should be fixed in upcoming 18.2 release
issue not fixed in 18.2
bug note is now public and it says fixed in 18.3
issue not fixed in 18.3 either
Yep, same problem in 18.3.0.259.2029
(Solaris 10)
unsupported major.minor version 52.0
Java(TM) SE Runtime Environment (build 1.8.0_172-b25)
Java HotSpot(TM) 64-Bit Server VM (build 25.172-b25, mixed mode)