Saturday, December 3, 2011

JDev/ADF sample - Fix Rowset is Forward Only Error for ADF BC LOV Range Paging (11.1.2.1.0)

  • Fix Rowset is Forward Only Error for ADF BC LOV Range Paging (11.1.2.1.0). This post is based on latest production JDeveloper - 11g R2 (11.1.2.1.0). ADF BC applications typically are working with database, when SQL statements are complex and slow - its good to apply Range Paging for VO's in ADF BC. Range Paging enables ADF BC to prepare SQL statement to retrieve only predefined subset of rows from database - significantly improving data retrieval performance. LOV is one of the elements in ADF applications where we can expect lots of rows to be retrieved - means good candidate to apply Range Paging.
    Download - LOVRangePagingFix.zip

No comments: