Log Oracle REST Data Services bugs and issues using My Oracle Support.
Oracle REST Data Services is aligning with the release numbering scheme used for Oracle Cloud Services. Going forward, releases will be numbered by
Year.Quarter.PointVersion. Expect a new release each quarter.
Oracle REST Data Services requires Java 8. Java 7 is no longer supported. See the note in the known issues section about Java 9 support. Please consult the documentation for the minimum supported Application Server versions.
It is now possible to POST SQL and JSON payloads to ORDS (restricted to appropriately authorized users), these scripts are parsed and executed by the same engine that powers Oracle SQL Developer and Oracle SQLcl, and the output is returned in a rich JSON document
Note: Enabling the REST Enabled SQL service enables authentication against ORDS enabled database schemas. This makes the database schemas accessible over HTTPS using the database password. Oracle strongly recommends that you use unguessable secure database passwords.
In ORDS 3.0.x a propietary format was used to describe Resource Module and AutoREST enabled resources. In 17.4 and later this format has been superceded by resources using the Open API 2.0 (aka Swagger) syntax.
While 17.4 continues to support Glassfish (4.1.2 and later), support for Glassfish will be removed in a future release. Use of Oracle WebLogic , ORDS Standalone Mode or Apache Tomcat is recommended instead.
The following changes and enhancements have been mae since 17.4.0:
On JDK 8 and earlier to launch an ORDS command one would type:
java -jar ords.war <command-name>On JDK 9 this must become:
java --add-modules java.xml.bind -jar ords.war <command-name>For example to launch ORDS in standalone mode on JDK 9 you must do as follows:
java --add-modules java.xml.bind -jar ords.war standalone
java.xml.bindmodule, but this module is not switched on by default in JDK 9 and so it must be explicitly enabled using the
/sign-in/interactive sign in form. Accessing
/sign-in/in APEX workspaces will produce a 404 status.