Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Range Paging functionality not working, getting out of memory exception

2888183May 29 2017 — edited Jul 11 2017

Hi all,

I am developing a simple ADF application with JDeveloper 12.1.3 .

I am executing a viewObject to display records in af:table with pagination. There are From-date and To-Date parameters to search records.

There are millions of records in database table which is queried in ViewObject.

When I execute this viewObject then I am getting OutOfmemory exception in logs. To solve this issue I follow ViewObject tunning approch as follows.

Instead of Scrolling I used Range Paging Increamental for Access Mode and set range size.

This approach is working when date range is small (i.e. if records are less) but when date range is big then it is giving me same OutOfMemory Exception.

Kindly help me in this.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2017

Added on May 29 2017

#adf, #application-development-in-java, #jdeveloper-and-adf

10 comments

503 views