Re: Weblogic 12 JDBC Fetch Size Adjustment - Where?

On Wed, 6 Sept 2023 at 15:15, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:

> 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?
>

It is possible to set fetch size through JDBC URL or as a system property: https://priitp.wordpress.com/2023/04/08/how-to-change-oracle-jdbc-connection-properties-if-you-dont-have-access-to-the-source-code/

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

For the system property yes, JVM has to be restarted. Not sure about JDBC connector, I suppose it can reload itself on URL change. Haven't touched WLS for ages, tho.

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