Class weblogic.jdbc.oci.Statement 
All Packages

Class weblogic.jdbc.oci.Statement 

java.lang.Object
   |
   +----weblogic.jdbc.oci.Statement
public class Statement
extends Object
This class contains WebLogic extensions to JDBC to support parsing of SQL statements and adjusting of the fetch size. Only those methods are documented here.
Author:
Copyright (c) 1996-97 by WebLogic, Inc. All Rights Reserved.

Method Index

o parse(int)
Returns an int that corresponds to the SQL Function Code that describes the type of statement.
o fetchsize(int)
Tunes the size of the prefetch array used for Oracle row results.

Methods

o fetchSize 
 public void fetchSize(int size)
Allows tuning of 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.

Parameters:
size - Number of rows to be prefetched
o parse 
  public int parse(String sql) throws SQLException
Returns an int that corresponds to the SQL Function Code that describes the type of statement. This allows parsing of the SQL without actually executing the statement. If the statement is semantically incorrect, returns zero (0).

A list of return codes for all SQL statements is shown in Table 2-1 on page 2-6 of the Oracle Programmer's Guide to the Oracle Call Interface.

Note that this method does not verify table names or other table-related parameters in its check; this method only verifies the semantics of the statement against the Oracle libraries.

Parameters:
sql - SQL statement to be verified
Throws: SQLException
if the operation cannot be completed 
All Packages