WebLogic Server 8.1 API Reference

weblogic.jdbc.oci
Class Statement

java.lang.Object
  |
  +--weblogic.jdbc.oci.Statement

Direct Known Subclasses:

weblogic.jdbc.oci.PreparedStatement

public class Statement

extends java.lang.Object

implements java.sql.Statement, Cancelable, FetchSizeSettable, Parseable

This class contains WebLogic extensions to JDBC to support parsing of SQL statements and adjusting of the fetch size. Only the extensions are documented here. Copyright (c) 1999 by BEA WebXpress. All Rights Resrved.

Author:

Copyright © 2002 BEA Systems, Inc. All Rights Reserved.

Field Summary

boolean	binded
protected boolean	closed
protected Connection	connection
protected weblogic.jdbc.oci.ResultSet	current_queryresult
protected java.util.Hashtable	cursorparams
protected boolean	doExtendedSQL
protected int	fetchsize
protected java.lang.String	jdk_codeset
protected int	maxfieldsize
protected int	maxrows
protected weblogic.db.oci.OciConnection	ociconn
weblogic.db.oci.OciCursor	ocicursor
protected int	updatecnt
protected java.sql.SQLWarning	warnings

Method Summary

void	addBatch(java.lang.String sql)
protected void	addWarning(java.sql.SQLWarning newwarn)
void	cancel()
protected void	checkIfArgNull(java.lang.String arg)
protected void	checkIfClosed()
void	clearBatch()
void	clearWarnings()
void	close_cursor(boolean clearit)
void	close()
boolean	execute(java.lang.String sql)
boolean	execute(java.lang.String a, int b)
boolean	execute(java.lang.String a, int[] b)
boolean	execute(java.lang.String a, java.lang.String[] b)
int[]	executeBatch()
java.sql.ResultSet	executeQuery(java.lang.String sql)
int	executeUpdate(java.lang.String sql)
int	executeUpdate(java.lang.String a, int b)
int	executeUpdate(java.lang.String a, int[] b)
int	executeUpdate(java.lang.String a, java.lang.String[] b)
int	fetchSize()
void	fetchSize(int size) Allows tuning of the size of prefetch array used for Oracle row results.
void	finalize()
java.sql.Connection	getConnection()
int	getFetchDirection()
int	getFetchSize()
java.sql.ResultSet	getGeneratedKeys()
int	getMaxFieldSize()
int	getMaxRows()
boolean	getMoreResults()
boolean	getMoreResults(int a)
java.sql.ParameterMetaData	getParameterMetaData()
int	getQueryTimeout()
java.sql.ResultSet	getResultSet()
int	getResultSetConcurrency()
int	getResultSetHoldability()
int	getResultSetType()
int	getUpdateCount()
java.sql.SQLWarning	getWarnings()
int	parse(java.lang.String sql)
void	setCursorName(java.lang.String name)
void	setEscapeProcessing(boolean enable)
void	setFetchDirection(int direction)
void	setFetchSize(int rows)
void	setMaxFieldSize(int max)
void	setMaxRows(int max)
void	setNull(int parameterIndex, int sqlType)
void	setQueryTimeout(int seconds)
void	setURL(int a, java.net.URL b)

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

connection

protected final Connection connection

ociconn

protected final weblogic.db.oci.OciConnection ociconn

jdk_codeset

protected final java.lang.String jdk_codeset

ocicursor

public weblogic.db.oci.OciCursor ocicursor

closed

protected boolean closed

updatecnt

protected int updatecnt

maxrows

protected int maxrows

maxfieldsize

protected int maxfieldsize

warnings

protected java.sql.SQLWarning warnings

doExtendedSQL

protected boolean doExtendedSQL

cursorparams

protected java.util.Hashtable cursorparams

current_queryresult

protected weblogic.jdbc.oci.ResultSet current_queryresult

fetchsize

protected int fetchsize

binded

public boolean binded

Method Detail

fetchSize

public int fetchSize()

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.

Specified by:

fetchSize in interface FetchSizeSettable

Parameters:

size - Number of rows for prefetch

checkIfClosed

protected void checkIfClosed()
                      throws java.sql.SQLException

checkIfArgNull

