Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF

by Koletzke, Peter; Mills, Duncan

• ISBN13: 9780072259605
• ISBN10: 0072259604
• Edition: 1st
• Format: Paperback
• Copyright: 2006-09-28
• Publisher: McGraw-Hill Education

Summary

The most efficient way to learn J2EE programming techniquesTwo 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). Throughout, high-level and low-level Forms concepts are related to Java concepts so that you can become comfortable with the new terminology. Covers the new components required when developing and deploying a J2EE application Special mentions in the text describe how JDeveloper techniques translate to PL/SQL or Oracle Forms Covers JDeveloper 10.1.3 and ADF Faces All code and examples will be available online

Author Biography

Peter Koletzke, an Oracle Certified Master, is the Technical Director and Principal Instructor at Quovera.

Duncan Mills is Senior Principal Product Manager of Application Development Tools at Oracle Corporation.

Table of Contents

Foreword	xi
Acknowledgments	xiii
Introduction	xvii
PART I Technology Overviews
J2EE Basics	3	(28)
What Do I Need to Know About Database Application Architecture?	5	(2)
What Is J2EE?	7	(12)
J2EE and Java EE 5	7	(1)
J2EE Parts	8	(1)
J2EE Platform	9	(10)
What Non-J2EE Web Technologies Are Popular in J2EE Environments?	19	(4)
User Interface Technologies	19	(3)
Web Services	22	(1)
How Do J2EE Architectures Differ from Traditional Architectures?	23	(1)
How Do I Choose Between J2EE and Oracle Forms and Reports?	24	(4)
Oracle's Direction	24	(1)
Oracle Forms or J2EE?	25	(2)
Oracle Reports or J2EE?	27	(1)
Should I Pay Attention to .NET?	28	(1)
How Does Oracle Forms Services Fit into J2EE?	28	(3)
Web Communications	31	(14)
How Does HTTP Work?	32	(8)
HTTP Request	33	(3)
HTTP Response	36	(3)
Methods	39	(1)
Other HTTP Features	40	(1)
What Are the Steps in a Web Application Roundtrip?	40	(3)
How Does Oracle Forms Services Use HTTP?	43	(2)
JDeveloper and ADF as RAD Tools	45	(34)
What Do We Mean by RAD?	46	(2)
What Is a Framework?	48	(6)
The Anatomy of a Framework	48	(2)
What Characterizes a Good Framework?	50	(2)
Oracle Forms as a Framework	52	(2)
What Is Oracle ADF?	54	(7)
How Do I Choose Technologies?	56	(1)
User Interface Technology	57	(2)
Database Integration	59	(2)
Why Is JDeveloper an IDE for RAD?	61	(18)
A Familiar IDE?	62	(1)
Getting Started with JDeveloper	63	(8)
Laying Out the IDE	71	(2)
Where Are the Wizards?	73	(3)
The RAD Is in the Frameworks	76	(3)
Required Web Languages and Java Language Basics	79	(28)
Which Languages Do I Really Need to Know?	80	(3)
How Much Code Will I Need to Write?	81	(1)
How Much of Which Languages Do I Need to Know?	82	(1)
What Do I Need to Know About XML?	83	(2)
Which Java Concepts Are Important?	85	(22)
Java Foundations	85	(12)
Control Structures	97	(3)
Datatypes	100	(3)
Operators	103	(1)
Resources	104	(3)
JavaServer Faces Basics	107	(28)
Why Was JSF Developed?	109	(1)
What Languages Other than Java Are Important to JSF Work?	110	(8)
What JSF Concepts Do I Really Need to Know Now?	118	(15)
What Is JSF?	118	(1)
Runtime Architecture	119	(3)
JSF-Oriented Files	122	(3)
Components	125	(7)
Designing Cross-Platform Interfaces	132	(1)
Where Can I Find Additional Information About JSF?	133	(2)
Websites	133	(1)
Printed Books	134	(1)
Business Services in ADF	135	(50)
How Do I Issue a Query to the Database?	136	(9)
Set up an Application Workspace and Project for ADF Business Components	137	(1)
Create the Query Object	137	(1)
Define the Query	138	(3)
Expose the Query	141	(2)
Test the Query	143	(2)
How Can I Update Data?	145	(4)
Create an Entity Object	146	(1)
Create an Updateable View Object	147	(1)
Define the View Object Attributes	148	(1)
Refine the View Object Query	148	(1)
Test the View Object	149	(1)
How Do I Generate a Primary Key Value?	149	(5)
Using a Database Trigger to Allocate Sequences	150	(3)
Mutating Data	153	(1)
How Do I Handle Transactions?	154	(4)
How Does Record Locking Work?	158	(5)
ADF Business Component Configurations	159	(4)
Where Is the Login Dialog?	163	(1)
Connection Pooling	163	(1)
Security the J2EE Way	163	(1)
How Do I Define Business Rules?	164	(10)
Database Referential Integrity Constraints	164	(4)
Data Content Validations	168	(2)
Complex Validations and Rules	170	(2)
Evaluation Order of Validations	172	(2)
How Can I Dynamically Change a Query?	174	(3)
How Can I Interface ADF BC with PL/SQL?	177	(8)
Calling a Stored PL/SQL Procedure	177	(3)
Returning Data from PL/SQL to ADF BC	180	(2)
Basing a Entity Object on PL/SQL	182	(3)
The ADF Model Layer	185	(28)
How Do I Create Data-Bound Pages?	186	(14)
The Data Control Palette	187	(1)
Using the Data Control Palette	188	(1)
``Drop as'' UI Options	189	(11)
What Files Are Involved in Data Binding?	200	(13)
Defining the Data Control	200	(5)
Using the Data Control	205	(7)
A Binding File Summary	212	(1)
ADF Model Advanced Bindings	213	(52)
How Can I Edit Data Bindings?	214	(32)
Attribute Bindings	216	(2)
Table Bindings	218	(4)
Action Bindings	222	(8)
Method Bindings	230	(2)
List Bindings	232	(5)
Navigation List Bindings	237	(1)
Boolean Bindings	238	(1)
Tree Bindings	239	(7)
Cleaning Up Bindings	246	(1)
What Is an Iterator?	246	(4)
How Can I Control Execution in the ADF Model?	250	(7)
Another Look at Executables	251	(2)
Overriding and Adding to the ADFm Life Cycle	253	(4)
What Are Parameters?	257	(1)
Populating Parameters	257	(1)
How Do I Write Code Using the ADF Model?	258	(7)
Access to Data and Methods	258	(3)
Executing Methods and Operations	261	(4)
PART II Developing the Application
Your First JSF	265	(44)
Hands-on Practice: Create a JSF Login and JSF Home Page	266	(37)
Create the Application Workspace and Project	268	(4)
Diagram the Page Flow	272	(2)
Create the Login and Home Pages	274	(8)
Add Components to the Login Page	282	(10)
Add Components to the Home Page	292	(6)
Add Navigation and Validation Logic to the Application	298	(5)
Centralizing Messages	303	(2)
Hands-on Practice: Create and Call a Message Bundle	305	(1)
Hands-on Practice: Access Message Bundle Messages with EL	306	(3)
Application Design Principles and Sample Application Overview	309	(24)
System Design	310	(10)
System Design Tools and the SDLC	310	(2)
Application Design Considerations	312	(5)
Best Practices	317	(3)
Sample Application System Design	320	(11)
Database Design	320	(2)
Application Design	322	(9)
Hands-on Practice: Create the Workspace and Projects	331	(2)
Home Page and Menus	333	(32)
Hands-on Practice: Create the Home Page and Menus	334	(31)
Prepare the Model Project	335	(6)
Prepare the ViewController Project	341	(2)
Create a Template	343	(13)
Copy the Template File and Customize the Copies	356	(5)
Complete the Home Pages	361	(4)
Search Page	365	(50)
Search and Edit Functions	366	(1)
Hands-on Practice: Develop the Employee Search Page	367	(48)
Prepare the Model Objects	368	(20)
Add Components to the Search Page	388	(8)
Refine the Search Page Functionality	396	(19)
Edit Page	415	(34)
Hands-on Practice: Complete the Edit Page	416	(33)
Prepare the Model Components	417	(5)
Create the Employees Edit Page	422	(11)
Finish Navigation from the Search Page	433	(5)
Build a Pulldown List and LOVs	438	(11)
Adding Security	449	(36)
Application Security	450	(7)
Security in Oracle Forms and Oracle Reports Applications	450	(1)
Security in Web Applications	450	(7)
Hands-on Practice: Set Up Security in the Sample Application	457	(28)
Configure Container Security	458	(3)
Define Application Security Settings	461	(15)
Add Security to the User Interface	476	(9)
PART III Additional Techniques
Sample Application Enhancements	485	(26)
Hands-on Practice: Load Audit Columns Using a Database Procedure and Application Context	487	(9)
Create the Database Objects	488	(4)
Set the Context from the Application	492	(4)
Hands-on Practice: Rename an ADF-Oriented JSF JSP File	496	(1)
Prevent SQL Injection Attacks	497	(8)
Securing Find Mode	499	(6)
Invoke Partial Page Rendering	505	(4)
Using PPR	505	(2)
Hands-on Practice: Use PPR to Disable the Menu Until Outstanding Changes Are Committed	507	(2)
Define Global Format Masks	509	(2)
Hands-on Practice: Apply Standard Formatting to the Salary Field	509	(2)
Oracle JHeadstart	511	(30)
What Is JHeadstart?	512	(3)
JHeadstart Benefits	512	(1)
Using JHeadstart	513	(2)
Understanding the Application Definition	515	(8)
Creating an Application Definition	515	(1)
The Application Definition Editor	516	(1)
Contents of the Application Definition	517	(6)
Running the JHeadstart Application Generator	523	(5)
Generator Templates	524	(1)
Generator Outputs	524	(2)
Making and Preserving Post-Generation Changes	526	(2)
Running the Generated Application	528	(5)
Examples of Generated Screens	528	(4)
The Role of the JHeadstart Runtime	532	(1)
JHeadstart Designer Generator	533	(2)
Design-Capturing Oracle Forms in Oracle Designer	534	(1)
Migrating Oracle Forms Applications	535	(3)
Is the Application Suitable for a Partial Migration?	536	(1)
How Do I Select a Migration Tool?	536	(2)
Licensing, Support, and Other Resources	538	(3)
Index	541