InvalidOperException: JBO-25011: Rowset <name> is forward only For a LOV In Range Paging Access Mode (Doc ID 1225174.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version: 11.1.1.3.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

You are developing an ADF Faces/BC application in JDeveloper 11.1.1.3.0.
The application should include List of Values (LOVs) returning a huge amount of records.
As explained in the ADF Developer's Guide, "39.1.5 Efficiently Scrolling Through Large Result Sets
Using Range Paging
" you should use the "Access Mode"="Range Paging" to avoid all these
records to be fetched and cached in ADF BC.

However, when doing so, you are unable to run your application:; you get the following error:
oracle.jbo.InvalidOperException: JBO-25011: Rowset _LOCAL_VIEW_USAGE_model_EmployeesView_DepartmentsView1_0 is forward only.
at oracle.jbo.server.ViewObjectImpl.validateRangeSizeForRangePaging(ViewObjectImpl.java:14535)
at oracle.jbo.server.ViewRowSetIteratorImpl.setRangeSize(ViewRowSetIteratorImpl.java:530)
at oracle.jbo.server.ViewRowSetImpl.setRangeSize(ViewRowSetImpl.java:2828)
at oracle.jbo.common.AbstractListBinding.<init>(AbstractListBinding.java:246)
at oracle.jbo.server.ListBinding.<init>(ListBinding.java:30)
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms