Chris Hoina Senior Product Manager @ Oracle Database Tools
This actually came about from a Support Request. We were troubleshooting a JWT issue, that had ORDS in the mix. Ultimately, this is looking more and more like a networking issue (maybe something to do with routing rules between the load balancer and the backend server). But in the course of our troubleshooting, we wanted … Read more
Venkata this one’s for you 😀 It took me the rest of the afternoon, but here is a pretty simple GET request example, using a user-defined ORDS API. This API is derived from one of our LiveLabs, a Python + JavaScript application. But this particular scenario pretty well exemplifies what we discussed in our presentation … Read more
Have you ever seen this? Have you ever seen a message like this while working with ORDS? The one where you receive a 503 Service Unavailable response code and message? This message has something to do with ORDS being unable to make a connection to the database. But if you keep reading, you’ll see even … Read more
Table of Contents Intended Audience/Purpose Does this describe you? Creating a Domain Adding an Integrated Application to the Domain Adding the application Configuring OAuth Resource server configuration Client Configuration Issuing a POST request to obtain a JWT Gathering the required values for the request Setting up Postman Requesting the JWT ORDS configuration Decoding the JWT … Read more
Recently, we (one of our Support engineers and I) worked with a customer who had integrated various ORDS POST APIs with a web-based form application called JotForm. JotForm offers integrations for numerous workflows, some official and others you can create independently. That’s where we come in. In this example, a user would enter information into … Read more
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
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
ALERT: This is going to seem extremely out of context! But this post actually loosely relates to the ORDS Pre-hook functions section of our docs. I’m in the process of (1) working on a presentation and (2) updating this section of the docs as well (productivity trifecta for the win!), hence why we are here. … Read more
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
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