Weblogic 12 JDBC Fetch Size Adjustment - Where?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 6 Sep 2023 09:13:39 -0400
Message-ID: <CAP79kiQqu_CzU8KcMrZ4qu6EtuOYvve_8GhdH+pO8L6=aof=DA_at_mail.gmail.com>

For you guys that deal with weblogic JDBC connectors, where do you change the default FETCH (array) size ?

Scenario: Page is loading a table from the database by selecting every row with no filter predicates (a list of companies). The table has 70,000 rows which effectively leads to 7000 trips to the database with the default JDBC fetch of 10.

We found the connector properties screen for the connector where we have "Row Prefetch Enabled" , and "Row Prefetch Size" but changing those didn't seem to do anything. Is that the correct config options or is there somewhere else to change the JDBC fetch size?

Does weblogic server need to be fully restarted after changing the connector properties?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 06 2023 - 15:13:39 CEST