

Make a mapping between the URL and the ORDS applicationĭownloading the ORDS software can be done from the Oracle Technology Network.Make some setup configurational changes.The overall process of installing and configuring ORDS is very simple.

This relational data can be stored in either an Oracle database, an Oracle 12c JSON Document Store, or an Oracle NoSQL database.Ī mid-tier Java application called ORDS, maps HTTP(S) requests (GET, PUT, POST, DELETE, …) to database transactions and returns results in a JSON format. ORDS makes it easy to develop a REST interface/service for relational data. Access to and/or manipulation of web resources is done using a uniform and predefined set of stateless operators. RESTful service: an http web service that follows the REST architecture principles. Oracle’s implementation of RESTful services against the database. It provides interoperability on the Internet between computer systems.

Also running in stand-alone mode would lead to additional security issues for port configutions. We’ve chosen WebLogic Server to deploy the ORDS application because we already used WebLogic’s REST feature for smoketesting the application and WebLogic resources, and for high availability reasons because we use an Oracle RAC database. It then shows you how to install ORDS feasible for a production environment using WebLogic Server 12c and an Oracle 12c database as we have done for our smoketesting application. This article will give a short introduction to ORDS. With ORDS you can install it in 2 different scenario’s, in standalone mode on the database server, or in combination with an application server such as WebLogic Server, Glassfish Server, or Tomcat. As it turns out Oracle has a feature called ORDS – Oracle REST Data Service – to accomplish this. Another example is the existence of required database services. For example we wanted to know if the database version and patch level were at the required level as was used throughout the complete DTAP environment. But then we wanted to extend smoketesting to the database. Implementing REST in combination with WebLogic is pretty easy. In my job as system administrator/DBA/integrator I was challenged to implement smoketesting using REST calls.
