|
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
Deprecated. |
protected boolean |
closed
Deprecated. |
protected Connection |
connection
Deprecated. |
protected weblogic.jdbc.oci.ResultSet |
current_queryresult
Deprecated. |
protected java.util.Hashtable |
cursorparams
Deprecated. |
protected boolean |
doExtendedSQL
Deprecated. |
protected int |
fetchsize
Deprecated. |
protected java.lang.String |
jdk_codeset
Deprecated. |
protected int |
maxfieldsize
Deprecated. |
protected int |
maxrows
Deprecated. |
protected weblogic.db.oci.OciConnection |
ociconn
Deprecated. |
weblogic.db.oci.OciCursor |
ocicursor
Deprecated. |
protected int |
updatecnt
Deprecated. |
protected java.sql.SQLWarning |
warnings
Deprecated. |
Method Summary | |
void |
addBatch(java.lang.String sql)
Deprecated. |
protected void |
addWarning(java.sql.SQLWarning newwarn)
Deprecated. |
void |
cancel()
Deprecated. |
protected void |
checkIfArgNull(java.lang.String arg)
Deprecated. |
protected void |
checkIfClosed()
Deprecated. |
void |
clearBatch()
Deprecated. |
void |
clearWarnings()
Deprecated. |
void |
close_cursor(boolean clearit)
Deprecated. |
void |
close()
Deprecated. |
boolean |
execute(java.lang.String sql)
Deprecated. |
boolean |
execute(java.lang.String a,
int b)
Deprecated. |
boolean |
execute(java.lang.String a,
int[] b)
Deprecated. |
boolean |
execute(java.lang.String a,
java.lang.String[] b)
Deprecated. |
int[] |
executeBatch()
Deprecated. |
java.sql.ResultSet |
executeQuery(java.lang.String sql)
Deprecated. |
int |
executeUpdate(java.lang.String sql)
Deprecated. |
int |
executeUpdate(java.lang.String a,
int b)
Deprecated. |
int |
executeUpdate(java.lang.String a,
int[] b)
Deprecated. |
int |
executeUpdate(java.lang.String a,
java.lang.String[] b)
Deprecated. |
int |
fetchSize()
Deprecated. |
void |
fetchSize(int size)
Deprecated. Allows tuning of the size of prefetch array used for Oracle row results. |
void |
finalize()
Deprecated. |
java.sql.Connection |
getConnection()
Deprecated. |
int |
getFetchDirection()
Deprecated. |
int |
getFetchSize()
Deprecated. |
java.sql.ResultSet |
getGeneratedKeys()
Deprecated. |
int |
getMaxFieldSize()
Deprecated. |
int |
getMaxRows()
Deprecated. |
boolean |
getMoreResults()
Deprecated. |
boolean |
getMoreResults(int a)
Deprecated. |
java.sql.ParameterMetaData |
getParameterMetaData()
Deprecated. |
int |
getQueryTimeout()
Deprecated. |
java.sql.ResultSet |
getResultSet()
Deprecated. |
int |
getResultSetConcurrency()
Deprecated. |
int |
getResultSetHoldability()
Deprecated. |
int |
getResultSetType()
Deprecated. |
int |
getUpdateCount()
Deprecated. |
java.sql.SQLWarning |
getWarnings()
Deprecated. |
int |
parse(java.lang.String sql)
Deprecated. |
void |
setCursorName(java.lang.String name)
Deprecated. |
void |
setEscapeProcessing(boolean enable)
Deprecated. |
void |
setFetchDirection(int direction)
Deprecated. |
void |
setFetchSize(int rows)
Deprecated. |
void |
setMaxFieldSize(int max)
Deprecated. |
void |
setMaxRows(int max)
Deprecated. |
void |
setNull(int parameterIndex,
int sqlType)
Deprecated. |
void |
setQueryTimeout(int seconds)
Deprecated. |
void |
setURL(int a,
java.net.URL b)
Deprecated. |
Methods inherited from class java.lang.Object |
clone,
equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait |
Field Detail |
protected final Connection connection
protected final weblogic.db.oci.OciConnection ociconn
protected final java.lang.String jdk_codeset
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 weblogic.jdbc.oci.ResultSet current_queryresult
protected int fetchsize
public boolean binded
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 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 void setFetchSize(int rows) throws java.sql.SQLException
public int getFetchSize() 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 addBatch(java.lang.String sql) throws java.sql.SQLException
public java.sql.ResultSet getGeneratedKeys() throws java.sql.SQLException
public boolean getMoreResults(int a) throws java.sql.SQLException
public int getResultSetHoldability() throws java.sql.SQLException
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
public void setURL(int a, java.net.URL b) throws java.sql.SQLException
public boolean execute(java.lang.String a, int b) throws java.sql.SQLException
public boolean execute(java.lang.String a, int[] b) throws java.sql.SQLException
public boolean execute(java.lang.String a, java.lang.String[] b) throws java.sql.SQLException
public int executeUpdate(java.lang.String a, int b) throws java.sql.SQLException
public int executeUpdate(java.lang.String a, int[] b) throws java.sql.SQLException
public int executeUpdate(java.lang.String a, java.lang.String[] b) throws java.sql.SQLException
|
Documentation is available at http://download.oracle.com/docs/cd/E13222_01/wls/docs81 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |