List of Figures

Chapter 1: Overview of Technologies

Figure 1-1: Oracle Application Server 10g Architecture

Figure 1-2: A Middle- tier administration screen

Figure 1-3: Administration screen for the infrastructure

Figure 1-4: Common topologies

Figure 1-5: The Module Metrics page for the HTTP Server

Figure 1-6: An Oracle Form viewed through a web browser

Figure 1-7: An Oracle Report viewed through a web browser

Figure 1-8: An Oracle Discoverer worksheet viewed through a web browser

Figure 1-9: The Discoverer Plus development environment

Figure 1-10: A screen of the Portal development environment

Figure 1-11: Possible Web Cache topologies

Figure 1-12: The Web Cache administration screen

Figure 1-13: The TopLink Mapping Workbench

Figure 1-14: An HTML DB page

Chapter 2: Oracle Application Server 10 g Architecture

Figure 2-1: An Enterprise Manager web site page for application portal

Figure 2-2: The main page of an OC4J container

Figure 2-3: Components installed in the middle tier

Figure 2-4: Metrics of a Portal component

Figure 2-5: Metrics for users connecting to Oracle Application Server 10g via a Forms application

Figure 2-6: Page listing configuration files that can be edited via the Oracle Enterprise Manager Application Server Control web site

Figure 2-7: The User Manager section of the Properties page of a deployed application in the Enterprise Manager Application Server Control web site

Figure 2-8: The Security page for a deployed application

Figure 2-9: The home page for an OC4J instance

Figure 2-10: The Applications tab of an OC4J home page

Figure 2-11: A development directory structure

Figure 2-12: The Self-Service Console

Chapter 3: Oracle Forms 10 g

Figure 3-1: A graphical description of database tables and Oracle Forms 10g canvases

Figure 3-2: A graphical representation of windows , views, canvases, and items

Figure 3-3: Displaying a simple form in a web browser

Figure 3-4: The Forms Builder module

Figure 3-5: The New Data Block dialog box

Figure 3-6: The first step of the Data Block Wizard

Figure 3-7: The second step of the Data Block Wizard

Figure 3-8: The Tables dialog box

Figure 3-9: The Data Block Wizard with the selected table displayed

Figure 3-10: Entering a name for the data block

Figure 3-11: The final step of the Data Block Wizard

Figure 3-12: The first page of the Layout Wizard

Figure 3-13: The Layout Wizard with items selected

Figure 3-14: Setting item attributes in the Layout Wizard

Figure 3-15: Setting attributes for the frame in the Layout Wizard

Figure 3-16: Forms Builder after successfully generating the form

Figure 3-17: The generated form displayed in a web browser

Figure 3-18: The Layout Editor

Figure 3-19: Buttons in the Layout Editor

Chapter 4: Oracle Reports 10 g

Figure 4-1: The Object Navigator

Figure 4-2: The Property Inspector

Figure 4-3: The Report Editor window

Figure 4-4: The Web Source view of the Report Editor window

Figure 4-5: The Paper Layout view of the Report Editor window

Figure 4-6: The Paper Parameter Form view of the Report Editor window

Figure 4-7: The two PL/SQL editors in Oracle Reports 10g

Figure 4-8: The Database Trigger editor

Figure 4-9: Starting Report Builder in Unix

Figure 4-10: The First Reports Builder page

Figure 4-11: Objects owned by the HR schema

Figure 4-12: The Query Builder screen

Figure 4-13: An Oracle Report displayed in the Report Editor

Figure 4-14: The Reports Builder showing the Object Navigator

Figure 4-15: Reports Builder with the Property Inspector page displayed

Figure 4-16: Multiple selections in the Object Navigator

Figure 4-17: The example report with just countries in Asia

Figure 4-18: The Property Inspector showing the P_REGION report object

Figure 4-19: Adding static values to a reports parameter list

Figure 4-20: The Parameter Form Builder dialog box

Figure 4-21: Report output with filter applied to REGION_NAME

