Re: SQLcl 24.3 java issues

On Thu, 2024-11-07 at 14:56 -0800, Jeff Chirco 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.ja
> > va:212)
> > at oracle.dbtools.raptor.utils.NLSUtils.format(NLSUtils.java:187)
> > at
> > oracle.dbtools.raptor.format.ANSIConsoleFormatter.printColumn(ANSIConso
> > leFormatter.java:168)
> > at
> > oracle.dbtools.raptor.format.ResultSetFormatterWrapper.print(ResultSetF
> > ormatterWrapper.java:280)
> > at
> > oracle.dbtools.raptor.format.ResultSetFormatterWrapper.print(ResultSetF
> > ormatterWrapper.java:228)
> > at
> > oracle.dbtools.raptor.format.ResultsFormatter.print(ResultsFormatter.ja
> > va:519)
> > at
> > oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.j
> > ava:137)
> > at
> > oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.j
> > ava: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(ScriptR
> > unner.java:249)
> > at
> > oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStored
> > Context(ScriptRunnerContext.java:833)
> > at
> > oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.jav
> > a: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.ja
> > va: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(BuiltinClass
> > Loader.java:641)
> > at
> > java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Cla
> > ssLoaders.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:

That must be some Winduhs stuff:

gogala_at_umajor:~$ sql scott/tiger_at_l21c

SQLcl: Release 24.3 Production on Thu Nov 07 21:28:49 2024

Copyright (c) 1982, 2024, Oracle. All rights reserved.

Last Successful login time: Thu Nov 07 2024 21:28:50 -05:00

Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.16.0.0.0

SQL> select ename,job,sal,dname
  2* from emp e join dept d on (e.deptno=d.deptno);

ENAME JOB SAL DNAME _________ ____________ _______ _____________

CLARK     MANAGER         2450 ACCOUNTING    
KING      PRESIDENT       5000 ACCOUNTING    
MILLER    CLERK           1300 ACCOUNTING    
JONES     MANAGER         2975 RESEARCH      
FORD      ANALYST         3000 RESEARCH      
ADAMS     CLERK           1100 RESEARCH      
SMITH     CLERK            800 RESEARCH      
SCOTT     ANALYST         3000 RESEARCH      
WARD      SALESMAN        1250 SALES         
TURNER    SALESMAN        1500 SALES         
ALLEN     SALESMAN        1600 SALES         
JAMES     CLERK            950 SALES         
BLAKE     MANAGER         2850 SALES         
MARTIN    SALESMAN        1250 SALES         

14 rows selected.

Elapsed: 00:00:00.118
SQL>
>

I am also using SQLCl 24.3 but it's not Winduhs:

gogala_at_umajor:~$ cat /etc/redhat-release Fedora release 41 (Forty One)
mgogala_at_umajor:~$

--
http://www.freelists.org/webpage/oracle-l