Oracle REST Data Services 23.4.0

Release Notes

Date: December 2023

New Features in 23.4.0

  • ORDS - Pool destroy --help sub-command now displays improved documentation.
  • ORDS - Improved error detection and messaging for advanced database pool configurations.
  • ORDS - CLI - Issuing the ORDS config list --include-defaults command in an empty folder now displays all default values.
  • ORDS - Add support for :body_json implicit parameter in ORDS template handlers.
  • ORDS - User will now receive 429 status error instead of 503 when maximum connection pool has been reached on OCI.
  • ORDS - REST-Enabled SQL service now supports SQL statements that contain a WITH clause and an embedded PL/SQL function.
  • SDW - Improved tool-tip, and embedded options for recent objects in the ADP studio.
  • SDW - Enhanced log information related to the processing and status of a data share.
  • SDW - Data Load - when in the "load tables" cart, users can now select from available consumer groups.
  • SDW - Live feed log details now support rows greater than 50.
  • SDW - Cloud Store - target table information related to where the data originated from and a date/time summary will now be accesible to the user.
  • SDW - A user's most recently used cloud bucket will now display by default.
  • SDW - A confirmation message now appears when users copy files from object storage to their directory.
  • SDW - After compilation, lines with errors are now indicated, marked in the editor.
  • SDW - Add/clear buttons have been added to all search boxes in Database Actions.
  • SDW - Progress indicator added for data loading.
  • SDW - Data Pump - back button enabled on first step.
  • SDW - Generate links to error help portal for ORA-* errors to now include hyperlinks directing users to the Oracle database Error Messages portal.
  • SDW - Rest Workshop - roles and protected modules columns in Create Privileges slider made more explicit.
  • SDW - SQL Worksheet now supports the “clear screen” statement, in SQL scripts.
  • SDW - Datapump - users can now manually search for OCI buckets to quickly retrieve their DMP files and related information..
  • SDW - Swagger and Open API - document generation now available for GET Resource Handlers that employ a cursor function.

Issues Fixed in 23.4.0

  • 26624888 SDW - XML type data show as null on grid.
  • 35155663 When a procedure is not in allow-list exception is thrown on the terminal.
  • 36013520 Catalog / share - unable to retrieve ddl for a table in a shared/enabled schema.
  • 35926596 Columns of type JSON are presented as of type .json in DDL and on diagram.
  • 34021928 Incorrect values for options with bequeath connection throws error.
  • 34021688 ORDS CLI - ORDS instal using bequeath connection without setting ld_library_path throws error in console.
  • 34020858 Unable to install ORDS using bequeath connection with --db-sid option.
  • 35961246 ORDS CLI - is ignoring the --port option ords serve [options].
  • 35446433 ORDS CLI - plsql.gateway.mode not set during upgrade when specifying a different config location.
  • 35954340 ORDS editionable preparation script does not work in all situations.
  • 31535485 Jetty generates 302 redirects using wrong protocol when ssl is terminated upstream.
  • 34157916 Metadata-catalog endpoint cannot be accessed using user credentials when p_auto_rest_auth is true.
  • 35046452 Mac - connection management - while logging in to any connection the username auto corrects unnecessarily.
  • 35155663 When a procedure is not in allow-list exception is thrown on the terminal.
  • 35377966 ORDS remote debugging option (--debug) not working on windows.
  • 35397168 ORDS generated identity column update metadata cache incorrectly after 555 error.
  • 35649440 After oauth logout - not possible to log back in with the same credentials in the logged out url.
  • 35651316 Help button of oauth2 administration card in ords landing page still point to old version doc.
  • 35655078 Single quote in base path when create a module will cause 500 error.
  • 35659170 PUT operation can return 200 status code and do nothing when no header is specified for curl.
  • 35853802 "and" filter and "between" filter doesn't work on date data type.
  • 35860902 ORDS restart required after rest enabling table that will be using GraphQL features and functions..
  • 35865672 Graphql: filter doesn't work with timestamp data type.
  • 36055419 Query parameters deleted if URL has pool name in uppercase.
  • 35871443 Accessing ORDS through http port 80 does not redirect to https port 443.
  • 33952454 Database error messages not displaying properly in sql worksheet.
  • 33856050 Ambiguous column names in results set not correctly handled.
  • 32973948 Cloud folder data load is allowing you to mix files with different column definitions.
  • 35547401 When creating & publishing a new live share, occasionally share provider or share will not appear.
  • 35546224 Correct field label/option name 'remove' is not used in the confirmation message..
  • 35558278 No button to "notify recipients" when share publishes anymore.
  • 35644104 Reload data load job functionality not working.
  • 35765311 Cannot reuse recipent name after it has been deleted.
  • 35778606 Editing existing card in cart will generate an error w/ Data Load > Link Cloud object.
  • 35782326 Target name is lost when using reload cart with quoted names.
  • 35933604 Av designer fails in create av with intermittent pq errors.
  • 36025411 Excel add-in - new sql query ui - corrupted query when using some characters.
  • 36033228 Documentation link for seting up AI profile for LOAD FROM AI source is incorrect.
  • 33916138 Catalog default query from user preferences not applied.
  • 35645112 Provider identification REST API errors are not displayed.

