Limiting the rows fetched by a view object

The ADF Business Components framework allows you to declaratively and/or programmatically set an upper limit for the number of rows that can fetched from the database layer by a view object. Declaratively, this can be accomplished through the view object Tuning section in the General page of the view object Overview editor. You can do this by selecting Only up to row number in the Retrieve from the Database section and providing a row count.

Limiting the rows fetched by a view object

This can also be accomplished programmatically by calling a view object's setMaxFetchSize() method and specifying an upper row limit.

To globally set an upper limit for ...

Get Oracle JDeveloper 11gR2 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.