Oracle REST Database Services

ORDS 24.4 Release Highlights

by

So what even is new in ORDS 24.4? How about an abbreviated list of some fan favorites? Pre-Authenticated endpoints Using the new ORDS_PAR PL/SQL package, users can create, revoke, issue and set tokens and token life for specific resources. Your REST-enabled schema will automatically have access to this new feature in 24.4. You can execute … Read more

ORDS WARNING Cannot find the real static path of

by

Problem description You’ve just upgraded ORDS and issued the ords serve command. As ORDS is starting up, you see the following warning (or something like it): How to fix Easy! In this case, I removed the standalone.static.path property of the ORDS Global configuration settings. WAIT JUST A MINUTE! This approach was successful because I determined … Read more

ORDS Standalone: specifying a response header with jetty.xml

by

NOTE: This article shows how to include a jetty.xml file in your ORDS Standalone deployment, so a user-defined response header is provided with each HTTP response. I’m also requesting that all or some of what you see below make it into our docs. The following article picks up from where this one left off. NOTE: … Read more

ORDS Standalone access logs: Jetty and customizing with XML

by

Did you know that you can very quickly and easily enable access logging when you are running ORDS in standalone mode (i.e., when using the embedded Jetty server)? FYI: This article is an excerpt from a living document I’ve been working on dedicated to ORDS installation, configuration, and usage (from the development/developer’s perspective). And in … Read more

ORDS Configuration options: about HTTP error responses

by

Reading docs can be hard We send you poor folks to our documentation, and sometimes, it’s a section we haven’t reviewed in quite some time! I don’t think this is specific to any one organization. But over the years, details get lost, forgotten, or stored in an obscure guide section, only to be reviewed once … Read more

Microsoft Entra OAuth2.0 JWTs and ORDS secure APIs Tutorial: Configuration and Testing

by

Since ORDS first introduced support for authenticating with JWTs, there have been many questions surrounding configuration and testing. In this example, I cover, from start to finish: If this sounds like what you are looking for, then read on. There’s a lot to cover here, so there’s no faffing about on this one. Let’s go! … Read more

New ORDS feature: handling multiple files from a multipart/form-data POST request

by

A new feature An ORDS user (or application) can now upload multiple files as part of a multipart/form-data POST request under various conditions. How can this be achieved with an ORDS endpoint? NOTE: Before you continue, it might be helpful to refresh your memory on, or learn more about multipart/form-data as a Content-Type. Details here. … Read more

ORDS 24.3 Release Highlights

by

Overview There’s plenty to talk about in this release. However, I’m most excited about the performance improvements, ORDS sample applications, and documentation changes. Read on to get the whole story. Enhancements API Performance REST API responses from either AutoREST or customer based modules could see as much as a 30% improvement in response times. About … Read more

How to kill an ORDS process

by

How do I “kill” an ORDS process? FYI: This was all done on a MacBook, so…this may differ on a PC or Linux machine. Apologies m’Lord… Here are the options I’ve found to “kill” an ORDS process: It looks like we’ve included in our docs how to start ORDS (with the ords serve command), but … Read more

Extending ORDS with a Java plugin

by

About this article This article is a walkthrough and overview of setting up the example Java plugin that ships with ORDS. These plugins allow you to add functionalities and capabilities above what is possible with a standard ORDS configuration. In this example, the plugin allows you to use a name as a query parameter in an HTTP … Read more