Tuhra Home Errata Code Listing Downloads
TUHRA Logo

Code Listings

Book Cover

Oracle JDeveloper 10g for Forms & PL/SQL Developers

A Guide to Web Development with Oracle ADF


This page provides links to the various code fragments used within the exercises in the book. Locate the fragment you need by chapter number and section in the list below:

Chapter 6 - Business Services in ADF
Using a Database Trigger to Allocate Sequences | Create the BEFORE INSERT Trigger
1. Script to create BEFORE INSERT trigger on Employees
Chapter 9 - Your First JSF
Add Navigation and Validation Logic to the Application
1. Backing bean loginButton_action()
Create and Call a Message Bundle
1. Code fragments to add to loginButton_action to access resources
2. Sample login message resource entries
Chapter 15 - Advanced Techniques
Loading Audit Columns Using a Database Procedure and Application Context | Create the Database Objects
1. Script to grant rights on SYS_CONTEXT to HR
2. Script to create and populate audit columns on EMPLOYEES
3. Script to create Context and security package
4. Script to create BEFORE INSERT trigger on EMPLOYEES
Loading Audit Columns Using a Database Procedure and Application Context | Set the Context from the Application
1. Application module method prepareSession()
Preventing SQL Injection Attacks | Securing Find Mode
1. View object method getViewCriteriaClause() for AllEmployeesImpl
2. View object method detectInjection() for AllEmployeesImpl