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 warning with 21.3 does not happen in 21.1 - oracle.dbtools.plusplus.JDBCHelper getOH

Adam vonNiedaOct 15 2021 — edited Oct 15 2021

Hi folks,
Running SQLcl via Cygwin bash on Windows 10. Just wanted to point this behavior out and see if anyone else has seen something similar / has a workaround. SQLcl still connects and works, just kind of an annoying warning. Seems like there's been a few similar issues in the past.
Cheers, let me know if you have any ideas :)
-Adam
Edit: Happens in Windows CMD as well - Java version is 1.8.0_301
21.1
----
$ /SQLcl/bin/sql /nolog
SQLcl: Release 21.1 Production on Fri Oct 15 13:58:23 2021
Copyright (c) 1982, 2021, Oracle. All rights reserved.
SQL>

21.3
----
$ /SQLcl/bin/sql /nolog
Oct 15, 2021 1:57:11 PM oracle.dbtools.plusplus.JDBCHelper getOH
WARNING: oracle.dbtools.raptor.utils.WindowsUtility.toLines(WindowsUtility.java:157)
java.lang.ArrayIndexOutOfBoundsException: 0
at oracle.dbtools.raptor.utils.WindowsUtility.toLines(WindowsUtility.java:157)
at oracle.dbtools.raptor.utils.WindowsUtility.findValue(WindowsUtility.java:113)
at oracle.dbtools.raptor.utils.WindowsUtility.readString(WindowsUtility.java:77)
at oracle.dbtools.plusplus.JDBCHelper.getOH(JDBCHelper.java:86)
at oracle.dbtools.plusplus.JDBCHelper.isOHReal(JDBCHelper.java:58)
at oracle.dbtools.plusplus.JDBCHelper.doesOHJDBCExist(JDBCHelper.java:110)
at oracle.dbtools.raptor.scriptrunner.cmdline.SQLCliOptions.populateContextWithOptions(SQLCliOptions.java:987)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processOptions(SqlCli.java:287)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.<init>(SqlCli.java:382)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:363)

SQLcl: Release 21.3 Production on Fri Oct 15 13:57:12 2021
Copyright (c) 1982, 2021, Oracle. All rights reserved.
java.lang.ArrayIndexOutOfBoundsException: 0
at oracle.dbtools.raptor.utils.WindowsUtility.toLines(WindowsUtility.java:157)
at oracle.dbtools.raptor.utils.WindowsUtility.findValue(WindowsUtility.java:113)
at oracle.dbtools.raptor.utils.WindowsUtility.readString(WindowsUtility.java:77)
at oracle.dbtools.raptor.utils.TNSHelper.getOracleHome(TNSHelper.java:199)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.initSqlcl(SqlCli.java:255)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:969)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:364)
SQL>

Comments
Post Details
Added on Oct 15 2021
5 comments
134 views