Supported Java Version

Oracle REST Data Services requires Java 11 or 17. The supported Java Runtime Environments are:

  • Oracle Java 11
  • Oracle Java 17
  • Oracle GraalVM Enterprise Edition for Java 11
  • Oracle GraalVM Enterprise Edition for Java 17
Java 8 is no longer supported. Please consult the documentation for the minimum supported Application Server versions for ORDS.

Support

  • You are supported by Oracle Support under your current Oracle Database Support license for Oracle REST Data Services production releases .
  • Log Oracle REST Data Services bugs and issues using My Oracle Support.

    • For problems specific to SODA for REST, file a service request using "Oracle XML Developers Kit" as the product.
    • For all other problems, use "Oracle REST Data Services" as the product.

Note - Autonomous Database Shared Subscribers

If you are running a customer-managed ORDS for your Autonomous Transaction Processing, Autonomous Data Warehouse, or Autonomous JSON Database, you must upgrade your customer-managed ORDS to the version used in your Autonomous Database Shared environment. Failure to do so could lead to service disruptions.

To determine the version of ORDS in your Autonomous Database Shared database run this query:

select ords.installed_version from dual;

		
		

Documentation

General

  • Documentation for this release is provided on the oracle.com web site. Click here to view the documentation and related information.
  • Documentation on using SODA for REST is provided on the oracle.com web site. Click here, navigate to the documentation section and access the book titled 'SODA for REST'.

Getting Started

  • A tutorial on getting started with developing RESTful Services is included in the ORDS product documentation, in the book titled 'Oracle REST Data Services Quick Start Guide'.

Known Issues

Oracle Database may report 'ORA-01031: insufficient privileges' for queries that involve CURSOR expressions

In a number of cases, ORDS executes queries which include a CURSOR expression. An issue has been found executing these queries for some schemas in Oracle 18c and Oracle 19c databases. Depending on the roles and privileges involved, the issue does not occur for all schemas, which can give the impression that the issue is intermittent. Refer to RDBMS bug 29049673 for more information. The issue is manifest as follows in the exception returned:

ORA-00604: error occurred at recursive SQL level 1

ORA-01031: insufficient privileges
			

This is a problem with view-merging of nested cursors introduced in Oracle 18.1 database. Please use the following as a workaround:

alter system set "_fix_control"='20648883:OFF';

		

Oracle Database DATE and TIMESTAMP values

ORDS interprets Oracle Database DATE and TIMESTAMP values (which do not possess a time zone) into the time zone of ORDS. These values are then represented in the RFC3339 UTC format.

In a future release Oracle Database DATE and TIMESTAMP values will not by default be interpreted into any time zone. These values will be represented in the ISO 8601 "yyyy-mm-ddThh:mm:ss[.sss]" format. Oracle Database TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE values will remain represented in the RFC3339 UTC format.

SQL Developer Web

  • DATE, TIMESTAMP, TIMESTAMP WITH TIMEZONE values downloaded from the Worksheet Query Result in the JSON format are not presented in the Internet Datetime format.

JDBC Array values

ORDS passes array values to the Oracle Database in a number of cases, for example arrays are used to pass the request headers and form fields during PL/SQL Gateway calls. Oracle JDBC Driver 18.3 and later supports an improved mechanism for passing array values, however this feature is only supported on Oracle Database 12c and later. Thus ORDS uses existing deprecated and less efficient APIs for passing array values when connecting to 11G databases, and the improved mechanism when connected to 12c and later. Customers experiencing problems with passing large array sets (for example OutOfMemory exceptions) are encouraged to upgrade from 11G to a newer database version to mitigate these issues.

Autogenerated REST Endpoints

  • AutoRest resources support the OAuth 2.0 Client Credentials flow only.

RESTful Services

  • Application Express workspaces do not support first party authentication, and therefore do not support the /sign-in/ interactive sign in form. Accessing /sign-in/ in APEX workspaces will produce a 404 status.

Support For mod_plsql logmeoff

  • The mod_plsql logmeoff mechanism is not supported reliably by modern browsers and it is not provided by ORDS. The only way to end a HTTP Basic Authentication session is to close the Browser.

Feedback

  • At Oracle REST Data Services on oracle.com you will find links to forums and social media channels where you can discuss topics with the ORDS community around the world and leave feedback for the development team.
    • In the forums, be sure to use clear subject lines to initiate a thread. Provide a complete and clear description of the issue, including steps to reproduce the issue.
    • Try to avoid using old, unrelated threads for a new issue.

Important Concepts to Keep In Mind

Revised Command Line Interface and Configuration Directory Structure

Command Line Interface

The java commands serviced from the WAR file are no longer supported. Attempting to run the following:

java -jar ords.war standalone


Will result in an error message, referring you to the docs. Instead you would run:
ords --config /path/to/config serve

Installation & Configuration

The ORDS program or script in the bin directory can be used to perform installs, changes to your configuration, changing the database passwords for your connection pools, and for creating ORDS users. To see a list of commands:

ords --help

Configuration Files Directory Layout

If upgrading from a previous version of ORDS, your existing configuration directory for ORDS and the files contained therein will be migrated to a new layout for versions 22.1 and higher.

You may migrate your settings using the ORDS migrate command, or you may perform a 22.1 install which will prompt ORDS to migrate your existing ORDS configuration to the new mapping for you.

ORDS standalone and default pool configuration settings are in a settings.xml file in a global subdirectory.

Connection pools are in a databases subdirectory. The intital database pool is named 'default' and has a '/' mapping pattern.

Subsequent pools will created such that the name of the pool also defines the mapping pattern.

SQL Developer Web

SQL Developer Web (SDW) is an ORDS hosted web application giving Oracle Database users the SQL Developer desktop experience in their browser.

SQL Developer Web provides a development interface for building and maintaining your ORDS based REST APIs, AUTOREST Enabled database objects, OAuth3 Clients, ORDS Privileges and Roles, as well as a SODA for REST graphical interface. For the best possible experience developer REST APIs for ORDS, we recommend you use SQL Developer Web.

For consistent representation of date values in SQL Developer Web, ORDS should be run in the UTC timezone. This is set automatically when using the ords command line interface. When deploying ORDS to Apache Tomcat or WebLogic Server the user.timezone may have to be set explicitly before starting the container.

-Duser.timezone=UTC

		

SQL Developer Web requires the Database API be enabled.

SQL Developer Web's DBMS_SCHEDULER interface requires database version 12.2 or higher.

Metadata Catalog

The default output for openapi-catalog is Swagger V2. In a future release the default output will be OpenAPI V3.

Upgrading ORDS in the database

If you have previously executed script, ords_installer_privileges.sql, to grant your administrator user privileges to perform the install or upgrade, then you must execute the script again on that same user that you provided because additional grants have been added to this script. Note: This script does not apply to the SYS user account.

 

Previous Release Versions

Changes in 23.3.1

