Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
sqlcl Ctrl+C handler

Hello,
there is a difference in handling Ctrl+C keyboard signal between older and new sqlcl versions.
Now pressing Ctrl+C ends sqlcl tool. In earlier versions pressing Ctrl+C didn't terminate sqlcl tool.
Could you bring the old behaviour back ? I think it was better before, it was consistent with sqlplus in unix / linux Ctrl+C - as it never close the tool, but only breaks the line.
Or maybe there is a way to customise the Ctrl+C handling in sqlcl via some kind of parameter / settitng ?
New versions:
C:\Users\user>sql /nolog
SQLcl: Release 18.4 Production on Wt lut 26 01:21:49 2019
Copyright (c) 1982, 2019, Oracle. All rights reserved.
01:22:31 @>version
Oracle SQLDeveloper Command-Line (SQLcl) version: 18.4.0.0
01:22:50 @>^C
C:\Users\user> ---------> CTRL+C ends sqlcl program
Old version:
C:\Users\user>sql /nolog
SQLcl: Release 17.3.0 Production on Wt lut 26 01:23:18 2019
Copyright (c) 1982, 2019, Oracle. All rights reserved.
01:23:19 @>version
Oracle SQLDeveloper Command-Line (SQLcl) version: 17.3.0.256.1818
01:23:22 @>
01:39:19 @>
<<pressing Ctrl+C here>
01:39:20 @> ---> CTRL+C doesn't end sqlcl program
Piotr
Answers
-
Yeah, testing on Windows, the change in behavior occurred in release 18.2
-
20.3 problem again.
C:\>sql /nolog
Picked up JAVA_TOOL_OPTIONS: -Dnashorn.args=--no-deprecation-warning
SQLcl: Release 20.3 Production on вт нояб. 24 00:33:55 2020
Copyright (c) 1982, 2020, Oracle. All rights reserved.
SQL> ^C
C:\>
Pressing ctrl-c while running query aborts sql.exe, but sql is still active on the server.
C:\>java -version
Picked up JAVA_TOOL_OPTIONS: -Dnashorn.args=--no-deprecation-warning
java version "11.0.9" 2020-10-20 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.9+7-LTS)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.9+7-LTS, mixed mode)
-
Also an issue with sqlplus as I detailed in https://community.oracle.com/tech/developers/discussion/4174536/oci-behaviour-of-12c-dedicated-server-process-to-a-client-ocibreak-call#latest
No answers as to why this behaviour is now different.