Contents

Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Third-Party License Information

1 Installing Oracle Application Express Listener

• About Oracle Application Express Listener
  • Supported Java Enterprise Edition Application Servers
• About System Requirements
• Oracle Application Express Listener Installation Overview
• Downloading Oracle Application Express Listener
• Installing in Standalone Mode
  • Install and Run in Standalone Mode
  • About Standalone Configuration Options
  • About Stopping the Server in Standalone Mode
  • About JServ Protocol (AJP) Support
• Installing with Oracle WebLogic Server
  • Download and Unzip Oracle Application Express Listener
  • Create Web Archive for Oracle Application Express Images
  • Launch the Administration Server Console
  • Install the Deployment
  • Create Users and Roles
  • Access Oracle Application Express Listener Administration
• Installing with Oracle GlassFish Server
  • Download and Unzip Oracle Application Express Listener
  • Copy Oracle Application Express Images
  • Launch the Administration Console
  • Create Users and Roles
  • Install the Deployment
  • Access Oracle Application Express Listener Administration
• Installing with Oracle Containers for J2EE (OC4J)
  • Download and Unzip Oracle Application Express Listener
  • Copy Oracle Application Express Images
  • Start the OC4J Server
  • Start the Application Server Control Console
  • Create Users and Roles
  • Install the Deployment
  • Access Oracle Application Express Listener Administration
• Upgrading Oracle Application Express Listener
  • Redeploy Oracle WebLogic Server
  • Redeploy Oracle GlassFish Server
  • Redeploy Oracle Containers for J2EE (OC4J)
• Upgrading Oracle Application Express Images
  • Copy Application Express Images When Using Oracle WebLogic Server
  • Copy Application Express Images When Using Oracle GlassFish Server
  • Copy Application Express Images When Using Oracle Containers for J2EE (OC4J)

2 Configuring Oracle Application Express Listener

• Accessing Oracle Application Express Listener
  • Access Oracle Application Express Listener Administration
  • View Status Information
• About Oracle Application Express Listener Administration
• Establishing a Database Connection
  • Establish a Basic Connection
  • Establish a TNS Connection
  • Establish an Advanced Connection
  • About JDBC Settings
• Configuring Security
  • About Allowed Procedures
  • About Blocked Procedures
  • About Database Validation Function
  • About Security Settings
  • Understanding Security Processing
• Defining Caching
  • Specify Procedure Names to Cache Files
• Creating Pre- Post Processing Procedures
  • About Pre-processing Procedures
  • About Post-processing Procedures
• Viewing Status
  • About Statistics
  • About Error Tracking
  • About Logging
• Configuring Miscellaneous Options

3 RESTful APIs and Resource Templates

• What is a RESTful API?
  • About Resource Templates
• About Resource Template Administration
  • Create a Resource Template
  • About the Entity Tag
  • About Resource Handlers
• About Resource Handler Types
  • Query
  • Comma Separated Values Query
  • Media Resource
  • PL/SQL Block
• Example: Creating an Image Gallery
  • Before You Begin
  • Create a Database Schema
  • Upload Images
  • Create an Image Upload Form
  • Display the Image
  • Display the Gallery
  • Improve the Appearance of the Gallery
  • About the RESTful API
• About Resource Template Security
  • Integration with Oracle Single Sign On
  • External Authentication Using Apache JServ Protocol
  • Example: Protecting Gallery Uploads

A About the Configuration File

• About the Listener Configuration File
  • Locating the Configuration File
  • Setting the Value of the config.dir Parameter
• Understanding Configuration File Parameters
• About Configurable Parameters

B Troubleshooting

• Oracle Application Express Images Not Displaying
• Cannot Log In to Oracle Application Express Listener Administration

Index