The following changes have been made since 23.3.0:

Issues Fixed in 23.3.1

  • 35870556 - Landing Page: SQL Developer Web and oracle APEX cards greyed out

New Features in 23.3.1

  • Uptake JDBC/UCP 21.12.0.0.230906
  • Uptake Apache Commons Compress 1.24.0

Changes in 23.3.0

The following changes have been made since 23.2.3:

Issues Fixed in 23.3.0

  • 35668572 - ORDS script fails because it's relying on JAVA_HOME to be in the path
  • 35641005 - Error: "REST call failed." when selecting curl command
  • 35622566 - POST gets ORA-01400 when inserting a row into a table with timestamp column as primary key and default value is systimestamp
  • 35444196 - Error response renderer class throws InternalServerException when IllegalStateException encountered
  • 35417910 - Accessing ORDS through http port 80 does not redirect to https port 443 for ADB-D
  • 35214164 - OAuth login - Only the first attempt of login is working
  • 31419038 - Ensure all ords_metadata objects are marked non-editionable
  • 35155296 - Command Line Interface missing pdb.disable.lockdown equivalent parameter

New Features in 23.3.0

  • GraphQL query support for your REST Enabled Schemas and Tables/Views
  • GraphiQL web client for developing GraphQL queries
  • JSON Web Token (JWT) auth via 3rd party Identity Providers (OAUTH_ADMIN.CREATE_JWT_PROFILE)
  • Data Studio - Allow saving and reloading data load settings for a given file
  • Data Studio - Add support for the data load settings UI to livefeed tables
  • Data Studio - Create Analytic Views from the Catalog application
  • Data Studio - Excel Add-in: Dynamic query of Analytic Views, support for OAUTH connections, improved reports integration
  • Data Studio - Catalog: Reorganize catalog card information
  • Data Studio - AV Designer - add support for multi-column keys
  • Uptake Jackson JSON 2.15.2 and Jackson Databind 2.15.2
  • Uptake Oracle SODA 1.1.20
  • Uptake Oracle MongoDB Listener 230910.1636
  • Uptake Oracle JET 14.1.5-01
  • Uptake Eclipse Jetty 10.0.17

Changes in 23.2.3

The following changes have been made since 23.2.2:

Issues Fixed in 23.2.3

  • 35313372 - ORDS should refresh the connection pool if an issue is encountered during database authentication

Changes in 23.2.2

The following changes have been made since 23.2.1:

Issues Fixed in 23.2.2

  • 35517682 - Blank bearer token for implicit, auth code oauth3 clients
  • 35503886 - Rest call failed on "show metadata" for mle modules
  • 35524845 - ADB-S: Encountered HTTP 400 SSO from APEX to Database Actions
  • 35609558 - Regression in 23.2.0 - cannot show json data guide diagram for tables and views with json documents
  • 35561430 - Creating APEX workspace when user is created on fly throws error
  • 35530958 - Unable to delete/edit oauth client- error:"you do not have permission to delete the client"
  • 35544303 - ORDS oauth implicit flow broken by sign in

New Features in 23.2.2

  • Uptake Guava 32.1.1
  • Uptake Oracle SODA 1.1.19

Changes in 23.2.1

The following changes have been made since 23.2.0:

Issues Fixed in 23.2.1

  • 35606337 - ORDS returns HTTP 404 when registered schema alias has an uppercase character
  • 35616907 - PUT on REST Enabled table returning HTTP 400 Bad Request response when primary key column is not numeric and has data default value defined

Changes in 23.2.0

The following changes have been made since 23.1.4:

Issues Fixed in 23.2.0

  • 35420714 - SQL Developer Web JSON Document update is broken and raises ORA-907
  • 32059058 - Incorrectly encoded basic authentication returns a 500 error, instead of 401
  • 34669593 - Command Line Interface ( CLI ) to enforce Java 11 minimum at startup
  • 35273453 - ICAP AV requests contain invalid 'Encapsulated' header values
  • 34396920 - ORDS does not work when installed in CDB with connection type TNS

