Both of these releases fall on the ‘minor’ side of the major update vs maintenance updates scale. There are some SIGNIFICANT bug fixes addressed, however.
Significant enough that I think everyone should go and grab this release today.
You can see the full list here, but I’ll cover the highlights –
Bug Fixes of Note
- ERROR IN DATA GRID WITH ORACLE/INSTANT CLIENT
- SQL DEVELOPER CONNECTION TO OCI DATABASE VIA SSH TUNNEL IS INTERMITTENTLY CLOSED
- SSH CONNECTION GET LOST INTERMITTENTLY
- SQLCL FAILS TO LAUNCH FROM CMD WINDOW IN WINDOWS DIST
- BLOCKING UI THREAD ON DATABASE CALL
- ERROR LINE NUMBER DOESN’T SHOW IN ERROR MESSAGE
- MIGRATING SQL SERVER TO AUTONOMOUS DATABASE FAILS
- EXPORT TO XLSX BREAKS WHEN ENCOUNTERING A CLOB COLUMN WITH MORE THAN 32K BYTES
- DATE FORMAT IN EXCEL OUTPUT FROM SQLDEVELOPER DOES NOT MATCH NLS SETTINGS
- JDK 15: ASSERTION ERROR BIND VARIABLE NOT FOUND
- INSIGHT FOR COLUMNS DOESN’T POPULATE EDITOR IF TABLE HAS SCHEMA PREFIX
To summarize, if you were using an older Oracle client, the new JDBC driver was causing havoc on simple things like copy/paste from a grid, SSH connections were unreliable, Excel exports could be busted, and insight wasn’t working if you were using schema prefixes, and last but not least – the UI was getting hung because of some queries blocking the thread.
All bad, all hopefully fixed!
What’s not listed above is the improvements made to the OS X (Mac) distribution.
Better OS X Experience
The SQLDev app has now been properly signed and registered with Apple. No more warning about not being able to open a ‘malicious’ file.
So, you won’t need to go into your system preferences and make an exception for SQL Developer to open it anymore.
You wil still need to tell your Mac it’s ok to open an application you downloaded over the Internet.
And, you need to make sure you have Java 8 or Java 11 JDKs installed on your machine. If we can’t find it, we will prompt for it’s location.
Here’s how an ‘install’ and open for SQLDev on your Mac should look now.
Note, this is my 2018 Mac Mini with Big Sur running. I’ve cut out some of the time to make it tolerable to watch, but all told it took less than a 90 seconds to go through the first time, and it opens in less than 10 seconds afterwards.