|
BEA Systems, Inc. | ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--weblogic.jdbc.oci.Statement
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.
Field Summary | |
boolean |
binded
|
protected boolean |
closed
|
protected java.sql.Connection |
connection
|
protected java.sql.ResultSet |
current_queryresult
|
protected java.util.Hashtable |
cursorparams
|
protected boolean |
doExtendedSQL
|
protected int |
fetchsize
|
protected java.lang.String |
jdk_codeset
|
protected boolean |
lastvalnull
|
protected int |
maxfieldsize
|
protected int |
maxrows
|
protected boolean |
nullvalid
|
protected weblogic.db.oci.OciConnection |
ociconn
|
weblogic.db.oci.OciCursor |
ocicursor
|
protected int |
updatecnt
|
protected java.sql.SQLWarning |
warnings
|
Constructor Summary | |
Statement()
|
Method Summary | |
void |
addBatch()
|
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()
|
protected static java.lang.String |
checkJdbcSql(java.lang.String sql)
|
void |
clearBatch()
|
void |
clearParameters()
|
void |
clearWarnings()
|
void |
close_cursor(boolean clearit)
|
void |
close()
|
boolean |
execute()
|
boolean |
execute(java.lang.String sql)
|
int[] |
executeBatch()
|
java.sql.ResultSet |
executeQuery()
|
java.sql.ResultSet |
executeQuery(java.lang.String sql)
|
int |
executeUpdate()
|
int |
executeUpdate(java.lang.String sql)
|
int |
fetchSize()
|
void |
fetchSize(int size)
Allows tuning of the size of prefetch array used for Oracle row results. |
void |
finalize()
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
|
boolean |
getBoolean(int parameterIndex)
|
byte |
getByte(int parameterIndex)
|
byte[] |
getBytes(int parameterIndex)
|
java.sql.Connection |
getConnection()
|
java.sql.Date |
getDate(int parameterIndex)
|
double |
getDouble(int parameterIndex)
|
int |
getFetchDirection()
|
int |
getFetchSize()
|
float |
getFloat(int parameterIndex)
|
int |
getInt(int parameterIndex)
|
long |
getLong(int parameterIndex)
|
int |
getMaxFieldSize()
|
int |
getMaxRows()
|
boolean |
getMoreResults()
|
java.lang.Object |
getObject(int parameterIndex)
|
int |
getQueryTimeout()
|
java.sql.ResultSet |
getResultSet()
|
java.sql.ResultSet |
getResultSet(int parameterIndex)
|
int |
getResultSetConcurrency()
|
int |
getResultSetType()
|
short |
getShort(int parameterIndex)
|
java.lang.String |
getString(int parameterIndex)
|
java.sql.Time |
getTime(int parameterIndex)
|
java.sql.Timestamp |
getTimestamp(int parameterIndex)
|
int |
getUpdateCount()
|
java.sql.SQLWarning |
getWarnings()
|
int |
parse(java.lang.String sql)
|
void |
registerOutParameter(int parameterIndex,
int sqlType)
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
|
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
|
void |
setBoolean(int parameterIndex,
boolean x)
|
void |
setByte(int parameterIndex,
byte x)
|
void |
setBytes(int parameterIndex,
byte[] x)
|
void |
setCursorName(java.lang.String name)
|
void |
setDate(int parameterIndex,
java.sql.Date x)
|
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
|
void |
setDouble(int parameterIndex,
double x)
|
void |
setEscapeProcessing(boolean enable)
|
void |
setFetchDirection(int direction)
|
void |
setFetchSize(int rows)
|
void |
setFloat(int parameterIndex,
float x)
|
void |
setInt(int parameterIndex,
int x)
|
void |
setLong(int parameterIndex,
long x)
|
void |
setMaxFieldSize(int max)
|
void |
setMaxRows(int max)
|
void |
setNull(int parameterIndex,
int sqlType)
|
void |
setObject(int parameterIndex,
java.lang.Object x)
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale)
|
void |
setQueryTimeout(int seconds)
|
void |
setReader(int parameterIndex,
java.io.Reader x,
int length,
int insPieceLength,
int stream_type)
|
void |
setShort(int parameterIndex,
short x)
|
void |
setStream(int parameterIndex,
java.io.InputStream x,
int length,
int insPieceLength,
int stream_type)
|
void |
setString(int parameterIndex,
java.lang.String x)
|
void |
setTime(int parameterIndex,
java.sql.Time x)
|
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
|
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
|
boolean |
wasNull()
|
Methods inherited from class java.lang.Object |
clone,
equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Field Detail |
protected java.sql.Connection connection
protected weblogic.db.oci.OciConnection ociconn
public weblogic.db.oci.OciCursor ocicursor
protected boolean closed
protected int updatecnt
protected int maxrows
protected int maxfieldsize
protected java.sql.SQLWarning warnings
protected boolean doExtendedSQL
protected java.util.Hashtable cursorparams
protected java.sql.ResultSet current_queryresult
protected int fetchsize
protected java.lang.String jdk_codeset
public boolean binded
protected boolean lastvalnull
protected boolean nullvalid
Constructor Detail |
public Statement()
Method Detail |
public int fetchSize()
public void fetchSize(int size)
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.
size
- Number of rows for prefetchprotected void checkIfClosed() throws java.sql.SQLException
protected void checkIfArgNull(java.lang.String arg) throws java.sql.SQLException
public java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
public void finalize()
public void close() throws java.sql.SQLException
public void close_cursor(boolean clearit)
public void cancel() throws java.sql.SQLException
public void setCursorName(java.lang.String name) throws java.sql.SQLException
public int getMaxFieldSize() throws java.sql.SQLException
public void setMaxFieldSize(int max) throws java.sql.SQLException
public int getMaxRows() throws java.sql.SQLException
public void setMaxRows(int max) throws java.sql.SQLException
public int getQueryTimeout() throws java.sql.SQLException
public void setQueryTimeout(int seconds) throws java.sql.SQLException
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
public void clearWarnings() throws java.sql.SQLException
protected void addWarning(java.sql.SQLWarning newwarn)
public boolean execute(java.lang.String sql) throws java.sql.SQLException
public int parse(java.lang.String sql) throws java.sql.SQLException
public java.sql.ResultSet getResultSet() throws java.sql.SQLException
public int getUpdateCount() throws java.sql.SQLException
public boolean getMoreResults() throws java.sql.SQLException
public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
public int[] executeBatch() throws java.sql.SQLException
public void clearBatch()
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
public int executeUpdate() throws java.sql.SQLException
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
public void setStream(int parameterIndex, java.io.InputStream x, int length, int insPieceLength, int stream_type) throws java.sql.SQLException
public void setReader(int parameterIndex, java.io.Reader x, int length, int insPieceLength, int stream_type) throws java.sql.SQLException
public void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
public void clearParameters() throws java.sql.SQLException
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
public boolean execute() throws java.sql.SQLException
public void addBatch(java.lang.String sql) throws java.sql.SQLException
public void addBatch() throws java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
public boolean wasNull() throws java.sql.SQLException
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
public java.sql.ResultSet getResultSet(int parameterIndex) throws java.sql.SQLException
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
public byte getByte(int parameterIndex) throws java.sql.SQLException
public short getShort(int parameterIndex) throws java.sql.SQLException
public int getInt(int parameterIndex) throws java.sql.SQLException
public long getLong(int parameterIndex) throws java.sql.SQLException
public float getFloat(int parameterIndex) throws java.sql.SQLException
public double getDouble(int parameterIndex) throws java.sql.SQLException
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
protected static java.lang.String checkJdbcSql(java.lang.String sql) throws java.sql.SQLException
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
public void setFetchDirection(int direction) throws java.sql.SQLException
public int getFetchDirection() throws java.sql.SQLException
public int getResultSetConcurrency() throws java.sql.SQLException
public int getResultSetType() throws java.sql.SQLException
public java.sql.Connection getConnection() throws java.sql.SQLException
public void setFetchSize(int rows) throws java.sql.SQLException
public int getFetchSize() throws java.sql.SQLException
|
Documentation is available at http://e-docs.bea.com/wls/docs61 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |