Re: JDBC thin client fetch array size

On 4/3/23 13:41, steve jamro 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
>
https://docs.oracle.com/cd/A87860_01/doc/java.817/a83724/resltse5.htm

      Setting the Fetch Size

The following methods are available in all |Statement|, |PreparedStatement|, |CallableStatement|, and |ResultSet| objects for setting and getting the fetch size:

• |void setFetchSize(int rows) throws SQLException|
• |int getFetchSize() throws SQLException|

To set the fetch size for a query, call |setFetchSize()| on the statement object prior to executing the query. If you set the fetch size to N, then N rows are fetched with each trip to the database.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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