About Oracle Application Express Architecture

3.1 About Oracle Application Express Architecture

Oracle Application Express uses a simple architecture in which pages are dynamically generated using metadata stored within the Oracle Database.

About the Oracle Application Express Architecture

The Oracle Application Express architecture consists of a web browser, Oracle REST Data Services (the web listener), and an Oracle Database containing Oracle Application Express. The major advantage of this architecture is the separation of the mid-tier and the database tier.

Description of apex-arch-1876607.eps follows

Description of the illustration apex-arch-1876607.eps

The web listener, Oracle REST Data Services, functions as a communications broker between the Web browser and the Oracle Application Express objects in the Oracle database by mapping browser requests into database stored procedure calls.

Once fully installed, a Uniform Resource Locator (URL) is defined for both developers and end users to access Oracle Application Express. Users require only a Web browser and the required URL. No additional client software is required.

About Oracle REST Data Services

Oracle REST Data Services (formerly known as Oracle Oracle Application Express Listener) is a J2EE application which communicates with the Oracle Database by mapping browser requests to the Application Express engine database over a SQL*Net connection.

Oracle REST Data Services is fully supported against Oracle WebLogic Server and Apache Tomcat. In a production environment, you deploy Oracle REST Data Services web archive files to a supported Java EE application server, like Oracle Web Logic Server. Each deployment can be configured individually and serves the same purpose as a mod_plsql Database Access Descriptor, which is to communicate with an Oracle database.

Note:

There are licensing costs associated with Oracle WebLogic Server.