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 [ERROR] Failed to construct terminal; falling back to unsupported

zangbotApr 10 2018 — edited Aug 16 2018

sqlcl 18.1.0 [ERROR] Failed to construct terminal; falling back to unsupported

occurs when TERM=xterm-256color.  sqlcl does start, but keystrokes at password prompt are shown as clear text.  If I set TERM=xterm-color it seems to work OK.

[mcochran@mdclnx02 ~]$ cat /etc/fedora-release

Fedora release 27 (Twenty Seven)

[mcochran@mdclnx02 ~]$ uname -r

4.15.14-300.fc27.x86_64

[mcochran@mdclnx02 ~]$ java -version

openjdk version "1.8.0_162"

OpenJDK Runtime Environment (build 1.8.0_162-b12)

OpenJDK 64-Bit Server VM (build 25.162-b12, mixed mode)

[mcochran@mdclnx02 ~]$ echo $TERM

xterm-256color

[mcochran@mdclnx02 ~]$ /opt/sqlcl-18.1.0/sqlcl/bin/sql -version

[ERROR] Failed to construct terminal; falling back to unsupported

java.lang.NumberFormatException: For input string: "0x100"

    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

    at java.lang.Integer.parseInt(Integer.java:580)

    at java.lang.Integer.valueOf(Integer.java:766)

    at jline.internal.InfoCmp.parseInfoCmp(InfoCmp.java:59)

    at jline.UnixTerminal.parseInfoCmp(UnixTerminal.java:242)

    at jline.UnixTerminal.<init>(UnixTerminal.java:65)

    at jline.UnixTerminal.<init>(UnixTerminal.java:50)

    at jline.NoInterruptUnixTerminal.<init>(NoInterruptUnixTerminal.java:24)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

    at java.lang.Class.newInstance(Class.java:442)

    at jline.TerminalFactory.getFlavor(TerminalFactory.java:211)

    at jline.TerminalFactory.create(TerminalFactory.java:102)

    at jline.TerminalFactory.get(TerminalFactory.java:186)

    at jline.TerminalFactory.get(TerminalFactory.java:192)

    at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.<init>(DbtoolsConsoleReader.java:283)

    at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.<init>(DbtoolsConsoleReader.java:238)

    at oracle.dbtools.raptor.console.SQLPlusConsoleReader.<init>(SQLPlusConsoleReader.java:35)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startConsole(SqlCli.java:246)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.<init>(SqlCli.java:221)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:435)

SQLcl: Release 18.1.0.0 Production

[mcochran@mdclnx02 ~]$ TERM=xterm-color; /opt/sqlcl-18.1.0/sqlcl/bin/sql -version

SQLcl: Release 18.1.0.0 Production

[mcochran@mdclnx02 ~]$

Comments

Post Details

Added on Apr 10 2018
3 comments
1,934 views