public abstract class CallableStatement extends PreparedStatement implements PreparedStatement, CallableStatement, PreparedStatementCallbackInterface
| Modifier and Type | Field and Description |
|---|---|
MaterialPreparedStatement |
materialCallableStatement_ |
clientParamTypeAtFirstExecute, internalPreparedStatement, materialPreparedStatement_, outputRegistered_, parameterMetaData_, parameters_, pooledConnection_, singleHopInfoAlreadyFetched_, sql_, superFlowExecuteCalled_autoGeneratedKeys_, cachedCursor_, cachedSingletonRowData_, CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, cursorAttributesToSendOnPrepare_, doWriteTimeout, fetchDirection_, fetchSize_, generatedKeysColumnIndexes_, generatedKeysColumnNames_, generatedKeysResultSet_, indexOfCurrentResultSet_, isCommitSql__, isPoolable, isPreparedStatement_, isQuery__, isRollbackSql__, KEEP_CURRENT_RESULT, materialStatement_, numInvisibleRS_, preparedStatementForAutoGeneratedKeys_, resultSetConcurrency_, resultSetHoldability_, resultSetType_, section_, SET_SCHEMA_STATEMENT, singletonRowData_, specialRegisterArrayList, sqlMode_, statementUUID, TIMEOUT_STATEMENTCLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO| Constructor and Description |
|---|
CallableStatement(Agent agent,
Connection connection,
String sql,
int type,
int concurrency,
int holdability,
ClientPooledConnection cpc)
Common constructor for jdbc 2 callable statements with scroll attributes.
|
| Modifier and Type | Method and Description |
|---|---|
void |
clearParameters() |
protected void |
finalize() |
Array |
getArray(int parameterIndex) |
Array |
getArray(String parameterName) |
BigDecimal |
getBigDecimal(int parameterIndex) |
BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
BigDecimal |
getBigDecimal(String parameterName) |
Blob |
getBlob(int parameterIndex) |
Blob |
getBlob(String parameterName) |
boolean |
getBoolean(int parameterIndex) |
boolean |
getBoolean(String parameterName) |
byte |
getByte(int parameterIndex) |
byte |
getByte(String parameterName) |
byte[] |
getBytes(int parameterIndex) |
byte[] |
getBytes(String parameterName) |
Reader |
getCharacterStream(int parameterIndex) |
Clob |
getClob(int parameterIndex) |
Clob |
getClob(String parameterName) |
Date |
getDate(int parameterIndex) |
Date |
getDate(int parameterIndex,
Calendar cal) |
Date |
getDate(String parameterName) |
Date |
getDate(String parameterName,
Calendar calendar) |
double |
getDouble(int parameterIndex) |
double |
getDouble(String parameterName) |
float |
getFloat(int parameterIndex) |
float |
getFloat(String parameterName) |
int |
getInt(int parameterIndex) |
int |
getInt(String parameterName) |
protected String |
getJdbcStatementInterfaceName()
Returns the name of the java.sql interface implemented by this class.
|
long |
getLong(int parameterIndex) |
long |
getLong(String parameterName) |
Object |
getObject(int parameterIndex) |
Object |
getObject(int parameterIndex,
Map map) |
Object |
getObject(String parameterName) |
Object |
getObject(String parameterName,
Map map) |
Ref |
getRef(int parameterIndex) |
Ref |
getRef(String parameterName) |
short |
getShort(int parameterIndex) |
short |
getShort(String parameterName) |
String |
getString(int parameterIndex) |
String |
getString(String parameterName) |
Time |
getTime(int parameterIndex) |
Time |
getTime(int parameterIndex,
Calendar cal) |
Time |
getTime(String parameterName) |
Time |
getTime(String parameterName,
Calendar calendar) |
Timestamp |
getTimestamp(int parameterIndex) |
Timestamp |
getTimestamp(int parameterIndex,
Calendar cal) |
Timestamp |
getTimestamp(String parameterName) |
Timestamp |
getTimestamp(String parameterName,
Calendar calendar) |
URL |
getURL(int parameterIndex) |
URL |
getURL(String parameterName) |
boolean |
isCallMode() |
void |
registerOutParameter(int parameterIndex,
int jdbcType) |
void |
registerOutParameter(int parameterIndex,
int jdbcType,
int scale) |
void |
registerOutParameter(int parameterIndex,
int jdbcType,
String typeName) |
void |
registerOutParameter(String parameterName,
int sqlType) |
void |
registerOutParameter(String parameterName,
int sqlType,
int scale) |
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName) |
void |
reset(boolean fullReset) |
void |
resetCallableStatement(Agent agent,
Connection connection,
String sql,
int type,
int concurrency,
int holdability) |
void |
resetCallableStatement(Agent agent,
Connection connection,
String sql,
Section section) |
void |
resetCallableStatement(Agent agent,
Connection connection,
String sql,
Section section,
ColumnMetaData parameterMetaData,
ColumnMetaData resultSetMetaData) |
void |
setAsciiStream(String parameterName,
InputStream x,
int length) |
void |
setBigDecimal(String parameterName,
BigDecimal x) |
void |
setBinaryStream(String parameterName,
InputStream x,
int length) |
void |
setBoolean(String parameterName,
boolean x) |
void |
setByte(String parameterName,
byte x) |
void |
setBytes(String parameterName,
byte[] x) |
void |
setCharacterStream(String parameterName,
Reader reader,
int length) |
void |
setDate(String parameterName,
Date x) |
void |
setDate(String parameterName,
Date x,
Calendar calendar) |
void |
setDouble(String parameterName,
double x) |
void |
setFloat(String parameterName,
float x) |
void |
setInt(String parameterName,
int x) |
void |
setLong(String parameterName,
long x) |
void |
setNull(String parameterName,
int sqlType) |
void |
setNull(String parameterName,
int sqlType,
String typeName) |
void |
setObject(String parameterName,
Object x) |
void |
setObject(String parameterName,
Object x,
int targetSqlType) |
void |
setObject(String parameterName,
Object x,
int targetSqlType,
int scale) |
void |
setShort(String parameterName,
short x) |
void |
setString(String parameterName,
String x) |
void |
setTime(String parameterName,
Time x) |
void |
setTime(String parameterName,
Time x,
Calendar calendar) |
void |
setTimestamp(String parameterName,
Timestamp x) |
void |
setTimestamp(String parameterName,
Timestamp x,
Calendar calendar) |
void |
setURL(String parameterName,
URL x) |
boolean |
wasNull() |
addBatch, completeDescribeInput, completeDescribeOutput, completeLocalCommit, completeLocalRollback, execute, execute, execute, execute, execute, executeBatch, executeBatchX, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, flowExecute, flowExecuteRead, flowExecuteWrite, getClientParamType, getMetaData, getParameterMetaData, getSuperResultSet, initResetPreparedStatement, listenToUnitOfWork, makeNewClientParamTypeFrom, markClosed, readDescribeInput, readDescribeOutput, readExecute, resetPreparedStatement, resetPreparedStatement, resetPreparedStatement, setAndStoreClientParamType, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStreamX, setBlob, setBlob, setBlob, setBlobX, setBoolean, setByte, setBytes, setBytesX, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, singleHopPrepStmntExecuteQuery, writeDescribeInput, writeDescribeOutput, writeExecuteaccumulateWarning, addBatch, cancel, checkForDuplicateCursorName, checkForStoredProcResultSetCount, cleanSingleHopPrepStmnt, clearBatch, clearWarnings, close, closeX, completeExecute, completeExecuteCall, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, completeStatementIDRead, getConnection, getConnectionCallbackInterface, getFetchDirection, getFetchSize, getGeneratedKeys, getGuessedResultSetMetaData, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSection, getSqlWarnings, getUpdateCount, getWarnings, initResetPreparedStatement, isClosed, isClosedNoThrow, isPoolable, isQueryMode, isWrapperFor, jdbc3FeatureNotSupported, jdbc3FeatureNotSupported, markAutoCommitted, needStatementUUID, readExecuteCall, readExecuteImmediate, readExecuteImmediateForBatch, readOpenQuery, readPrepare, readPrepareDescribeOutput, readSetSpecialRegister, readStatementID, removeClientCursorNameFromCache, resetStatement, resetStatement, resultSetCommitting, resultSetCommitting, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setOwner, setPoolable, setQueryTimeout, setupCursorNameCacheAndMappings, setUpdateCount, substituteClientCursorNameWithServerCursorName, upperCaseProcedureName, writeExecuteCall, writeExecuteImmediate, writeGetStmtUUID, writeOpenQuery, writePrepare, writePrepareDescribeOutput, writeSetSpecialRegisterclone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitgetCharacterStream, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRowId, setSQLXMLaddBatch, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLaddBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutisWrapperFor, unwrapcompleteDescribeInput, completeDescribeOutputaccumulateWarning, completeExecute, completeExecuteCall, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, completeStatementIDRead, getConnectionCallbackInterface, getGuessedResultSetMetaData, getSectioncompleteLocalCommit, completeLocalRollback, listenToUnitOfWorkpublic MaterialPreparedStatement materialCallableStatement_
public CallableStatement(Agent agent, Connection connection, String sql, int type, int concurrency, int holdability, ClientPooledConnection cpc) throws SqlException
agent - The instance of NetAgent associated with this
CallableStatement object.connection - The connection object associated with this
PreparedStatement Object.sql - A String object that is the SQL statement to be sent
to the database.type - One of the ResultSet type constantsconcurrency - One of the ResultSet concurrency constantsholdability - One of the ResultSet holdability constantscpc - The PooledConnection object that will be used to
notify the PooledConnection reference of the Error
Occurred and the Close events.SqlExceptionpublic void reset(boolean fullReset)
throws SqlException
reset in class PreparedStatementSqlExceptionpublic void resetCallableStatement(Agent agent, Connection connection, String sql, int type, int concurrency, int holdability) throws SqlException
SqlExceptionpublic void resetCallableStatement(Agent agent, Connection connection, String sql, Section section) throws SqlException
SqlExceptionpublic void resetCallableStatement(Agent agent, Connection connection, String sql, Section section, ColumnMetaData parameterMetaData, ColumnMetaData resultSetMetaData) throws SqlException
SqlExceptionprotected void finalize()
throws Throwable
public void clearParameters()
throws SQLException
clearParameters in interface PreparedStatementclearParameters in class PreparedStatementSQLExceptionpublic void registerOutParameter(int parameterIndex,
int jdbcType)
throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(int parameterIndex,
int jdbcType,
int scale)
throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(int parameterIndex,
int jdbcType,
String typeName)
throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic boolean wasNull()
throws SQLException
wasNull in interface CallableStatementSQLExceptionpublic boolean getBoolean(int parameterIndex)
throws SQLException
getBoolean in interface CallableStatementSQLExceptionpublic byte getByte(int parameterIndex)
throws SQLException
getByte in interface CallableStatementSQLExceptionpublic short getShort(int parameterIndex)
throws SQLException
getShort in interface CallableStatementSQLExceptionpublic int getInt(int parameterIndex)
throws SQLException
getInt in interface CallableStatementSQLExceptionpublic long getLong(int parameterIndex)
throws SQLException
getLong in interface CallableStatementSQLExceptionpublic float getFloat(int parameterIndex)
throws SQLException
getFloat in interface CallableStatementSQLExceptionpublic double getDouble(int parameterIndex)
throws SQLException
getDouble in interface CallableStatementSQLExceptionpublic BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException, ArithmeticException
getBigDecimal in interface CallableStatementSQLExceptionArithmeticExceptionpublic BigDecimal getBigDecimal(int parameterIndex) throws SQLException
getBigDecimal in interface CallableStatementSQLExceptionpublic Date getDate(int parameterIndex) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Date getDate(int parameterIndex, Calendar cal) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Time getTime(int parameterIndex) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Time getTime(int parameterIndex, Calendar cal) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(int parameterIndex) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic String getString(int parameterIndex) throws SQLException
getString in interface CallableStatementSQLExceptionpublic byte[] getBytes(int parameterIndex)
throws SQLException
getBytes in interface CallableStatementSQLExceptionpublic Blob getBlob(int parameterIndex) throws SQLException
getBlob in interface CallableStatementSQLExceptionpublic Clob getClob(int parameterIndex) throws SQLException
getClob in interface CallableStatementSQLExceptionpublic Array getArray(int parameterIndex) throws SQLException
getArray in interface CallableStatementSQLExceptionpublic Ref getRef(int parameterIndex) throws SQLException
getRef in interface CallableStatementSQLExceptionpublic Object getObject(int parameterIndex) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic Object getObject(int parameterIndex, Map map) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic void registerOutParameter(String parameterName, int sqlType) throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
registerOutParameter in interface CallableStatementSQLExceptionpublic URL getURL(int parameterIndex) throws SQLException
getURL in interface CallableStatementSQLExceptionpublic void setURL(String parameterName, URL x) throws SQLException
setURL in interface CallableStatementSQLExceptionpublic void setNull(String parameterName, int sqlType) throws SQLException
setNull in interface CallableStatementSQLExceptionpublic void setBoolean(String parameterName, boolean x) throws SQLException
setBoolean in interface CallableStatementSQLExceptionpublic void setByte(String parameterName, byte x) throws SQLException
setByte in interface CallableStatementSQLExceptionpublic void setShort(String parameterName, short x) throws SQLException
setShort in interface CallableStatementSQLExceptionpublic void setInt(String parameterName, int x) throws SQLException
setInt in interface CallableStatementSQLExceptionpublic void setLong(String parameterName, long x) throws SQLException
setLong in interface CallableStatementSQLExceptionpublic void setFloat(String parameterName, float x) throws SQLException
setFloat in interface CallableStatementSQLExceptionpublic void setDouble(String parameterName, double x) throws SQLException
setDouble in interface CallableStatementSQLExceptionpublic void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
setBigDecimal in interface CallableStatementSQLExceptionpublic void setString(String parameterName, String x) throws SQLException
setString in interface CallableStatementSQLExceptionpublic void setBytes(String parameterName, byte[] x) throws SQLException
setBytes in interface CallableStatementSQLExceptionpublic void setDate(String parameterName, Date x) throws SQLException
setDate in interface CallableStatementSQLExceptionpublic void setTime(String parameterName, Time x) throws SQLException
setTime in interface CallableStatementSQLExceptionpublic void setTimestamp(String parameterName, Timestamp x) throws SQLException
setTimestamp in interface CallableStatementSQLExceptionpublic void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
setAsciiStream in interface CallableStatementSQLExceptionpublic void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
setBinaryStream in interface CallableStatementSQLExceptionpublic void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
setObject in interface CallableStatementSQLExceptionpublic void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObject in interface CallableStatementSQLExceptionpublic void setObject(String parameterName, Object x) throws SQLException
setObject in interface CallableStatementSQLExceptionpublic void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
setCharacterStream in interface CallableStatementSQLExceptionpublic void setDate(String parameterName, Date x, Calendar calendar) throws SQLException
setDate in interface CallableStatementSQLExceptionpublic void setTime(String parameterName, Time x, Calendar calendar) throws SQLException
setTime in interface CallableStatementSQLExceptionpublic void setTimestamp(String parameterName, Timestamp x, Calendar calendar) throws SQLException
setTimestamp in interface CallableStatementSQLExceptionpublic void setNull(String parameterName, int sqlType, String typeName) throws SQLException
setNull in interface CallableStatementSQLExceptionpublic String getString(String parameterName) throws SQLException
getString in interface CallableStatementSQLExceptionpublic boolean getBoolean(String parameterName) throws SQLException
getBoolean in interface CallableStatementSQLExceptionpublic byte getByte(String parameterName) throws SQLException
getByte in interface CallableStatementSQLExceptionpublic short getShort(String parameterName) throws SQLException
getShort in interface CallableStatementSQLExceptionpublic int getInt(String parameterName) throws SQLException
getInt in interface CallableStatementSQLExceptionpublic long getLong(String parameterName) throws SQLException
getLong in interface CallableStatementSQLExceptionpublic float getFloat(String parameterName) throws SQLException
getFloat in interface CallableStatementSQLExceptionpublic double getDouble(String parameterName) throws SQLException
getDouble in interface CallableStatementSQLExceptionpublic byte[] getBytes(String parameterName) throws SQLException
getBytes in interface CallableStatementSQLExceptionpublic Date getDate(String parameterName) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Time getTime(String parameterName) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(String parameterName) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic Object getObject(String parameterName) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic BigDecimal getBigDecimal(String parameterName) throws SQLException
getBigDecimal in interface CallableStatementSQLExceptionpublic Object getObject(String parameterName, Map map) throws SQLException
getObject in interface CallableStatementSQLExceptionpublic Ref getRef(String parameterName) throws SQLException
getRef in interface CallableStatementSQLExceptionpublic Blob getBlob(String parameterName) throws SQLException
getBlob in interface CallableStatementSQLExceptionpublic Clob getClob(String parameterName) throws SQLException
getClob in interface CallableStatementSQLExceptionpublic Array getArray(String parameterName) throws SQLException
getArray in interface CallableStatementSQLExceptionpublic Date getDate(String parameterName, Calendar calendar) throws SQLException
getDate in interface CallableStatementSQLExceptionpublic Time getTime(String parameterName, Calendar calendar) throws SQLException
getTime in interface CallableStatementSQLExceptionpublic Timestamp getTimestamp(String parameterName, Calendar calendar) throws SQLException
getTimestamp in interface CallableStatementSQLExceptionpublic URL getURL(String parameterName) throws SQLException
getURL in interface CallableStatementSQLExceptionpublic Reader getCharacterStream(int parameterIndex) throws SQLException
getCharacterStream in interface CallableStatementSQLExceptionprotected String getJdbcStatementInterfaceName()
getJdbcStatementInterfaceName in class PreparedStatementpublic boolean isCallMode()
isCallMode in class StatementCopyright © 2010-2015 Pivotal Software, Inc. All rights reserved.