Oracle Application Server 10g Web Development (Oracle Press)

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

Related

Категории