Re: Weblogic 12 JDBC Fetch Size Adjustment - Where?

I wanted to provide an update on this.

So in our environment, we're using Weblogic plus HIbernate. Most the connections are done via Hibernate (and I'm unclear on the interplay here) but we found the fetch-size had to be adjusted within the hibernate properties file and not at the Weblogic JDBC connector itself.

I'm not even sure what the correct language to use is when talking about Weblogic with deployed applications which makes talking to the teams difficult as its like working through a problem with only 1 or 2 senses instead of all 5 or 6 :)

Thanks !

On Wed, Sep 6, 2023 at 2:08 PM Priit Piipuu <priit.piipuu_at_gmail.com> wrote:

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