Skip to Main Content
Forums

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 not working properly under cygwin

calinmOct 1 2017 — edited Oct 2 2017

Hi,

The history feature is not working properly under a fresh install of cygwin64  OR cygwin 32 on windows7. Pressing Arrow Up actually moves the cursor up on the screen, instead of displaying the previous line in history. pressing Enter will execute the previous line (the one that was not displayed). 

I find it strange that cygwin is not one of the platforms that was tested thoroughly for sqlcl. I see sqlcl as a tool for people who like command line tools. These people don't use cmd.exe on windows, they use cygwin+bash.

Thanks,

Calin

Comments

Gaz in Oz

You will need to supply more information.

. sqlcl version

  sql -v

  or from within sqlcl

  show version

. How do you start the bash shell?

. copy/paste how you start bash. (xterm emulator? cmd.exe? Conemu64?...)

. copy/paste how you start sqlcl

Basically, to help you, you need to show us what you are doing, not just tell us.

For example, up-arrow works for me on windows 10 with bash 3.1:

F:\Oracle>bash
bash-3.1$ sql gaz/gaz@xe
SQLcl: Release 17.2.0 Production on Mon Oct 02 17:45:15 2017
Copyright (c) 1982, 2017, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 17.2.0.184.0917
SQL> -- pressing up arrow
SQL> show version
calinm

Hi,

I start using the shortcut on the desktop:

C:\cygwin64\bin\mintty.exe -i /Cygwin-Terminal.ico -

$ java -version

java version "1.8.0_131"

echo $TERM

xterm

$ echo $BASH_VERSION

4.3.46(7)-release

After pressing arrow up 4 times, the cursor goes up 4 lines, as seen in the screenshot

pastedImage_0.png

I also tried to start it using cygwin.bat which contains:

@echo off

C:

chdir C:\cygwin64\bin

bash --login -i

this time, arrow up does nothing.

I have nothing in .bash_profile, or any other init scripts.

Thank you,

Calin

1 - 2

Post Details

Added on Oct 1 2017
2 comments
555 views