Figure 4-22: The Paper Layout view in the Report Editor

Figure 4-23: The Object Navigator with field F_REGION_NAME highlighted

Figure 4-24: A listing of the PL/SQL objects in the srw built-in package

Figure 4-25: The Conditional Formatting window

Figure 4-26: The Format Exception dialog box

Figure 4-27: A listing of the different graph types supported by Oracle Reports 10g

Figure 4-28: The report with the first version of the graph

Figure 4-29: The Object Navigator showing two queries and two groups

Figure 4-30: Selecting columns in the Graph Wizard

Figure 4-31: The report with the second version of the graph

Chapter 5: OracleAS Discoverer 10 g

Figure 5-1: The dialog to create an EUL

Figure 5-2: The first page of the Create EUL Wizard

Figure 5-3: The second step of the Load Wizard

Figure 5-4: The third step of the Load Wizard

Figure 5-5: The fourth page of the Load Wizard

Figure 5-6: The Create Public Connection screen for Discoverer

Figure 5-7: An error when trying to access an EUL in lowercase

Figure 5-8: Selecting the cd tables

Figure 5-9: Step 4 of the Load Wizard

Figure 5-10: The Select Discoverer Connection page

Figure 5-11: Step 1 of the Create Workbook Wizard

Figure 5-12: Selecting the detail of the rating column in the Workbook Wizard

Figure 5-13: The CD report

Figure 5-14: The Edit Worksheet window with Page Items selected

Figure 5-15: The CD report with the Page Items drop-down box

Figure 5-16: The Format tab of the Edit Worksheet window

Figure 5-17: A condition where the rating must be greater than or equal to 9

Figure 5-18: Enabling/disabling a condition

Figure 5-18: The report with the wrong calculation

Figure 5-19: The Edit Total page

Figure 5-21: The Create Parameter page

Figure 5-22: Prompting for a value in Discoverer Viewer

Figure 5-23: Viewing the new condition after parameter creation

Figure 5-24: Load Wizard step 4 for the new business area

Figure 5-25: Available columns in the cities, states, and stores tables

Figure 5-26: Crosstab dialog

Figure 5-27: The Crosstab layout page

Figure 5-28: The STATE_NAME field dragged into the y-axis

Figure 5-29: The report with STATE as the y-axis

Figure 5-30: Report drilled down to monthly level

Figure 5-31: Report drilled down to daily level

Figure 5-32: The Hierarchies tab in the Oracle Administrator desktop

Figure 5-33: Step 2 of the Hierarchy Wizard

Figure 5-34: Discoverer desktop with new hierarchy displayed

Figure 5-35: The store report with the state_city_hierarchy

Figure 5-36: Drilling down to the city level in the stores report

Figure 5-37: Drilling down on both city and date

Figure 5-38: The stores report in Discoverer Viewer

Figure 5-39: The second page of the Graph Wizard

Figure 5-40: Stores graph with Arizona and Utah collapsed

Figure 5-41: The graph in Discoverer Viewer

Figure 5-42: Exported data in Excel

Figure 5-43: Excel spreadsheet with drop-down boxes

Figure 5-44: The Presentation Options page in Discoverer Viewer

Chapter 6: Deploying Oracle Tools to the Web

Figure 6-1: The Forms Compiler Options window

Figure 6-2: The Forms Migration Assistant

Figure 6-3: The second page of the Forms Migration Assistant

Figure 6-4: The Converter Options page of the Forms Migration Assistant

Figure 6-5: Displaying the test form

Figure 6-6: The test form displayed with a shorter width

Figure 6-7: Forms prompting for a user login

Figure 6-8: Form displayed with bogus named configuration specified

Figure 6-9: The Reports converter executable

Figure 6-10: The login screen for Oracle Internet Directory

Figure 6-11: The Create User screen

Figure 6-12: The create resource section of the Create User screen

Figure 6-13: The Discoverer properties page in the Enterprise Manager Application Server web page

Figure 6-14: The Create Public Connection Screen for Discoverer

