Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to remove warning about history log?

Matej D.Oct 9 2023

Oracle SQLDeveloper Command-Line (SQLcl) version: 23.2.0.0 build: 23.2.0.178.1029, Windows 11 22H2, Java 19

Every time sqlcl is started I get a warning about the history log:

C:\SQLcl\23.2\bin>sql.exe /nolog
lis 09, 2023 10:57:33 AM org.jline.utils.Log logr
WARNING: Failed to save history
java.nio.file.FileAlreadyExistsException: C:\Users\…..\AppData\Roaming\sqlcl\history.log
at java.base/sun.nio.fs.WindowsException.translateToIOException(WindowsException.java:87)
at java.base/sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:103)
at java.base/sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:108)
at java.base/sun.nio.fs.WindowsFileSystemProvider.newByteChannel(WindowsFileSystemProvider.java:236)
at java.base/java.nio.file.Files.newByteChannel(Files.java:380)
at java.base/java.nio.file.Files.createFile(Files.java:658)
at oracle.dbtools.common.utils.FileUtils.openSecureFile(FileUtils.java:911)
at oracle.dbtools.raptor.console.impl.HistoryLogs.write(HistoryLogs.java:72)
at oracle.dbtools.raptor.console.impl.SqlclHistory.internalWrite(SqlclHistory.java:738)
at oracle.dbtools.raptor.console.impl.SqlclHistory.getHistoryFilePath(SqlclHistory.java:426)
at oracle.dbtools.raptor.console.impl.SqlclHistory.load(SqlclHistory.java:148)
at oracle.dbtools.raptor.console.impl.SqlclHistory.reader(SqlclHistory.java:76)
at oracle.dbtools.raptor.console.impl.SqlclConsole.<init>(SqlclConsole.java:152)
at oracle.dbtools.raptor.console.impl.SqlclConsole$SqlclConsoleBuilder.build(SqlclConsole.java:96)
at oracle.dbtools.raptor.console.impl.SqlclConsole$SqlclConsoleBuilder.build(SqlclConsole.java:61)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.<init>(SqlCli.java:184)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:349)

Tnx

This post has been answered by Matej D. on Oct 11 2023
Jump to Answer
Comments
Post Details
Added on Oct 9 2023
3 comments
454 views