book

Oracle JDeveloper 11gR2 Cookbook

Name: Oracle JDeveloper 11gR2 Cookbook
Author: Nick Haralabidis
ISBN: 9781849684767

by Nick Haralabidis

January 2012

Intermediate to advanced

406 pages

11h 11m

English

Packt Publishing

Read now

Unlock full access

Oracle JDeveloper 11gR2 Cookbook
Table of Contents
Oracle JDeveloper 11gR2 Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and moreWhy Subscribe?Free Access for Packt account holdersInstant Updates on New Packt Books
Preface
What this book covers
What you need for this book

Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example codeErrataPiracyQuestions
1. Prerequisites to Success: ADF Project Setup and Foundations
Introduction
Installation of JDeveloper on Linux
Getting readyHow to do it...How it works...There's more...Configuring JDeveloper with a 64-bit JDKConfiguring the JDeveloper user directory
Breaking up the application in multiple workspaces
How to do it…How it works…There's more…Adding the ADF Library JAR manuallyDefining the application module granularityEntity objects, list of values (LOVs), validation queries
Setting up BC base classes
Getting readyHow to do it…How it works…There's more…See also
Setting up logging
Getting readyHow to do it…How it works…There's more…See also
Using a custom exception class
Getting readyHow to do it…How it works…There's more…Bundled ExceptionsSee also
Using ADFUtils/JSFUtils
Getting readyHow to do it…How it works…Locating an iterator bindingLocating an operation bindingLocating an attribute bindingGetting and setting an attribute binding valueGetting the binding containerAdding Faces messagesFinding a component in the root viewGetting and setting managed bean values
Using page templates
Getting readyHow to do it…How it works…There's more…
Using a generic backing bean actions framework
Getting readyHow to do it…How it works…There's more…See also
2. Dealing with Basics: Entity Objects
Introduction
Using a custom property to populate a sequence attribute
Getting readyHow to do it...How it works...There's more...See also
Overriding doDML() to populate an attribute with a gapless sequence
Getting readyHow to do it...How it works...There's more...See also
Creating and applying property sets
getting readyHow to do it...How it works...There's more...See also
Using getPostedAttribute() to determine the posted attribute's value
Getting readyHow to do it...How it works...See also
Overriding remove() to delete associated children entities
Getting readyHow to do it...How it works...There's more...
Overriding remove() to delete a parent entity in an association
Getting readyHow to do it...How it works...There's more...See also
Using a method validator based on a view object accessor
Getting readyHow to do it…How it works...There's more...See also
Using Groovy expressions to resolve validation error message tokens
Getting readyHow to do it...How it works...See also
Using doDML() to enforce a detail record for a new master record
Getting readyHow to do it...How it works...See also
3. A Different Point of View: View Object Techniques
Introduction
Iterating a view object using a secondary rowset iterator
Getting readyHow to do it...How it works...There's more...Pitfalls when iterating over large rowsetsSee also
Setting default values for view row attributes
Getting readyHow to do it...How it works...There's more...Specifying default values at the entity object levelSee also
Controlling the updatability of view object attributes programmatically
Getting readyHow to do it...How it works...There's more...Controlling attribute updatability at the entity object levelSee also
Setting the Queryable property of a view object attribute programmatically
Getting readyHow to do it...How it works...There's more...See also
Using a transient attribute to indicate a new view object row
Getting readyHow to do it...How it works...There's more...See also
Conditionally inserting new rows at the end of the rowset
Getting readyHow to do it...How it works...There's more...Inserting new rows at the beginning of the rowsetSee also
Using findAndSetCurrentRowByKey() to set the view object currency
Getting readyHow to do it...How it works...There's more...Range paging optimizationSee also
Restoring the current row after a transaction rollback
Getting readyHow to do it…How it works...There's more...See also
Dynamically changing the WHERE clause of the view object query
Getting readyHow to do it...How it works...There's more...See also
Removing a row from a rowset without deleting it from the database
Getting readyHow to do it...How it works...There's more...See also
4. Important Contributors: List of Values, Bind Variables, View Criteria
Introduction
Setting up multiple LOVs using a switcher attribute
Getting readyHow to do it...How it works...There's more...See also
Setting up cascading LOVs
Getting readyHow to do it...How it works...There's more...See also
Creating static LOVs
Getting readyHow to do it...How it works...There's more...See also
Overriding bindParametersForCollection() to set a view object bind variable
Getting readyHow to do it...How it works...There's more...See also
Creating view criteria programmatically
Getting readyHow to do it...How it works...There's more...See also
Clearing the values of bind variables associated with the view criteria
Getting readyHow to do it...How it works...There's more...See also
Searching case insensitively using view criteria
Getting readyHow to do it...How it works...There's more...See also
5. Putting them all together: Application Modules
Introduction
Creating and using generic extension interfaces
Getting readyHow to do it…How it works…There's more…See also
Exposing a custom method as a web service
Getting readyHow to do it…How it works…There's more…See also
Accessing a service interface method from another application module
Getting readyHow to do it…How it works…There's more…See also
A passivation/activation framework for custom session-specific data
Getting readyHow to do it…How it works…There's more…See also
Displaying application module pool statistics
Getting readyHow to do it…How it works…There's more…See also
Using a shared application module for static lookup data
Getting readyHow to do it…How it works...There's more...See also
Using a custom database transaction
Getting readyHow to do it...How it works...There's more...See also
6. Go with the Flow: Task Flows
Introduction
Using an application module function to initialize a page
Getting readyHow to do it…How it works…There's more…See also
Using a task flow initializer to initialize a task flow
Getting readyHow to do it…How it works…There's more…See also
Calling a task flow as a URL programmatically
Getting readyHow to do it…How it works…There's more…See also
Retrieving the task flow definition programmatically using MetadataService
Getting readyHow to do it…How it works…There's more…See also
Creating a train
Getting readyHow to do it…How it works…There's more…See also
7. Face Value: ADF Faces, JSF Pages, and User Interface Components
Introduction
Using an af:query component to construct a search page
Getting readyHow to do it…How it works…There's more…See also
Using an af:pop-up component to edit a table row
Getting readyHow to do it…How it works…There's more…See also
Using an af:tree component
Getting readyHow to do it…How it works…There's more…See also
Using an af:selectManyShuttle component
Getting readyHow to do it…How it works…There's more…See also
Using an af:carousel component
Getting readyHow to do it…How it works…There's more…See also
Using an af:poll component to periodically refresh a table
Getting readyHow to do it…How it works…See also
Using page templates for pop-up reuse
Getting readyHow to do it…How it works…There's more…See also
Exporting data to a client file
Getting readyHow to do it…How it works…There's more…See also
8. Backing not Baking: Bean Recipes
Introduction
Determining whether the current transaction has pending changes
Getting readyHow to do it…How it works…There's more…See also
Using a custom af:table selection listener
Getting readyHow to do it…How it works…There's more…See also
Using a custom af:query listener to allow execution of a custom application module operation
Getting readyHow to do it…How it works…There's more…See also
Using a custom af:query operation listener to clear both the query criteria and results
Getting readyHow to do it…How it works…There's more…See also
Using a session scope bean to preserve session-wide information
Getting readyHow to do it…How it works…See also
Using an af:popup during long running tasks
Getting readyHow to do it…How it works…See also
Using an af:popup to handle pending changes
Getting readyHow to do it…How it works…See also
Using an af:iterator to add pagination support to a collection
Getting readyHow to do it…How it works…See also
9. Handling Security, Session Timeouts, Exceptions, and Errors
Introduction
Enabling ADF security
Getting readyHow to do it…How it works…There's more…See also
Using a custom login page
Getting readyHow to do it…How it works…There's more…See also
Accessing the application's security information
Getting readyHow to do it…How it works…There's more…See also
Using OPSS to retrieve the authenticated user's profile from the identity store
Getting readyHow to do it…How it works…There's more…See also
Detecting and handling session timeouts
Getting readyHow to do it…How it works…There's more…See also
Using a custom error handler to customize how exceptions are reported to the ViewController
Getting readyHow to do it…How it works…There's more…See also
Customizing the error message details
Getting readyHow to do it…How it works…See also
Overriding attribute validation exceptions
Getting readyHow to do it…How it works…There's more…See also
10. Deploying ADF Applications
Introduction
Configuring and using the Standalone WebLogic Server
Getting readyHow to do it…How it works…There's more…See also
Deploying on the Standalone WebLogic Server
Getting readyHow to do it…How it works…There's more…See also
Using ojdeploy to automate the build process
Getting readyHow to do it…How it works…There's more…See also
Using Hudson as a continuous integration framework
Getting readyHow to do it…How it works…There's more…See also
11. Refactoring, Debugging, Profiling, and Testing
Introduction
Synchronizing business components with database changes
Getting readyHow to do it…How it works…There's more…
Refactoring ADF components
Getting readyHow to do it…How it works…There's more…See also
Configuring and using remote debugging
Getting readyHow to do it…How it works…There's more…See also
Logging Groovy expressions
Getting readyHow to do it…How it works…See also
Dynamically configuring logging in WebLogic Server
Getting readyHow to do it…How it works…There's more…See also
Performing log analysis
Getting readyHow to do it…How it works…See also
Using CPU profiler for an application running on a standalone WebLogic server
Getting readyHow to do it…How it works…There's more…See also
Configuring and using JUnit for unit testing
Getting readyHow to do it…How it works…There's more…See also
12. Optimizing, Fine-tuning, and Monitoring
Introduction
Using Update Batching for entity objects
Getting readyHow to do it…How it works…There's more…See also
Limiting the rows fetched by a view object
Getting readyHow to do it…How it works…There's more…See also
Limiting large view object query result sets
Getting readyHow to do it…How it works…There's more…See also
Limiting large view object query result sets by using required view criteria
Getting readyHow to do it…How it works…There's more…See also
Using a work manager for processing of long running tasks
Getting readyHow to do it…How it works…There's more…See also
Monitoring the application using JRockit Mission Control
Getting readyHow to do it…How it works…There's more…See also
Index

Content preview from Oracle JDeveloper 11gR2 Cookbook

Limiting large view object query result sets

In the recipe Limiting the rows fetched by a view object in this chapter, we have seen how to limit the number of rows that can be fetched from the database by a view object. While this technique limits the number of rows fetched from the database to the middle layer, it will not limit the view object query that runs in the database. In this case, a query that produces a result set in the thousands of records will still be executed, which would be detrimental to the application's performance. This recipe takes a different approach - actually limiting the view object query to a predefined row count defined by the specific view object using a custom property.

Getting ready

The recipe uses the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781849684767Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Oracle JDeveloper 11gR2 Cookbook

by Nick Haralabidis

Limiting large view object query result sets

Getting ready

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.