how to set fetchsize programmatically?
24059Aug 12 2005 — edited Feb 7 2007I see a viewobject method called setMaxFetchSize, but if me view has a tuning panel entry of "fetch at most 1 row", how do I change this programmatically to a larger number, as mentioned in the toystore notes for 10.1.2
"ADF View Object components have two similarly-named properties,
understand for performance tuning reasons. Both of them can be
panel, or programmatically at runtime with appropriate API's."
What I'd like to do is NOT fire a query for iterators that are in a screen unless I have to (setMaxFetchSize(0)). When I select a dropdown, I'd like to then query, but fetch in batches. IF I set the panel entry to 10, it works, but I was just wondering how to do it in code.
Thanks.