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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.