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!

ADF/BC4J fetches all rows, should fetch only if needed

434844Aug 31 2006 — edited Apr 24 2008

Hello,

I'm using JDeveloper 10.1.2. Technologies are Struts, ADF and BC4J.

I have a problem with viewObjects. I have created components from database tables. I'm fetching in appModuleImpl:

ViewObjImpl impl = getObjectViewImpl();
impl.setWhereClause("id=101");
impl.executeQuery();

Problem is that when page is loaded, it fetches ALL ROWS (80 000 rows)from table and then makes another query to fetch group above. I want only fetch rows that i decide to fetch. My application is in immediate mode. Couple of iterators has fetch range -1 and couple 10.
I have debugged that the first ALL ROWS fetch is made somewhere out of my code.

What i'm doing wrong? Any feature development hints are welcome also.

Thank you advance!

null

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2008

Added on Aug 31 2006

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

13 comments

1,395 views