SQLcl 24.3 java issues
Date: Thu, 7 Nov 2024 14:56:26 -0800
Message-ID: <CAKsxbLqnMvZr2EUEe=_X9xsanQP6wC-gpTp6jGzA6UJn2EPAsQ_at_mail.gmail.com>
I am able to connect to my database with SQLCL 24.3 but as soon as I execute any query I get this error message and it disconnects me. Windows 11, running 21c client, not instance client. Any one encounter this before?
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)
I've also tried regular Java from Oracle and get the same result.
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
Also I had to copy ojdbc11.jar from my 21c client folder over to my
c:\sqlcl\lib folder. Before I did that I would get this while trying to
connect. Doing that solved that issue.
Error Message = no ocijdbc23 in java.library.path:
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 07 2024 - 23:56:26 CET