Forum Stats

  • 3,767,980 Users
  • 2,252,736 Discussions
  • 7,874,399 Comments

Discussions

SQLcl warning with 21.3 does not happen in 21.1 - oracle.dbtools.plusplus.JDBCHelper getOH

Adam vonNieda
Adam vonNieda Member Posts: 115 Bronze Badge
edited Oct 15, 2021 6:20PM in SQLcl

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