New Features in 23.2.0

  • Uptake JDBC/UCP 21.11.0.0.230512
  • Uptake Eclipse Jetty 10.0.15
  • Uptake Oracle SODA 1.1.18
  • Oracle Database API for MongoDB now supports aggregation framework, requires at least version 23c of Oracle Database
  • ORDS Landing Page, provides links to SQL Developer Web, APEX, OAuth Clients, replaces APEX as default page (/)
  • PATCH method for AutoREST Enabled 23c JSON Relational Duality Views
  • ORDS commands added for Universal Connection Pool management ( list, destroy )
  • Standalone mode: request to root path redirects to default context path
  • HTTP error pages updated look and feel (Redwood)
  • Specify username when for connection pool error 'is not valid, have expired or blocked the account'
  • ORDS PLSQL API to rotate OAUTh3 client secret ORDS_METADATA.OAUTH.UPDATE_CLIENT_SECRET
  • Self Service Schema registration improvements: USER name based on requested value, DBA can specify default privileges, delete rejected schema
  • SQL Developer Web SQL Worksheet Explain Plan now includes flame graph visualization
  • SQL Developer Web MLE JS IMPORT MODULE from URL
  • SQL Developer Web MLE JS Generate JSONDOC MarkDown file from MLE Module
  • Deprecate OAuth UI in favour of Database Actions REST Workshop

Changes in 23.1.4

The following changes have been made since 23.1.3:

Issues Fixed in 23.1.4

  • 35417734 - ORDS - Fix issue during pool creation
  • 31408944 - ORDS - Resolve issue with JDBC authentication cache

Changes in 23.1.3

The following changes have been made since 23.1.2:

Issues Fixed in 23.1.3

  • 35295144 - Database Actions - ADBD: Bespoke landing page not loading correctly
  • 35165994 - ORDS - Not reloading database password from global wallet

Changes in 23.1.2

The following changes have been made since 23.1.1:

Issues Fixed in 23.1.2

  • 35297956 - Database Actions - Error using OAuth login page

Changes in 23.1.1

The following changes have been made since 23.1.0:

Issues Fixed in 23.1.1

  • 35185177 - Database Actions - Error when MLE JavaScript function has no parameters
  • 35185042 - Database Actions - The content of editor is not restored for MLE JavaScript
  • 35196931 - PL/SQL Gateway - Procedure cache not resetting when APEX upgrades

New Features in 23.1.1

  • Official support for Oracle GraalVM Enterprise 11 and 17
  • Uptake SODA 1.1.16

Changes in 23.1.0

The following changes have been made since 22.4.4:

Issues Fixed in 23.1.0

  • 29253065 - POST and PUT on REST Enabled table with "GENERATED ALWAYS AS IDENTITY" columns results in ORA-32795 error
  • 34816442 - Sign-in flow not working when a REST Enabled schema is not involved
  • 34762861 - Database Actions - Data loading from file not working
  • 34846031 - Database Actions - Cannot load a local file in SQL Worksheet from table context menu
  • 35135762 - Database API - Invalid URL when server and path combined

New Features in 23.1.0

  • Uptake JDBC/UCP 21.10.0.0.230302
  • Uptake Apache Commons FileUpload 1.5
  • Uptake antlr4-runtime 4.11.1
  • Uptake Oracle Mongo DB Listener 230302.1319
  • Include Auto PL/SQL paths in OpenAPI document
  • Database API - Export and import APEX Applications
  • Database Actions: Sign-In/Out optimized UI/UX
  • Database Actions: REST workshop, Export Schema
  • Database Actions: Multilingual Engine (MLE) support in Oracle Database 23c
  • ORDS: AutoREST support extended to JSON Relational Duality Views in Oracle Database 23c

Changes in 22.4.4

The following changes have been made since 22.4.3:

Issues Fixed in 22.4.4

  • 35042641 - Charts page is not showing Redwood Brown Theme
  • 34985733 - Fix "Expiring Passwords" widget(monitoring)
  • 35022665 - Inconsistent sort options while creating a composite index
  • 35002206 - --wallet option throws an error in ORDS ADB Install CLI
  • 34465167 - ADB-S Service Console: Show only MongoDB connection string that contains port 27017
  • 33997668 - JSON Workshop: Index is dropped while editing it

