Flylib.com
List of Figures
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
Oracle Application Server 10g Web Development (Oracle Press)
ISBN: 0072255110
EAN: 2147483647
Year: 2004
Pages: 192
Authors:
Chris Ostrowski
,
Bradley Brown
BUY ON AMAZON
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Managing Project Constraints and Documenting Risks
Managing Activity Risks
Managing Project Risk
Closing Projects
Appendix A Selected Detail From the PERIL Database
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Basic Database Terminology
Defining the Data Type in PostgreSQL
Client 3Processing Queries
Managing User Accounts
Internationalization and Localization
Special Edition Using Crystal Reports 10
Understanding the Value of Parameters
Introduction to Crystal Repository
Why Implement the Crystal Repository?
Introduction
Implementing the Interactive Viewer
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Multiplexing
Establishing Communications Channels
Signaling Systems
Intelligent Networks
Beyond 3G
Cultural Imperative: Global Trends in the 21st Century
From 2,000,000 B.C. to A.D.2000: The Roots and Routes of Culture
Culture and Climate
Cross-Century Worldviews
Cognitive Processes
Appendix C National Traits
The Oracle Hackers Handbook: Hacking and Defending Oracle
Overview of the Oracle RDBMS
The Oracle Network Architecture
Indirect Privilege Escalation
Attacking Oracle PL/SQL Web Applications
Appendix A Default Usernames and Passwords
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies