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.

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 the number of rows that can be fetched by all view objects in an ADF Fusion web application, the global configuration setting rowLimit in the adf-config.xml configuration file can be used instead. Then, by overriding the framework getRowLimit() method, you can adjust this upper limit for individual view objects as needed. When an attempt is...