RE: arraysize setting for JDBC

Hi Jaffar

>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.

At connection level you can use:
- oracle.jdbc.OracleConnection.setDefaultRowPrefetch() - the property "defaultRowPrefetch" when you get a connection with = oracle.jdbc.DriverManager.getConnection()

At statement level you can use:
- java.sql.Statement.setFetchSize()

In the javadoc you find more info about the different possibilities...

HTH
Chris

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