Re: JDBC thin client fetch array size
From: steve jamro <sjamro1990_at_gmail.com>
Date: Wed, 5 Apr 2023 12:30:24 -0400
Message-Id: <E9BE5EE6-263F-476F-94CD-DB0A56BE9026_at_gmail.com>
Priit
To
How would the final jdbc url look like
Date: Wed, 5 Apr 2023 12:30:24 -0400
Message-Id: <E9BE5EE6-263F-476F-94CD-DB0A56BE9026_at_gmail.com>
Priit
What is the correct syntax to add
defaultRowPrefetch=200
jdbc:oracle:thin:_at_(DESCRIPTION=(SDU=32768) (ADDRESS=(PROTOCOL=TCP) (HOST=<PORT>) (PORT=<PORT>)) (CONNECT_DATA=(SERVICE_NAME=<SERVICA NAME>)))
?
On Apr 5, 2023, at 9:15 AM, Priit Piipuu <priit.piipuu_at_gmail.com> wrote:
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=200On 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-lReceived on Wed Apr 05 2023 - 18:30:24 CEST