These are both maintenance releases. Several bugs have been fixed. In addition the core architecture has seen the following updates:
- Java 11 has been updated to Java 17
- JDBC has been updated from 21c to 23ai
- Script Engine/SQLcl has been upgraded to 24.3
The license has also been migrated from the OTN license to the FUTC license. The benefit here is that you no longer need an Oracle.com account, nor do you need to ‘click-thru’ and agree to terms.
With our new maintenance window of 18 months, this means you’re covered for support until April of 2026.
On the download page and in the welcome page banner, we’re pushing you to VS Code…
This is the future of SQL Developer. All active development is happening here, and only bug fixes will be supplied for the desktop versions. Stay tuned for Modeler support in VS Code 🙂
1 Comment
Congratulations on the release!
Jeff, I believe there’s a regression in the parser. When using the libraries from SQLcl 24.2, the following query is parsed without any errors:
SELECT JSON [ SELECT JSON {‘id’: employee_id, ‘name’: last_name, ‘sal’: salary} FROM employees WHERE salary > 12000 ORDER BY salary ] by_salary;
(This is the last example from the documentation on JSON_ARRAY: https://docs.oracle.com/en/database/oracle/oracle-database/23/adjsn/sql-json-function-json_array.html)
Yet, with the libraries from SQLcl 24.3, it results in a “Syntax Error at line 1, column 115” (it’s in the ORDER BY clause).