Figure 6-15: An error when trying to access an EUL in lowercase

Figure 6-16: Discoverer workbooks available

Chapter 7: The PL/SQL Web Toolkit and PSPs

Figure 7-1: A typical PL/SQL web application architecture

Figure 7-2: Database Access Descriptor Configuration

Figure 7-3: Apache web server home page

Figure 7-4: The resultant web page generated by the hello PL/SQL module

Figure 7-5: html_emp_list output

Figure 7-6: Output of hello program written with HTP.PRINT calls

Figure 7-7: Revised employee list page with photo image enhancement

Figure 7-8: A simple login form

Figure 7-9: GET Method side effect

Figure 7-10: Start page that results when called using the POST method

Figure 7-11: Output from the PSP version of the Hello Program

Figure 7-12: Output of the emps table data from table_dump.PSP

Chapter 8: Oracle Application Server PortalArchitecture

Figure 8-1: The initial Oracle Application Server Portal page

Figure 8-2: One-to-many relationship between pages, regions , and portlets

Figure 8-3: The Oracle Application Server Portal welcome page after a successful login

Figure 8-4: The Build tab displayed in Oracle Application Server Portal

Figure 8-5: The Customize Recent Objects portlet screen

Figure 8-6: The Portal subtab in the Administer tab

Figure 8-7: The Portlets subtab in the Administer tab

Figure 8-8: The Database subtab in the Administer tab

Figure 8-9: The Page Groups tab of the Portal Navigator

Figure 8-10: The Providers tab of the Oracle Application Server Portal Navigator

Figure 8-11: The Database Objects tab of the Oracle Application Server Portal Navigator

Figure 8-12: The Oracle Application Server Portal help system

Figure 8-13: The Create User page of the Oracle Internet Directory

Figure 8-14: The Roles Assignment section of the Create User page

Figure 8-15: The Locally Built Providers page

Figure 8-16: The Privileges tab of the Edit Portal User Profile screen

Figure 8-17: The Privileges tab for the PORTAL_DEVELOPERS group

Figure 8-18: The Locally Built Providers page of the Portal Navigator with the Create New Database Provider link available

Figure 8-19: The Create Portal Database Provider screen

Figure 8-20: The Grant Access page

Figure 8-21: The Create Provider page with the available Chris schema

Figure 8-22: The Create Portal DB Provider screen

Figure 8-23: The first page of the Oracle Application Server Portal Form wizard

Figure 8-24: The first step of the Oracle Application Server Portal Create Form wizard

Figure 8-25: Step 3 of the Oracle Application Server Portal Form wizard

Figure 8-26: The search dialog

Figure 8-27: Step 4 of the Oracle Application Server Portal Form wizard

Figure 8-28: Step 5 of the Oracle Application Server Portal Form wizard

Figure 8-29: Step 5 of the Oracle Application Server Portal Form wizard with the EMPNO field selected

Figure 8-30: Step 7 of the Oracle Application Server Portal Form wizard

Figure 8-31: The preview template window

Figure 8-32: Step 8 of the Oracle Application Server Portal Form wizard

Figure 8-33: The Manage Component screen

Figure 8-34: The completed form displayed as a portlet

Figure 8-35: The completed form run as a web form

Figure 8-36: The Formatting and Validation Options screen

Figure 8-37: Modifying the ENAME field in the portal form wizard

Figure 8-38: The Manage Component screen for the form after our first modification

Figure 8-39: The Create Page Group screen

Figure 8-40: The root page in Graphical mode

Figure 8-41: The Add Portlets page displaying the Portlet Repository

Figure 8-42: Selecting the First_Portal_Form portlet

Figure 8-43: Graphically editing the page with the First_Portal_Form portlet placed on it

Figure 8-44: The portal page with two regions and two portlets

Chapter 9: OracleAS PortalDevelopmentThe Basic OracleAS Portal Components

Figure 9-1: A comparison of waterfall and RAD methodologies

Figure 9-2: The OracleAS Portal Navigator with the First Portal App provider selected

