// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Connect to the database
// You can put a database name after the @ sign in the connection URL.
Connection conn =
DriverManager.getConnection ("jdbc:oracle:oci7:@", "scott", "tiger");
// get the value of the default row prefetch from the connection object
int default_row_prefetch =
((OracleConnection)conn).getDefaultRowPrefetch ();
System.out.println ("The Default RowPrefetch for the connection is: "
+ default_row_prefetch);
Statement stmt = conn.createStatement ();
// set the RowPrefetch value from the statement object
// This sets the rowPrefetch only for this particular statement.
// All other statements will use the default RowPrefetch from the
// connection.
((OracleStatement)stmt).setRowPrefetch (30);
// Check to verify statement rowPrefetch value is 30.
int row_prefetch = ((OracleStatement)stmt).getRowPrefetch ();
System.out.println ("The RowPrefetch for the statement is: "
+ row_prefetch + "\n");
ResultSet rset = stmt.executeQuery ("select ename from emp");
while(rset.next ())
{
System.out.println (rset.getString (1));
}
stmt.close ();
