Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: arraysize setting for JDBC

Re: arraysize setting for JDBC

From: cichomitiko gmail <cichomitiko_at_gmail.com>
Date: Wed, 6 Apr 2005 17:11:42 +0200
Message-ID: <04e801c53aba$f1ced800$1a03310a@IBME1D11967173>


You can use setFetchSize();


Statement stmt = conn.createStatement(); stmt.setFetchSize(100);

HTH
Dimitre

> Hello list,
>
> Can any one tell how can we change the arraysize (oracle) for JDBC
> connection. What I know is that JDBC arraysize for oracle is 10, for
> sqlplus is 15 and etc. I want to increase the arraysize for my JDBC
> connection.
>
> Thanks for your time!
>
> --
> Best Regards,
> Jaffar, OCP DBA
> Banque Saudi Fransi
> Saudi Arabia
> ----------------------------------------------------------------------------------------
> "It is your atittude, not your aptitude that determins your altitude."
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 06 2005 - 11:16:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US