Figure 9-3: The first page of the Create New Form Wizard

Figure 9-4: The PL/SQL code generated for a simple OracleAS Portal Form

Figure 9-5: The Form Layout page of the OracleAS Portal Form Wizard

Figure 9-6: Records returned in a tabular format

Figure 9-7: The Manage screen for OracleAS Portal components

Figure 9-8: The Navigator page listing the completed form

Figure 9-9: The first page of the OracleAS Portal Report Wizard

Figure 9-10: The first step of the OracleAS Portal Reports Wizard

Figure 9-11: The Search dialog

Figure 9-12: The Search dialog attempting to search on the link name

Figure 9-13: The TEST@IASDB table specified in the Table or View page of the Reports Wizard

Figure 9-14: The Table or View Columns page of the Report Wizard

Figure 9-15: The Column Formatting page

Figure 9-16: The Formatting Conditions page

Figure 9-17: The Display Options page

Figure 9-18: The Customizations From Display Options page

Figure 9-19: The first page of the Chart Wizard

Figure 9-20: The Table or View page of the OracleAS Chart Wizard

Figure 9-21: A chart based on a multi-table query

Figure 9-22: The Table or View Columns page of the OracleAS Chart Wizard

Figure 9-23: The Display Options page of the OracleAS Portal Chart Wizard

Figure 9-24: The Customization Form Display Options page of the OracleAS Portal Chart Wizard

Figure 9-25: An OracleAS Portal Chart run with default values

Figure 9-26: The first page of the Dynamic Page Wizard

Figure 9-27: The second page of the Dynamic Page Wizard

Figure 9-28: The PL/SQL Code Segments page

Figure 9-29: The Customization From Display Options page

Figure 9-30: A Dynamic Page displayed as a portlet

Figure 9-31: The different formats in which an LOV can be displayed

Figure 9-32: The first page of the LOV wizard

Figure 9-33: Example creation of a static LOV

Figure 9-34: Example creation of a dynamic LOV

Figure 9-35: Editing the OracleAS Portal chart from earlier in this chapter

Figure 9-36: Adding the LOV to the chart

Figure 9-37: The customize screen for the chart

Figure 9-38: The OracleAS Portal Chart displaying only Browns data

Figure 9-39: The first page of the XML Component Wizard

Figure 9-40: The second page of the XML Component Wizard

Figure 9-41: The XML Code page of the XML Component Wizard

Figure 9-42: The DTD code page of the XML Component Wizard

Figure 9-43: The Customization Form Display Options page

Figure 9-44: The XML component run as a portlet

Chapter 10: Advanced Oracle Application Server Portal Components

Figure 10-1: The first step of the Calendar Wizard

Figure 10-2: The third step of the Oracle Application Server Portal Calendar Wizard

Figure 10-3: The Formatting Conditions page of the Oracle Application Server Portal Calendar Wizard

Figure 10-4: The Display Options page of the Oracle Application Server Portal Calendar Wizard

Figure 10-5: The Customization Form Display Options page of the Oracle Application Server Portal Calendar Wizard

Figure 10-6: The Calendar object with employee 7499 displayed

Figure 10-7: The fourth step of the Oracle Application Server Portal Hierarchy Wizard

Figure 10-8: The Display Options Page of the Hierarchy Wizard

Figure 10-9: The Customization form Display Options page of the hierarchy wizard

Figure 10-10: The completed hierarchy

Figure 10-11: The Menu Items and Submenus page of the Oracle Application Server Portal Menu Wizard

Figure 10-12: The third step of the Oracle Application Server Portal Menu wizard

Figure 10-13: The second page of the Oracle Application Server Portal Link Wizard

Figure 10-14: The Search Dialog for the Link Wizard

Figure 10-15: Step 3 of the Oracle Application Server Portal Link Wizard

Figure 10-16: The Portal Developer Kit download page

Figure 10-17: Parameters for the link

Figure 10-18: The report with links run as a portlet

Figure 10-19: The calendar displaying Smiths record

