Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

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!

sqlcl 17.4, no log4j2 configuration file

LiturgistMar 30 2018 — edited Apr 3 2018

C:>java --version

java 10 2018-03-20

Java(TM) SE Runtime Environment 18.3 (build 10+46)

Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10+46, mixed mode)

C:>where sql

C:\Oracle\sqldeveloper-17.4.1.054.0712-no-jre\sqldeveloper\sqldeveloper\bin\sql

C:\Oracle\sqldeveloper-17.4.1.054.0712-no-jre\sqldeveloper\sqldeveloper\bin\sql.bat

C:\Oracle\sqldeveloper-17.4.1.054.0712-no-jre\sqldeveloper\sqldeveloper\bin\sql.exe

C:>sql.exe dat***/********@ODB******

SQLcl: Release 17.4.0 Production on Fri Mar 30 10:38:09 2018

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to sh

ow Log4j2 internal initialization logging.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Similar, but different, result in sqldeveloper-17.3.1.279.0537-no-jre

C:>sql.exe dat***/********@ODB******

SQLcl: Release 17.3.0 Production on Fri Mar 30 11:55:55 2018

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

log4j:WARN No appenders could be found for logger (org.apache.http.client.protocol.RequestAddCookies).

log4j:WARN Please initialize the log4j system properly.

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Comments
Post Details
Added on Mar 30 2018
3 comments
719 views