Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

generate-ords-schema NullPointerException

Mikkel SzklanyMay 9 2024

Hi,

I'm trying to export my ORDS schema using Liquibase, but i keep getting a null pointer exception.

The regular DDL files worked just fine, and have seen no other issues when using LB via SQLcl.

This also occurs if i try to export a single ORDS module.

Has any body seen this before?

Database: OCI Autonomous 19c

SQLcl: 24.1.0.0 Build: 24.1.0.087.0929

Java: "22.0.1" 2024-04-16

Connection via Proxy: “set cloudconfig -proxy=localhost:8080 wallet_file.zip"

OS: Windows 11, using the windows command line

The Error
SQL> liquibase generate-ords-schema -debug
/*----------------------------- DISPLAY ARGUMENTS ------------------------------------ */

-------Provided Arguments-------
PARAM EXCLUDE-ENABLE-SCHEMA false
PARAM EXCLUDE-PRIVS false
PARAM LOG false
PARAM DEBUG true
PARAM OVERWRITE-FILES false
---------------------

--Starting Liquibase at 2024-05-09T16:03:32.415582700 (version 4.25.0 #3966 built at 2023-11-10 23:07:29 UTC)
Null Pointer please log a bug.
java.lang.NullPointerException: Cannot invoke "java.lang.Boolean.booleanValue()" because the return value of "oracle.dbtools.raptor.liquibase.core.ActiveCommand.getOptionValue(oracle.dbtools.raptor.newscriptrunner.util.parser.Id)" is null
at oracle.dbtools.raptor.liquibase.generator.SchemaGenerator.getChangeLog(SchemaGenerator.java:484)
at oracle.dbtools.raptor.liquibase.generator.SchemaGenerator.getOrdsSchemaChangeLog(SchemaGenerator.java:790)
at oracle.dbtools.raptor.liquibase.core.CommandGenerator.GenerateOrdsSchemaCommand(CommandGenerator.java:419)
at oracle.dbtools.raptor.scriptrunner.commands.liquibase.LbCommand.handleEvent(LbCommand.java:232)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:447)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:239)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:122)
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:1227)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1405)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:371)

Comments
Post Details
Added on May 9 2024
4 comments
751 views