Figure 10-20: The edit/customize page of the Oracle Application Server Portal Data Component Wizard

Figure 10-21: The Page Groups tab displayed in the Navigator

Figure 10-22: The Edit Page screen of Oracle Application Server Portal

Figure 10-23: The Add Portlets page

Figure 10-24: The Edit Page screen with a portlet rendered

Figure 10-25: The Edit Region page

Figure 10-26: The page with two equally- sized regions on it

Figure 10-27: A page with a style applied to it

Figure 10-28: The Edit Template Page screen

Figure 10-29: The Create Page Wizard after a template has been selected

Figure 10-30: The edit screen for the navigation page

Figure 10-31: The properties page for the page group

Figure 10-32: The properties page for the page

Figure 10-33: The Page Groups tab of the Oracle Application Server Portal Navigator

Figure 10-34: The Edit Page screen for the default page of the new page group

Figure 10-35: The Add item Wizard

Figure 10-36: The Item Attributes page for the item we wish to add

Figure 10-37: The Edit Page screen displaying the newly added content

Figure 10-38: The Selected Portlets window

Figure 10-39: The Search results window

Figure 10-40: The list of procedures/functions in the www_context package

Figure 10-41: The Search page returing expected results

Figure 10-42: The Edit Page screen with an Advanced Search portlet placed on it

Chapter 11: Integrating Forms, Reports, and Discoverer into Portal

Figure 11-1: The Enterprise Manager Application Control Farm page

Figure 11-2: The Enterprise Manager Web Page for the middle tier

Figure 11-3: The showjobs page for the Reports Server

Figure 11-4: The main page of the Application Server

Figure 11-5: Testing the Reports Server

Figure 11-6: Specifying the reports URL

Figure 11-7: Adding a portlet to a region

Figure 11-8: The Portal subtab of the Administer tab

Figure 11-9: The Oracle Reports Security Page

Figure 11-10: The Configure page for OracleAS Portal Reports access

Figure 11-11: The test page for the Oracle Forms Server

Figure 11-12: Specifying the Oracle Forms URL for the OracleAS Portal component

Figure 11-13: Testing the Discoverer Portlet Provider

Figure 11-14: The Portlets subtab of the Administer tab

Figure 11-15: Registering the OracleAS Discoverer Portlet

Figure 11-16: Specifying an OracleAS Discoverer connection

Figure 11-17: The available portlets of the discoverer_provider

Figure 11-18: Attempting to display the Oracle Discoverer Worksheet

Figure 11-19: The first page of the Edit Worksheet Portlet Defaults Wizard

Figure 11-20: The second page of the Edit Worksheet Portlet Defaults Wizard

Figure 11-21: The third page of the Edit Worksheet Portlet Defaults Wizard

Figure 11-22: The fifth page of the Edit Worksheet Portlet Defaults Wizard

Figure 11-23: The sixth page of the Edit Worksheet Portlet Defaults Wizard

Figure 11-24: The seventh and final page of the Edit Worksheet Portlet Defaults Wizard

Figure 11-25: The Discoverer Worksheet displayed in graphical mode

Figure 11-26: The Discoverer Worksheet displayed as an OracleAS Portal portlet

Chapter 13: Oracle JDeveloper 10 g

Figure 13-1: The initial Oracle JDeveloper 10g screen

Figure 13-2: The Create Application Workspace dialog box

Figure 13-3: The Project Properties dialog box

Figure 13-4: Oracle JDeveloper10g in design mode

Figure 13-5: The Create Palette Page dialog box

Figure 13-6: The Add JSP Tag Components dialog box

Figure 13-7: The Connections view of the Oracle JDeveloper 10g Navigator

Figure 13-8: Application settings for our first Oracle JDeveloper 10g project

Figure 13-9: Displaying the output of the HelloWorld.java program

Figure 13-10: Oracle JDeveloper 10g debugger navigation tool buttons

Figure 13-11: The Oracle ADF framework

Figure 13-12: The model-view-controller framework

