Oracle SQL Developer 21.4.2 Release Notes

January 2022

SQL Developer | Downloads | Documentation | Forum


Bugs Fixed

  • 33735343 CVE-2021-44832: APACHE LOG4J UPDATE TO 2.17.1
  • 33724931 'OPEN DECLARATION' IS NOT WORKING
  • 33677012 WORKSHEET INCORRECTLY EXPANDS ENVIRONMENT VARIABLE VALUES INTO SQL CODE THAT REFERENCES VARIABLE NAMES
  • 33676971 REMOVE ENV VARIABLE SUBTITUTION FROM COMMON LIBRARY
  • 33749136 ORDS INSTALLER, REPAIR, UNINSTALL WIZARD NEEDS DEPRECATED AND DISABLED FOR ORDS 22.1
  • 33647940 ORDER OF 'FORMAT JSON' CAN CAUSE A SYNTAX ERROR IN SQL DEVELOPER
  • 33647932 COLUMN ALIASES CAUSE ERROR WITH JSON 'VALUE' KEYWORD
  • 33655504 SEVERAL VALID GRANT COMMANDS ARE VALID FOR ORACLE, BUT RAISE SYNTAX ERRORS IN SQL DEVELOPER
  • 33676918 FORUM: FORMATTER REGRESSION
  • 33676183 FORUM: EXCESSIVE DB DICTIONARY HITS IN SQL INJECTION

 

Before You Start

Note

  • The OS X distribution has been properly signed so there won't be any security issues/warnings when running on Big Sur.

 

JDK Support

  • Oracle SQL Developer 21.4.2 release requires Oracle Java 8 or 11, with a minimum version of 1.8 update 171. Go here to download the latest version.
  • If SQL Developer cannot find a local JDK, you will be prompted to enter the location path for the JDK. Note that the prompt wants only the folder, not the java.exe.  For example C:\Program Files\Java\jdk1.8.0_152.
  • The Data Miner and SVN client features require Java 8
  • Saving your connection passwords requires at least Oracle JDK 8u152 (for access to JCE jars)

Platform Support

  • Oracle SQL Developer 21.4.2 is available for Windows 7,8,10 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)
  • If using a OCI “Thick” connection type, a 21c Oracle Client will be required
  • Apache Log4j 2.17.1
 
Installing or Upgrading

  • All new releases of SQL Developer require a full installation. Download and unzip the file into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file.
 
Support & Feedback

Extension

Many of the features in SQL Developer are provided by other Oracle Database teams. Please use their respective Oracle Community Forums to provide feedback.

  • For all TimesTen related queries, please use the TimesTen forum
  • For all OLAP related queries, please use the OLAP forum
  • For all Machine Learning related queries, please use the Machine Learning forum
  • For all Data Modeler related queries, please use the Data Modeler forum
  • For all Database Migration related queries, please use the Migrations forum