New Features in 22.4.4

  • Uptake JDBC/UCP 21.9.0.0.230123

Changes in 22.4.3

The following changes have been made since 22.4.2:

Issues Fixed in 22.4.3

  • 35033730 - Data Studio update to color theme

Changes in 22.4.2

The following changes have been made since 22.4.0:

Issues Fixed in 22.4.2

  • 34824962 - Database Actions Data Pump import fails for various DMP files
  • 34943125 - procedure.rest.preHook is executed for PL/SQL Gateway calls

New Features in 22.4.2

  • Database Actions: Self Service Schema - A semi-automated flow to allow users to request database schemas
  • Database Actions: Migration to Oracle's Redwood styling
  • Database Actions: Data Pump import is now enabled on ADB-S environments

Changes in 22.4.0

The following changes have been made since 22.3.3:

Issues Fixed in 22.4.0

  • 34762861 - Database Actions: Data Loading from file not working
  • 34724735 - Setting db.invalidPoolTimeout not working to retry an invalid default pool
  • 34693771 - Incorrect path in Linux Support scripts and documentation
  • 34685239 - Pool not marked as stale for oracle.net.ns.NetException error scenarios 'TNS:listener could not find instance appropriate for the client connection' and 'Mismatch with the server cert DN'. '
  • 34669593 - Minimum Java version checks in ORDS shell script not working
  • 34664606 - Get PDB Snapshot by name not working with 18c database
  • 34643474 - HTTP 500 Internal Server Error response if APEX is installed in CDB
  • 34571360 - PL/SQL Gateway allow list view not visible to ORDS_ADMINISTRATOR_ROLE
  • 34570720 - DBAPI Creating new pluggable database fails
  • 34488953 - Instance API does not show pools in revised configuration
  • 34014229 - Running PL/SQL Gateway without ORDS installed in database blocked by missing privileges
  • 34003124 - Hostnames mapping overrides paths mapping in the same pool
  • 33859693 - Install fails when execute privilege on DBMS_SQL is not granted to PUBLIC

New Features in 22.4.0

  • Switch from using javax.* APIs to their jakarta.* equivalents
  • Uptake Jakarta Servlet API 4.0.3
  • Uptake Jakarta Inject API 2.0.0
  • Return HTTP 403 response when client not in ADB-S Access Control List
  • Return HTTP 429 response when database server returns ORA-00018 maximum number of sessions exceeded
  • Add Data Tool endpoints to Database API
  • Export OAUTH Client
  • Support order by NULLS first/last in Object Filter query parameters
  • Database Actions: Make 'Run as SQL script' the default operation for Run Statement button

Changes in 22.3.3

The following changes have been made since 22.3.2:

Issues Fixed in 22.3.3

  • Bug 34162245 - ORDS: Symbolic links can not be used to provide static content in standalone mode
  • Bug 34752871 - Database Actions: Failure to get Cloud Storage Bucket in Data Pump

New Features in 22.3.3

  • ORDS: Uptake Jetty 10.0.12

Changes in 22.3.2

The following changes have been made since 22.3.1:

Issues Fixed in 22.3.2

  • Bug 34723764 - ORDS: Silenty ignore query parameters which do not match plsql parameters
  • Bug 34728229 - ORDS: Uptake Jackson 2.13.4 and Jackson Databind 2.13.4.2

Changes in 22.3.1

The following changes have been made since 22.3.0:

Issues Fixed in 22.3.1

  • Bug 34709325 - ORDS: APEX Social Authentication recieving 404 NOT FOUND

Changes in 22.3.0

The following changes have been made since 22.2.2:

