You are previewing Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF.
O'Reilly logo
Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF

Book Description

The most efficient way to learn J2EE programming techniques Two Oracle experts demonstrate techniques for working within J2EE and JDeveloper for the thousands of developers currently using Oracle Forms and the PL/SQL language. Oracle is shifting their focus towards Java technologies, so you will need to know how to use the Java-based J2EE and JDeveloper. The book includes explanations of the Application Development Framework (ADF).

Table of Contents

  1. Cover Page
  2. Oracle JDeveloper 10g for Forms & PL/SQL Developers
  3. Copyright Page
  4. Dedication
  5. About the Author
  6. Contents
  7. Foreword
  8. Acknowledgments
  9. Introduction
  10. PART I Technology Overviews
    1. 1 J2EE Basics
      1. What Do I Need to Know About Database Application Architecture?
      2. What Is J2EE?
        1. J2EE and Java EE 5
        2. J2EE Parts
        3. J2EE Platform
      3. What Non-J2EE Web Technologies Are Popular in J2EE Environments?
        1. User Interface Technologies
        2. Web Services
      4. How Do J2EE Architectures Differ from Traditional Architectures?
      5. How Do I Choose Between J2EE and Oracle Forms and Reports?
        1. Oracle’s Direction
        2. Oracle Forms or J2EE?
        3. Oracle Reports or J2EE?
      6. Should I Pay Attention to .NET?
      7. How Does Oracle Forms Services Fit into J2EE?
    2. 2 Web Communications
      1. How Does HTTP Work?
        1. HTTP Request
        2. HTTP Response
        3. Methods
        4. Other HTTP Features
      2. What Are the Steps in a Web Application Roundtrip?
      3. How Does Oracle Forms Services Use HTTP?
    3. 3 JDeveloper and ADF as RAD Tools
      1. What Do We Mean by RAD?
      2. What Is a Framework?
        1. The Anatomy of a Framework
        2. What Characterizes a Good Framework?
        3. Oracle Forms as a Framework
      3. What Is Oracle ADF?
        1. How Do I Choose Technologies?
        2. User Interface Technology
        3. Database Integration
      4. Why Is JDeveloper an IDE for RAD?
        1. A Familiar IDE?
        2. Getting Started with JDeveloper
        3. Laying Out the IDE
        4. Where Are the Wizards?
        5. The RAD Is in the Frameworks
    4. 4 Required Web Languages and Java Language Basics
      1. Which Languages Do I Really Need to Know?
        1. How Much Code Will I Need to Write?
        2. How Much of Which Languages Do I Need to Know?
      2. What Do I Need to Know About XML?
      3. Which Java Concepts Are Important?
        1. Java Foundations
        2. Control Structures
        3. Datatypes
        4. Operators
        5. Resources
    5. 5 JavaServer Faces Basics
      1. Why Was JSF Developed?
      2. What Languages Other than Java Are Important to JSF Work?
      3. What JSF Concepts Do I Really Need to Know Now?
        1. What Is JSF?
        2. Runtime Architecture
        3. JSF-Oriented Files
        4. Components
        5. Designing Cross-Platform Interfaces
      4. Where Can I Find Additional Information About JSF?
        1. Websites
        2. Printed Books
    6. 6 Business Services in ADF
      1. How Do I Issue a Query to the Database?
        1. 1. Set up an Application Workspace and Project for ADF Business Components
        2. 2. Create the Query Object
        3. 3. Define the Query
        4. 4. Expose the Query
        5. 5. Test the Query
      2. How Can I Update Data?
        1. 1. Create an Entity Object
        2. 2. Create an Updateable View Object
        3. 3. Define the View Object Attributes
        4. 4. Refine the View Object Query
        5. 5. Test the View Object
      3. How Do I Generate a Primary Key Value?
        1. Using a Database Trigger to Allocate Sequences
        2. Mutating Data
      4. How Do I Handle Transactions?
      5. How Does Record Locking Work?
        1. ADF Business Component Configurations
      6. Where Is the Login Dialog?
        1. Connection Pooling
        2. Security the J2EE Way
      7. How Do I Define Business Rules?
        1. Database Referential Integrity Constraints
        2. Data Content Validations
        3. Complex Validations and Rules
        4. Evaluation Order of Validations
      8. How Can I Dynamically Change a Query?
      9. How Can I Interface ADF BC with PL/SQL?
        1. Calling a Stored PL/SQL Procedure
        2. Returning Data from PL/SQL to ADF BC
        3. Basing a Entity Object on PL/SQL
    7. 7 The ADF Model Layer
      1. How Do I Create Data-Bound Pages?
        1. The Data Control Palette
        2. Using the Data Control Palette
        3. “Drop as” UI Options
      2. What Files Are Involved in Data Binding?
        1. Defining the Data Control
        2. Using the Data Control
        3. A Binding File Summary
    8. 8 ADF Model Advanced Bindings
      1. How Can I Edit Data Bindings?
        1. Attribute Bindings
        2. Table Bindings
        3. Action Bindings
        4. Method Bindings
        5. List Bindings
        6. Navigation List Bindings
        7. Boolean Bindings
        8. Tree Bindings
        9. Cleaning Up Bindings
      2. What Is an Iterator?
      3. How Can I Control Execution in the ADF Model?
        1. Another Look at Executables
        2. Overriding and Adding to the ADFm Life Cycle
      4. What Are Parameters?
        1. Populating Parameters
      5. How Do I Write Code Using the ADF Model?
        1. Access to Data and Methods
        2. Executing Methods and Operations
  11. PART II Developing the Application
    1. 9 Your First JSF
      1. Hands-on Practice: Create a JSF Login and JSF Home Page
        1. I. Create the Application Workspace and Project
        2. II. Diagram the Page Flow
        3. III. Create the Login and Home Pages
        4. IV. Add Components to the Login Page
        5. V. Add Components to the Home Page
        6. VI. Add Navigation and Validation Logic to the Application
      2. Centralizing Messages
      3. Hands-on Practice: Create and Call a Message Bundle
      4. Hands-on Practice: Access Message Bundle Messages with EL
    2. 10 Application Design Principles and Sample Application Overview
      1. System Design
        1. System Design Tools and the SDLC
        2. Application Design Considerations
        3. Best Practices
      2. Sample Application System Design
        1. Database Design
        2. Application Design
      3. Hands-on Practice: Create the Workspace and Projects
    3. 11 Home Page and Menus
      1. Hands-on Practice: Create the Home Page and Menus
        1. I. Prepare the Model Project
        2. II. Prepare the ViewController Project
        3. III. Create a Template
        4. IV. Copy the Template File and Customize the Copies
        5. V. Complete the Home Pages
    4. 12 Search Page
      1. Search and Edit Functions
      2. Hands-on Practice: Develop the Employee Search Page
        1. I. Prepare the Model Objects
        2. II. Add Components to the Search Page
        3. III. Refine the Search Page Functionality
    5. 13 Edit Page
      1. Hands-on Practice: Complete the Edit Page
        1. I. Prepare the Model Components
        2. II. Create the Employees Edit Page
        3. III. Finish Navigation from the Search Page
        4. IV. Build a Pulldown List and LOVs
    6. 14 Adding Security
      1. Application Security
        1. Security in Oracle Forms and Oracle Reports Applications
        2. Security in Web Applications
      2. Hands-on Practice: Set Up Security in the Sample Application
        1. I. Configure Container Security
        2. II. Define Application Security Settings
        3. III. Add Security to the User Interface
  12. PART III Additional Techniques
    1. 15 Sample Application Enhancements
      1. Hands-on Practice: Load Audit Columns Using a Database Procedure and Application Context
        1. I. Create the Database Objects
        2. II. Set the Context from the Application
      2. Hands-on Practice: Rename an ADF-Oriented JSF JSP File
      3. Prevent SQL Injection Attacks
        1. Securing Find Mode
      4. Invoke Partial Page Rendering
        1. Using PPR
        2. Hands-on Practice: Use PPR to Disable the Menu Until Outstanding Changes Are Committed
      5. Define Global Format Masks
        1. Hands-on Practice: Apply Standard Formatting to the Salary Field
    2. 16 Oracle JHeadstart
      1. What Is JHeadstart?
        1. JHeadstart Benefits
        2. Using JHeadstart
      2. Understanding the Application Definition
        1. Creating an Application Definition
        2. The Application Definition Editor
        3. Contents of the Application Definition
      3. Running the JHeadstart Application Generator
        1. Generator Templates
        2. Generator Outputs
        3. Making and Preserving Post-Generation Changes
      4. Running the Generated Application
        1. Examples of Generated Screens
        2. The Role of the JHeadstart Runtime
      5. JHeadstart Designer Generator
        1. Design-Capturing Oracle Forms in Oracle Designer
      6. Migrating Oracle Forms Applications
        1. Is the Application Suitable for a Partial Migration?
        2. How Do I Select a Migration Tool?
      7. Licensing, Support, and Other Resources
  13. Index