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.

24.3 Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sql/BOOLEAN

Jeff ChircoNov 5 2024

I am able to connect to my database with SQLCL 24.3 but as soon has I execute any query I get this error message and it disconnects me. Please help!

Running java:

openjdk 23.0.1 2024-10-15
OpenJDK Runtime Environment (build 23.0.1+11-39)
OpenJDK 64-Bit Server VM (build 23.0.1+11-39, mixed mode, sharing)

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sql/BOOLEAN
at oracle.dbtools.raptor.nls.OracleNLSProvider.format(OracleNLSProvider.java:212)
at oracle.dbtools.raptor.utils.NLSUtils.format(NLSUtils.java:187)
at oracle.dbtools.raptor.format.ANSIConsoleFormatter.printColumn(ANSIConsoleFormatter.java:168)
at oracle.dbtools.raptor.format.ResultSetFormatterWrapper.print(ResultSetFormatterWrapper.java:280)
at oracle.dbtools.raptor.format.ResultSetFormatterWrapper.print(ResultSetFormatterWrapper.java:228)
at oracle.dbtools.raptor.format.ResultsFormatter.print(ResultsFormatter.java:519)
at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:137)
at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:72)
at oracle.dbtools.raptor.newscriptrunner.SQL.processResultSet(SQL.java:920)
at oracle.dbtools.raptor.newscriptrunner.SQL.executeQuery(SQL.java:822)
at oracle.dbtools.raptor.newscriptrunner.SQL.run(SQL.java:100)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQL(ScriptRunner.java:439)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:249)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:119)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1223)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1401)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:370)
Caused by: java.lang.ClassNotFoundException: oracle.sql.BOOLEAN
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:528)
... 20 more

Added on Nov 5 2024

9 comments

140 views

1 mention