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!

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
8 comments
1,153 views