Issues Fixed in 22.3.0

  • Bug 34151810 - Database Actions: Alter session not working in SDW
  • Bug 34457888 - ORDS: ORDS does not pass through parameters retrieved via OWA_IMAGE.GET_X(IMAGE)
  • Bug 34356953 - ORDS: Batch POST fails with NullPointerException
  • Bug 34077953 - ORDS: ORDS 500 Internal Server Error inserted value too large for column
  • Bug 34036798 - ORDS: Command Line Interface fixed option values should be case insensitive
  • Bug 33649799 - ORDS: ORDS does not invoke overloaded PL/SQL procedures correctly
  • Bug 34327673 - ORDS: Command Line Interface --db-pool option not accepting values using underscore

New Features in 22.3.0

  • ORDS: Uptake Jetty 10.0.11
  • ORDS: Update SODA 1.1.13
  • ORDS: Uptake Oracle JDBC and UCP drivers 21.0.0.0_220912
  • ORDS: Provide PL/SQL API to force ORDS into debug mode
  • ORDS: Provide Customer Managed ORDS for Autonomous Database installation process in the command line interface
  • ORDS: Set db.serviceNameSuffix by default on CDB installs
  • ORDS: Make PL/SQL Gateway allow list ready for custom procedures
  • ORDS: Serve MongoDB Listener in standalone mode
  • ORDS: Support jdbc.ConnectionWaitTimeout in pool settings
  • ORDS: Database API - PDB Lifecycle Management: Do not close wallet during cloning
  • ORDS: Database API - PDB Lifecycle Management: Support PDB Snapshots
  • Database Actions: Data Loader - Add support for filtering data loading slider by schema
  • Database Actions: Data Pump - Add Import Job Wizard

Changes in 22.2.2

The following changes have been made since 22.2.1:

Issues Fixed in 22.2.2

  • Bug:34072949 - ORDS: Default value(900) of jdbc.statementtimeout parameter doesn't work
  • Bug:34448170 - Database Actions: Show card for "Graph Studio" in launchpad
  • Bug 34370563 - ADP: Support multiple addins on one excel
  • Bug 33948244 - ADP: Lineage/impact ui does not correctly render odi lineages with 3-deep node nesting
  • Bug 34390875 - ADP: Changing dblink source does not update navigator tree

Changes in 22.2.1

The following changes have been made since 22.2.0:

Issues Fixed in 22.2.1

  • Bug:34057582 - ORDS: Requests with additional trailing slashes should result in HTTP 404 response
  • Bug:34179622 - ORDS: Include owa.docTable in config info
  • Bug:34304646 - ORDS: Have configurable jdbc.connectionWaitTimeout used by PL/SQL Gateway
  • Bug:34354741 - ORDS: Improvements to Oracle Transactional Event Queues services
  • Bug:34358681 - ORDS: Remove APP_VM_OPTS variable from RPM definition

New Features in 22.2.1

  • ORDS: Uptake Jetty 9.4.48.v20220622
  • ORDS: Uptake SODA 1.1.11

Changes in 22.2.0

The following changes have been made since 22.1.1:

Issues Fixed in 22.2.0

  • Bug:32047436 - ORDS: ORA-65011 Pluggable Database does not exist error when installing to EBS database 19c
  • Bug:32438722 - ORDS: Database API PDB Lifecycle Management does not allow special characters in administrator password
  • Bug:32471712 - ORDS: Not reloading passwords from wallet after failed database connection attempt
  • Bug:34110230 - ORDS: Remove Jersey support
  • Bug:34175379 - ORDS: SEVERE log message displayed for making connection even though database mapping succeeds
  • Bug:34178022 - ORDS: Standalone certificates not migrated
  • Bug:34219177 - ORDS: Do not use reserved words as schema alias
  • Bug:34223707 - ORDS: NoClassDefFoundError oracle/xdb/XMLType reported for certain REST Enabled SQL scripts

New Features in 22.2.0

  • ORDS: Uptake Oracle JDBC and UCP drivers 21.0.0.0_220509
  • ORDS: OpenAPI v3 is the default specification for open-api-catalog (formerly Swagger v2)
  • ORDS: Provide method for resetting client secret
  • ORDS: Metadata catalog representation in Swagger/OpenAPI format for AutoREST indicates attributes comprise the primary key
  • ORDS: Provide command to extract the ORDS install, upgrade, validate and uninstall scripts.
  • ORDS: Provide command to generate web application for deployment to Apache Tomcat or Oracle WebLogic Server
  • Database Actions: Support the Multilingual Engine (MLE) syntax in Oracle Database 21c
  • Database Actions: Generate, View, & Download Automatic Workload Repository (AWR) reports

