Re: JDBC thin client fetch array size

You can use row prefetch for a similar effect. As with the rest of the parameters for OracleConnection, it is possible to set it in the connect string. Like this:

spring.datasource.url=jdbc:oracle:thin:_at_ (DESCRIPTION=(FAILOVER=on)(CONNECT_TIMEOUT=4)(TRANSPORT_CONNECT_TIMEOUT=2)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCPS)(HOST=localhost)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=testpdb)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=5))))?ssl_server_dn_match=off&defaultRowPrefetch=200

On Mon, 3 Apr 2023 at 19:43, steve jamro <sjamro1990_at_gmail.com> wrote:

> Hello listers
>
>
> JDBC thin client has a default fetch array size of 10. How can we increase
> it?
>
> Using this JDBC URL we were able to increase SDU. Can we do the same for
> fetch array size?
>
> *This is running from a windows client.*
>
>
>
> jdbc:oracle:thin:_at_(DESCRIPTION=*(SDU=32768)* (ADDRESS=(PROTOCOL=TCP)
> (HOST=<PORT>) (PORT=<PORT>)) (CONNECT_DATA=(SERVICE_NAME=<SERVICA NAME>)))
>
>
> Thank you
>

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