protected void checkIfArgNull(java.lang.String arg)
                       throws java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.sql.SQLException

Specified by:

executeQuery in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

finalize

public void finalize()

Overrides:

finalize in class java.lang.Object

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Statement

close_cursor

public void close_cursor(boolean clearit)

cancel

public void cancel()
            throws java.sql.SQLException

Specified by:

cancel in interface java.sql.Statement

setCursorName

public void setCursorName(java.lang.String name)
                   throws java.sql.SQLException

Specified by:

setCursorName in interface java.sql.Statement

getMaxFieldSize

public int getMaxFieldSize()
                    throws java.sql.SQLException

Specified by:

getMaxFieldSize in interface java.sql.Statement

setMaxFieldSize

public void setMaxFieldSize(int max)
                     throws java.sql.SQLException

Specified by:

setMaxFieldSize in interface java.sql.Statement

getMaxRows

public int getMaxRows()
               throws java.sql.SQLException

Specified by:

getMaxRows in interface java.sql.Statement

setMaxRows

public void setMaxRows(int max)
                throws java.sql.SQLException

Specified by:

setMaxRows in interface java.sql.Statement

getQueryTimeout

public int getQueryTimeout()
                    throws java.sql.SQLException

Specified by:

getQueryTimeout in interface java.sql.Statement

setQueryTimeout

public void setQueryTimeout(int seconds)
                     throws java.sql.SQLException

Specified by:

setQueryTimeout in interface java.sql.Statement

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface java.sql.Statement

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Statement

addWarning

protected void addWarning(java.sql.SQLWarning newwarn)

execute

public boolean execute(java.lang.String sql)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

parse

public int parse(java.lang.String sql)
          throws java.sql.SQLException

Specified by:

parse in interface Parseable

getResultSet

public java.sql.ResultSet getResultSet()
                                throws java.sql.SQLException

Specified by:

getResultSet in interface java.sql.Statement

getUpdateCount

public int getUpdateCount()
                   throws java.sql.SQLException

Specified by:

getUpdateCount in interface java.sql.Statement

getMoreResults

public boolean getMoreResults()
                       throws java.sql.SQLException

Specified by:

getMoreResults in interface java.sql.Statement

setEscapeProcessing

public void setEscapeProcessing(boolean enable)
                         throws java.sql.SQLException

Specified by:

setEscapeProcessing in interface java.sql.Statement

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException

Specified by:

executeBatch in interface java.sql.Statement

clearBatch

public void clearBatch()

Specified by:

clearBatch in interface java.sql.Statement

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws java.sql.SQLException

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException

Specified by:

setFetchDirection in interface java.sql.Statement

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Specified by:

getFetchDirection in interface java.sql.Statement

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException

Specified by:

setFetchSize in interface java.sql.Statement

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Specified by:

getFetchSize in interface java.sql.Statement

getResultSetConcurrency

public int getResultSetConcurrency()
                            throws java.sql.SQLException

Specified by:

getResultSetConcurrency in interface java.sql.Statement

getResultSetType

public int getResultSetType()
                     throws java.sql.SQLException

Specified by:

getResultSetType in interface java.sql.Statement

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Specified by:

getConnection in interface java.sql.Statement

addBatch

public void addBatch(java.lang.String sql)
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.Statement

getGeneratedKeys

public java.sql.ResultSet getGeneratedKeys()
                                    throws java.sql.SQLException

Specified by:

getGeneratedKeys in interface java.sql.Statement

getMoreResults

public boolean getMoreResults(int a)
                       throws java.sql.SQLException

Specified by:

getMoreResults in interface java.sql.Statement

getResultSetHoldability

public int getResultSetHoldability()
                            throws java.sql.SQLException

Specified by:

getResultSetHoldability in interface java.sql.Statement

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

setURL

public void setURL(int a,
                   java.net.URL b)
            throws java.sql.SQLException

execute

public boolean execute(java.lang.String a,
                       int b)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

execute

public boolean execute(java.lang.String a,
                       int[] b)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

execute

public boolean execute(java.lang.String a,
                       java.lang.String[] b)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String a,
                         int b)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String a,
                         int[] b)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String a,
                         java.lang.String[] b)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement