I am mostly a Windows user, but please note the bash sql script also contains a checkJavaLocation function which, in certain configurations, overrides the checkADE settings.
I recall there was a big change in checkJavaLocation between sqlcl versions 17.4 and 18.1. Not sure which version worked for you prior to 19.4 not working, but it would be good to diff the sql scripts and see what changed.
Thank you for the comment, I have never used or installed SQLcl before 19.4, this is the first time I'm using/testing it.
1 пользователь считает эту информацию полезной
Is you JAVA_HOME correct like that?
I was successful like that:
Commenting this line in function checkADE in "sql":
(this path contains links to latest installed java version)
[cormaco@vbox1 ~]$ sql /nolog SQLcl: Release 19.4 Production auf Di Mai 12 07:41:36 2020 Copyright (c) 1982, 2020, Oracle. All rights reserved. Alle Rechte vorbehalten. SQL> show java Java Detail ----------- java.home= /usr/lib/jvm/java-1.8.0-openjdk-126.96.36.199.b07-1.el6_10.x86_64/jre
Everybody, this works now after comment below from sqlcl/bin/sql file.
> # if [ -d "$SQL_HOME/../jdk/jre/" ]; then
> # JAVA_HOME="$SQL_HOME/../jdk/jre/"
> # PATH="$JAVA_HOME/bin:$PATH"
> # JAVA="$JAVA_HOME/bin/java"
> # fi