Re: sqlcl does not recognize/find my Java installation (Windows)

Ah, thanks.

I started the equivalent to strace on Windows (ProcessMonitor) and it indeed turns out, that sqlcl does not use any of the configuration files that are part of the SQL Developer package.

It's hardcoded to look in the registry (which is no longer populated with newer Java versions) or in jdk\jre.

It does not honor JAVA_HOME or even a java.exe on the path.

With that information I created a symlink to point to a Java installation, and now it works.

Thomas

Maxim schrieb am 10.03.2021 um 16:35:
> Hi, Thomas, i did strace on sql on linux and have seen, that it tries to look up following locations
>
> sqlcl/jre/
> sqlcl/../jdk/jre/
>
> Then i downloaded 11.0.10+9  jre from https://adoptopenjdk.net/releases.html and put it into sqlcl/jre directory
> Then sql throws some java exceptions, but it connects to the database at least (also, no browser pointing to java download), also, i havent modified any environment variables except PATH, maybe it's reason for errors, or, prebuilt jre is missing some modules, i'm by no means java expert (maybe the last  comment on https://github.com/sarxos/win-registry/issues/4 is the reason though)
>
> :\data\utils\oracle\sqlcl\bin>sql scott/*****_at_dev01_h
>
> SQLcl: Release 4.2.0.15.349.0706 RC on Mi. Mõrz 10 16:16:20 2021
>

--
http://www.freelists.org/webpage/oracle-l