Figure 13-13: The structure of the EMP table viewed in the Editor pane

Figure 13-14: Example of a custom query using the SQL worksheet

Figure 13-15: Creation of the EMP entity object

Figure 13-16: Editing the entity object

Figure 13-17: Adding a view object to the business components diagram

Figure 13-18: A fully designed JSP page

Figure 13-19: The HelloWorld application running in a web browser

Figure 13-20: The updated business components diagram

Figure 13-21: The application reflecting the addition of the drop-down graphical object

Figure 13-22: Running the new DEPT page

Figure 13-23: The completed Struts config diagram

Chapter 14: JavaServer Pages

Figure 14-1: The Page Types and Template screen in Oracle Application Server Portal

Figure 14-2: The Page Types section

Figure 14-3: The Create Page screen with JSP selected

Figure 14-4: The JSP displayed in Oracle Application Server Portal

Chapter 15: Deploying EARs, WARs, JARs, and JSPs

Figure 15-1: The directory structure outlined by the J2EE specification

Figure 15-2: The mid-tier components page

Figure 15-3: The mid-tier components page with the new OC4J instance displayed

Figure 15-4: The Administration tab of the new OC4J instance

Figure 15-5: The deployed applications tab of the OC4J instance named OC4J_Portal

Figure 15-6: The Applications tab of the OC4J component

Figure 15-7: The first page of the Deploy Application Wizard

Figure 15-8: The URL Mapping page of the Deploy Application Wizard

Figure 15-9: The User Manager screen of the Deploy Application wizard

Figure 15-10: Specifying the Application Server connection type

Figure 15-11: The third step of the Application Server Connection Wizard

Figure 15-12: The EJB JAR Deployment Profile Properties screen

Figure 15-13: Creating the JAR file

Figure 15-14: The WAR Deployment Profile Properties screen

Figure 15-15: Selecting the deployment location

Figure 15-16: The Application Assembly screen

Figure 15-17: Specifying the home directory of the application server middle tier

Figure 15-18: The ADF Runtime installer status window

Chapter 17: Web Services

Figure 17-1: Web Services conceptual overview

Figure 17-2: The Applications Navigator

Figure 17-3: Name your application

Figure 17-4: Add a file to the project

Figure 17-5: Add the project source path

Figure 17-6: Options for the java class

Figure 17-7: The New Gallery window

Figure 17-8: Step 1 of 3 in the Web Service wizard

Figure 17-9: Step 2 of 3 in the Web Service wizard

Figure 17-10: Step 3 of 3 in the Web Service wizard

Figure 17-11: Create Web Service finishing page

Figure 17-12: Applications Navigator with new Web Service object

Figure 17-13: Web Service structure

Figure 17-14: Edit Web Service object

Figure 17-15: Web Service for DOMESTICTAPI

Figure 17-16: Methods tab for DOMESTICTAPI

Figure 17-17: The Why not? Button and its functionality

Figure 17-18: Confirmation for generation

Figure 17-19: The Create PL/SQL Web Service welcome page

Figure 17-20: Step 1 of 3 for create PL/SQL Web Service wizard

Figure 17-21: Selecting program units to expose in the Web Service

Figure 17-22: Step 3 of 3 for the PL/SQL Web Service wizard

Figure 17-23: PL/SQL Web Service generator

Figure 17-24: Editing project libraries

Figure 17-25: Web Archieve (WAR) deployment profile library settings

Figure 17-26: Deploy the Web Service

Figure 17-27: DatabaseStatus browser home page filled in

Figure 17-28: databaseUp methods home page

Figure 17-29: Results of the databaseUp method Web Service execution

Figure 17-30: DOMETICTAPI browser home page filled in

Figure 17-31: Results of the fetch TableSet method execution

Figure 17-32: Results of the getEmp methods execution

Figure 17-33: Generate the Web Service stub wizard

Figure 17-34: Step 1 of 2

Figure 17-35: A TCP packet monitor menu option

Figure 17-36: A TCP packet monitor