Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview of Oracle Discoverer 3i Viewer

1.1 Introduction

1.2 Oracle Discoverer 3i Viewer and Oracle Internet Application Server

1.3 Oracle Discoverer 3i Viewer in context

1.4 The n- tiered architecture of Oracle Discoverer 3i Viewer

1.4.1 First tier - the Client

1.4.2 Second tier - the HTTP Server

1.4.2.1 What is a Servlet?

1.4.2.2 What is a Servlet Engine?

1.4.2.3 HTTP Server Components

1.4.3 Third tier - Discoverer Services

1.4.3.1 Discoverer Services Components

1.4.4 Fourth tier - the database

1.5 How Oracle Discoverer 3i Viewer Works

1.5.1 The Oracle Discoverer 3i Viewer process

1.5.2 Oracle Discoverer 3i Viewer Architecture

1.5.3 Invoking Oracle Discoverer 3i Viewer

1.5.4 Processing the HTTP request

1.5.4.1 Application and Presentation Logic

1.5.5 Scalability and load balancing

2 Running, Maintaining and Supporting Discoverer 3i Viewer

2.1 Running Discoverer 3i Viewer

2.2 Maintaining Discoverer 3i Viewer

2.3 Seeing Registered Discoverer Server Objects

2.4 Editing End User Preferences

2.5 Registering and Unregistering Objects

2.5.1 Registering and Unregistering Individual Component(s)

2.5.1.1 To Register the Preferences and Session with the OAD

2.5.1.2 To Unregister Objects from OAD

2.6 Shutting Down

2.6.1 Shutting down the entire Discoverer 3i system

2.7 Restarting Discoverer 3i System

2.7.1 Restarting Discoverer 3i system using shell files

2.8 Setting up a secure link using HTTPS

2.9 Frequently Asked Questions

3 Accessing Oracle Discoverer 3i Viewer From Other Web Applications

3.1 Using Parameters in URLs

3.1.1 Specifying username, database

3.1.2 Specifying display of the Applications User Checkbox in Connect Dialog

3.1.3 Specifying a workbook in a URL:

3.1.4 Specifying a worksheet

3.1.5 Specifying worksheet parameters

3.1.6 Specifying a page number

4 Customizing Oracle Discoverer 3i Viewer

4.1 Using Oracle Discoverer 3i Viewer for Customized Web Applications

4.1.1 Steps to Generate the HTML needed to build a specific Discoverer Application

4.1.1.1 Step 1 Browser sends URL

4.1.1.2 Step 2 XML generation

4.1.1.3 Step 3 Apply XSL

4.1.1.4 Step 4 Generate HTML

4.2 Customization Examples

4.2.1 Files needed for customization

4.2.2 Quick Customization

4.2.2.1 Quick customization attributes

4.2.2.2 Quick customization steps

4.2.2.3 Example of editing the style.xsl file

4.2.3 Full Customization

4.2.3.1 Background

4.2.3.2 Prerequisites

4.2.3.3 File Structure

4.2.3.4 Servlet Programming Interface

4.2.3.5 Customizing Look and Feel - XML/XSL Example

4.2.4 Video Stores Demo - an example of an alternative user interface

4.2.4.1 What is installed

4.2.4.2 Set up steps

4.2.4.3 Set up Web Server

4.2.4.4 Run the Video Stores demo

4.2.4.5 Modify the video.xsl file

4.2.5 Customization Summary

Index