You can use setFetchSize(); ******************************** Statement stmt = conn.createStatement(); stmt.setFetchSize(100); HTH Dimitre ----- Original Message ----- From: "The Human Fly" <sjaffarhussain@xxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, April 06, 2005 5:00 PM Subject: arraysize setting for JDBC > 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." > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l