Re: SQLcl 24.3 java issues

Yesterday I found out after trying to use with SQL Client 21 and SQLDeveloper 24 it showed weird results on editor. Then I switched to use SQL Client 23 it worked fine.

HTH
Karth

Sent from my IPhone

> On Nov 7, 2024, at 5:58 PM, Jeff Chirco <backseatdba_at_gmail.com> wrote:
>
> 
> 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