All Packages

Class weblogic.jdbc.t3.Statement 

java.lang.Object
   |
   +----weblogic.jdbc.t3.Statement
public class Statement
extends Object
implements Statement, Msg
This class contains WebLogic extensions to JDBC that are used to get and set the fetch size of a Statement. Only those methods that extend the spec are included here.
Author:
Copyright (c) 1996 by WebLogic, Inc.

Method Index

o fetchSize(int)
Gives WebLogic JDBC clients access to this function in the OCI driver.

Methods

o fetchSize 
 public void fetchSize(int size) throws SQLException
This method allows WebLogic JDBC clients to access this function in the OCI driver, where users may tune the size of prefetch array used for Oracle row results. Oracle provides the means to do data prefetch in batches, which decreases network traffic and latency for row requests.

The default batch size is 100. Memory for 100 rows is allocated in the native stack for every query. For queries that need fewer rows, this size can be adjusted appropriately. This saves on the swappable image size of the application and will benefit performance if only as many rows as needed are fetched. 

All Packages