Changes in 22.1.1

The following changes have been made since 22.1.0:

Issues Fixed in 22.1.1

  • Bug:31078322 - ORDS: Client closing socket can result in HTTP 500 error
  • Bug:34070049 - ORDS: Prevent use of / in paths file
  • Bug:34092368 - ORDS: OutOfMemoryError can occur when starting in standalone mode
  • Bug:34062151 - Database Actions: Not possible to set timezone for start date and end date of job

New Features in 22.1.1

  • Bug:34156033 - ORDS: Uptake Jetty 9.4.46.V20220331
  • Bug:34096129 - ORDS: Automatically link to MySQL Connector/J jar installed through OCI RPM
  • Bug:33995066 - Database Actions: Implement liquibase deployment reporting

Changes in 22.1.0

The following changes have been made since 21.4.3:

Issues Fixed in 22.1.0

  • Bug:31584096 - ORDS: Swagger V2 payload definition is incorrect for POST handler
  • Bug:31797961 - ORDS: Invalid timestamp value in AutoREST PUT parameter causes HTTP 500 Internal Server Error
  • Bug:33014274 - ORDS: Using boolean parameter out on AutoREST PL/SQL causes HTTP 500 Internal Server Error
  • Bug:33111572 - ORDS: Traditional Chinese not represented correctly
  • Bug:33812677 - Database Actions: Roles are mandatory when creating an OAuth3 client
  • Bug:33812695 - Database Actions: Roles created by SYS not listed when creating an OAuth3 client
  • Bug:33542000 - Database Actions: Explain Plan is caching previous executions
  • Bug:33610732 - Database Actions: Table properties unique keys text cropped
  • Bug:33631559 - Database Actions: Wrong color for string quote
  • Bug:33669845 - Database Actions: Missing labels on Charts page
  • Bug:33680494 - Database Actions: The unexpected token symbol shown when a token is followed by a quoted string
  • Bug:33816710 - Database Actions: OpenAPI documentation fails with parser error - duplicated mapping key

New Features in 22.1.0

  • Bug:30717389 - ORDS: Swagger V2 and OpenAPI V3 representation of Metadata Catalog to include authentication information
  • Bug:31391518 - ORDS: Revised Command Line Interface and Configuration Directory structure
  • Bug:33416453 - ORDS: Make Java 11 the minimum Java Runtime Environment version
  • Bug:33744175 - ORDS: Uptake Oracle Jet 11.1.6
  • Bug:33947345 - ORDS: Use REST Enabled SQL Service with MySQL database
  • Bug:34002527 - ORDS: Rotate a client secret
  • Bug:33784519 - ADP: Support renaming and deleting an ingest job
  • Bug:33841574 - ADP: Running data ingest jobs are listed with job name
  • Bug:31018220 - Database Actions: Use offline help when online help not available
  • Bug:33417651 - Database Actions: User friendly global search
  • Bug:33532066 - Database Actions: Generate CURL snippets for Windows
  • Bug:33631074 - Database Actions: Improve performance of standalone Charts view
  • Bug:33655971 - Database Actions: Disable refresh for Charts
  • Bug:33817138 - Database Actions: File system access in SQL Worksheet
  • Bug:33850965 - Database Actions: Import REST Module from swagger definition
  • Bug:33867119 - Database Actions: Enhanced support for PL/SQL object editing
  • Bug:33886602 - Database Actions: Uptake performance hub plugin 1.0.0-20220219112340-MASTER
  • Bug:33952777 - Database Actions: Create PL/SQL object from scratch
  • Bug:33792443 - Database Actions: Add support for full screen in SQL Worksheet

Earlier versions

For information on Issues Fixed and New Features introduced for earlier versions please refer to the release notes for those versions.