If you need to configure a custom error page instead of the error page generated by Oracle REST Data Services (ORDS), then do the following:
Edit the defaults.xml file in the ORDS configuration folder Add the following setting to defaults.xml: 1 <entry key="error.externalPath">/path/to/error/pages/folder/</entry> /path/to/error/pages/folder is the fully qualified path to a folder which contains files named with the following pattern {status}.html, where {status} is the HTTP status code that you wish to define a custom error page for.
Read more...
It’s possible to debug pl/sql code in an Oracle Database, in much the same way as you can in any interactive debugger environment. Jeff Smith shows how it’s done in this blog post.
It get’s a little trickier to setup if your Oracle Database instance happens to be running in a guest VM and you want to debug using a SQL Developer instance running on the host, firstly because in this scenario you can only do ‘Remote Debugging’ as SQL Developer and the Database are not located on the same host, and secondly because setting up VirtualBox networking to ensure SQL Developer and the database can talk to each other takes a little bit of work.
Read more...
Oracle REST Data Services (ORDS) has always had strong support for generating Entity Tag (ETag) HTTP Headers. Entity Tags are an important aspect of the HTTP protocol, they help reduce needlessly re-transmitting unchanged resources (aka Conditional GET) and they can also be leveraged to provide optimistic locking and thus prevent lost updates. I recommend reading this post by Joe Gregorio for a detailed explanation of the benefits of generating and using ETags properly.
Read more...
_Ed. Note, March 2019: I’ve written a more succinct version of this argument here.
Origin of the trailing slash In Unix, a trailing slash on a pathname identifies the path as pointing to a folder (aka directory). If a pathname does not have a trailing slash then it points to a file. A folder is a ‘collection’ of files. The syntax of URIs is derived from the syntax of Unix filenames, and the concept of using trailing slashes to identify ‘collection’ resources was carried over.
Read more...
Oracle REST Data Services (ORDS) needs a location to store it’s configuration files. The location is configured using the config.dir setting. You can view and set this setting using the configdir command.
Set config.dir setting $ java -jar ords.war configdir /tmp/wls/conf Feb 27, 2014 2:58:47 PM oracle.dbtools.cmdline.ModifyConfigDir execute INFO: Set config.dir to /tmp/wls/conf in: /Users/cdivilly/ords.war View config.dir setting $ java -jar ords.war configdir Feb 27, 2014 3:00:16 PM oracle.dbtools.cmdline.ModifyConfigDir execute INFO: The config.
Read more...
Oracle Application Express Listener is now known as Oracle REST Data Services. We just pushed out a new point release (2.0.6) that uses the new product branding. We’ve changed the product name to emphasise the product’s future direction, focussing on ways to easily expose Oracle Database and it’s suite of offerings, to the RESTful Web, while still continuing to provide the PL/SQL Web Gateway that applications such as Oracle Application Express rely on.
Read more...
It is possible for the URI Templates of Application Express Listener RESTful Services to overlap, meaning that more than one URI Template can match a single URI. For example consider these two URI Templates: [code language=“text”] employees/{id} employees/{id}/manager [/code] For the following URI path: employees/7469, which URI Template (and therefore which Resource Template and Resource Handler) should Application Express Listener choose? Let’s look at an actual example, I’ve created a RESTful Service Module (with a URI prefix of: overlaps/) on apex.
Read more...
Filed under ‘Annoying things I keep forgetting how to fix…’: Out of the box, Firefox has a feature designed to help people mis-typing URLs in the browser bar. It’s described in detail here, but briefly, if a URL fails to resolve, Firefox trys a couple of permutations of the URL to try find what you -might have- really intended, appending a .com and/or prefixing a www. to the host name portion of the URL to see if they resolve.
Read more...
Oracle Application Express (APEX) relies on a set of static resources to function properly. These static resources contain the JavaScript, CSS, and images that the APEX user interface needs to render and function correctly. The static resources are located in the /images folder in the APEX distribution. Typically the resources are made available at the /i/ path on an APEX web server. In the Oracle Application Express Listener (Listener) 1.x.x series the process for deploying the /i/ bundle was to manually zip the contents of /images into an archive named i.
Read more...
One of the nice features of Oracle Application Express Listener is Standalone Mode. Standalone Mode enables the Listener to run outside of an application server, starting Standalone Mode is as simple as typing the following in a command prompt:
1 java -jar apex.war standalone Seconds later a functioning Listener instance is up and running. It’s a lot quicker and more convenient than the multiple steps involved in deploying Listener to an application server.
Read more...