RE: SQLCl: problems with describe are back

It needs to work on all versions, hence me filing the bug.

Happy to spoil you and others, hopefully with fewer exceptions going forward!

Jeff

From: Mladen Gogala <gogala.mladen_at_gmail.com> Sent: Wednesday, February 19, 2020 8:01 PM To: Jeff Smith <jeff.d.smith_at_oracle.com>; oracle-l_at_freelists.org Subject: Re: SQLCl: problems with describe are back

Hi Jeff!

You spoiled me with this marvelous tool. However, I made a mistake. Since this is 12.2 database, which comes with SQLCl preinstalled, I used the wrong version. The original version, shipped with 12.2 on Linux does not have  a problem with describe. Version 19.4 unfortunately still does have a problem:

SQLcl: Release 19.4 Production on Wed Feb 19 19:53:33 2020

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

Last Successful login time: Wed Feb 19 2020 19:53:33 -05:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.6.0.0.0

SQL> desc v$system_event;
Feb 19, 2020 7:53:46 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run SEVERE: java.util.regex.Matcher.appendReplacement(Matcher.java:857) java.lang.IllegalArgumentException: Illegal group reference

    at java.util.regex.Matcher.appendReplacement(Matcher.java:857)
    at java.util.regex.Matcher.replaceAll(Matcher.java:955)
    at java.lang.String.replaceAll(String.java:2223)
    at oracle.dbtools.raptor.newscriptrunner.commands.DescribePrep.compileViewIfRequired(DescribePrep.java:1391)

Interestingly enough, the exception doesn't break the connection.

Regards

On 2/19/20 1:59 PM, Jeff Smith wrote:

Thanks for the note, I'll get this logged and fixed.  
Jeff

--

Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 20 2020 - 14:15:59 CET