- 3,734,722 Users
- 2,247,033 Discussions
- 7,857,471 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 381K All Categories
- 2.1K Data
- 203 Big Data Appliance
- 1.9K Data Science
- 446.2K Databases
- 220.5K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 507 MySQL Community Space
- 459 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 438 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.4K SQL & PL/SQL
- 20.8K SQL Developer
- 291.3K Development
- 6 Developer Projects
- 117 Programming Languages
- 288.1K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.2K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 138 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 195 Java User Groups
- 22 JavaScript - Nashorn
- Programs
- 182 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]
Hallo,
I tried to upgrade sqlcl from 17.4 to 18.1 on Solaris 11 and I get now the following error:
#export JAVA_HOME=/usr/
#java -version
java version "1.8.0_131"
Java(TM) SE Runtime Environment (build 1.8.0_131-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, 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)
thx
Andreas
Answers
-
Can you try with latest version of 1.8 java
-
#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
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)
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
ORException 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)
java version "1.8.0_172"
Java(TM) SE Runtime Environment (build 1.8.0_172-b25)
Java HotSpot(TM) 64-Bit Server VM (build 25.172-b25, mixed mode)