Security is extremely important to us here at Oracle, in fact, maybe it’s the #1 priority as we want to protect your data and by extension, YOU.

So one of our 3rd party libraries had a Cybersecurity Vulnerability pop-up, which necessitated an update for SQLcl.

We’ve updated our Liquibase extension up to version 4.9.1.

And while we were at it, we fixed a few bugs as well – 8 of them for our enhanced Liquibase support in SQLcl!

34049379ON STARTUP GET WARNING ABOUT WINDOWS REGISTRY KEY NOT FOUND
34141455SQLCOMPLETER NO VALIDATION ON POSITION VALUE
34088656ISSUES WITH LB HELP GENOBJECT AND UNTAG
34062379LIQUIBASE INCONSISTENT STATE AFTER PARTIALLY APPLIED CHANGE IN CHANGESET 
34048962LIQUIBASE HELP NOT WORKING
34040532LIQUIBASE SPOOL DOES NOT SAVE THE OUTPUT INTO LOG FILE
34037051ABNORMAL BEHAVIOUR OF UPDATE, ROLLBACKSQL, AND ROLLBACK WITH TRIGGER OBJECT TYPE
SQLcl 22.1.1 Release Notes

You can find SQLcl at the regular places, the Yum repos and OCI will follow shortly as well.

22.1.1 – SQLcl’s latest and greatest.

Meanwhile over on the Oracle Cloud (OCI)

SQLcl in Cloud Shell still remains version 21.4, it’ll be upgraded shortly. When it does, you’ll have to tell OCI that you want to use Java 11 vs 8. 11 is our new minimum version of Java supported for all 22.x releases in Database Tools Land (SQLDev, SQLcl, ORDS…)

To do this –

csruntimectl java list

You’ll get a list of Java Homes available, most likely an 8 (the current default) and an 11.

I want to use Java 11.

By following the docs, I can see the proper command to change the home remains csruntimectl.

csruntimectl java set openjdk-11.0.15

Now we’re all good and set to go.

Speaking of OCI…Console Updates

A few of us noticed a couple of changes today:

  1. Dialog to optionally choose some IT roles you fill, to help shape the console offerings
  2. Service Links on the Get Started Page

What I select in the list of profiles will directly influence what I see in the RECOMMENDED box.

Duh, of course I picked ‘Database Engineer’

I can of course change that by going into Console Settings…

Get suggestions for OCI services based on your career path/job.

Or just using the home page shortcuts, things I’ve used recently before…and yeah, let’s also show off the SSO access to your Autonomous Database via the ADMIN account.

Only a few seconds away from ‘SELECT * FROM…’
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

2 Comments

    • OCI Console? I’ve been quite fond of the ‘bookmarks’ you can permanently pin in your mega menu…

Write A Comment