java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper, PreparedStatementCallbackInterface, StatementCallbackInterface, UnitOfWorkListenerClientCallableStatement42public class ClientCallableStatement extends ClientPreparedStatement implements java.sql.PreparedStatement, java.sql.CallableStatement, PreparedStatementCallbackInterface
| Modifier and Type | Field | Description |
|---|---|---|
MaterialPreparedStatement |
materialCallableStatement_ |
|
private static int |
WAS_NOT_NULL |
|
private static int |
WAS_NULL |
|
private static int |
WAS_NULL_UNSET |
|
private int |
wasNull_ |
materialPreparedStatement_, outputRegistered_, parameterMetaData_, parameterRegistered_, parameters_, sql_agent_, autoGeneratedKeys_, batch_, cachedCursor_, cachedSingletonRowData_, connection_, cursorAttributesToSendOnPrepare_, cursorName_, doWriteTimeout, executeMethod__, executeQueryMethod__, executeUpdateMethod__, fetchDirection_, fetchSize_, generatedKeysColumnIndexes_, generatedKeysColumnNames_, generatedKeysResultSet_, isAutoCommittableStatement_, isCall__, isCatalogQuery_, isDeleteSql__, isInsertSql__, isPoolable, isPreparedStatement_, isQuery__, isUpdate__, isUpdateSql__, maxFieldSize_, maxRows_, openOnClient_, preparedStatementForAutoGeneratedKeys_, resultSet_, resultSetConcurrency_, resultSetHoldability_, resultSetList_, resultSetMetaData_, resultSetType_, singletonRowData_, sqlMode_, sqlUpdateMode_, timeout_, TIMEOUT_STATEMENT, timeoutArrayList, updateCount_| Constructor | Description |
|---|---|
ClientCallableStatement(Agent agent,
ClientConnection connection,
java.lang.String sql,
int type,
int concurrency,
int holdability,
ClientPooledConnection cpc) |
Common constructor for jdbc 2 callable statements with scroll attributes.
|
| Modifier and Type | Method | Description |
|---|---|---|
private void |
checkForValidOutParameter(int parameterIndex) |
|
private void |
checkGetterPreconditions(int parameterIndex) |
|
void |
clearParameters() |
|
void |
completeExecuteCall(Sqlca sqlca,
Cursor singletonParams) |
|
protected void |
finalize() |
|
java.sql.Array |
getArray(int parameterIndex) |
|
java.sql.Array |
getArray(java.lang.String parameterName) |
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName) |
|
java.sql.Blob |
getBlob(int parameterIndex) |
|
java.sql.Blob |
getBlob(java.lang.String parameterName) |
|
boolean |
getBoolean(int parameterIndex) |
|
boolean |
getBoolean(java.lang.String parameterName) |
|
byte |
getByte(int parameterIndex) |
|
byte |
getByte(java.lang.String parameterName) |
|
byte[] |
getBytes(int parameterIndex) |
|
byte[] |
getBytes(java.lang.String parameterName) |
|
(package private) byte[] |
getBytesX(int parameterIndex) |
|
java.io.Reader |
getCharacterStream(int parameterIndex) |
|
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
|
java.sql.Clob |
getClob(int parameterIndex) |
|
java.sql.Clob |
getClob(java.lang.String parameterName) |
|
java.sql.Date |
getDate(int parameterIndex) |
|
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal) |
|
java.sql.Date |
getDate(java.lang.String parameterName) |
|
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar calendar) |
|
double |
getDouble(int parameterIndex) |
|
double |
getDouble(java.lang.String parameterName) |
|
float |
getFloat(int parameterIndex) |
|
float |
getFloat(java.lang.String parameterName) |
|
int |
getInt(int parameterIndex) |
|
int |
getInt(java.lang.String parameterName) |
|
(package private) int |
getIntX(int parameterIndex) |
|
protected java.lang.String |
getJdbcStatementInterfaceName() |
Returns the name of the java.sql interface implemented by this class.
|
long |
getLong(int parameterIndex) |
|
long |
getLong(java.lang.String parameterName) |
|
(package private) long |
getLongX(int parameterIndex) |
|
java.io.Reader |
getNCharacterStream(int parameterIndex) |
|
java.io.Reader |
getNCharacterStream(java.lang.String parameterName) |
|
java.sql.NClob |
getNClob(int i) |
|
java.sql.NClob |
getNClob(java.lang.String parameterName) |
|
java.lang.String |
getNString(int parameterIndex) |
|
java.lang.String |
getNString(java.lang.String parameterIndex) |
|
java.lang.Object |
getObject(int parameterIndex) |
|
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(int parameterIndex,
java.util.Map map) |
|
java.lang.Object |
getObject(java.lang.String parameterName) |
|
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map map) |
|
java.sql.Ref |
getRef(int parameterIndex) |
|
java.sql.Ref |
getRef(java.lang.String parameterName) |
|
java.sql.RowId |
getRowId(int parameterIndex) |
|
java.sql.RowId |
getRowId(java.lang.String parameterName) |
|
short |
getShort(int parameterIndex) |
|
short |
getShort(java.lang.String parameterName) |
|
java.sql.SQLXML |
getSQLXML(int parameterIndex) |
|
java.sql.SQLXML |
getSQLXML(java.lang.String parametername) |
|
java.lang.String |
getString(int parameterIndex) |
|
java.lang.String |
getString(java.lang.String parameterName) |
|
(package private) java.lang.String |
getStringX(int parameterIndex) |
|
java.sql.Time |
getTime(int parameterIndex) |
|
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal) |
|
java.sql.Time |
getTime(java.lang.String parameterName) |
|
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar calendar) |
|
java.sql.Timestamp |
getTimestamp(int parameterIndex) |
|
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar calendar) |
|
java.net.URL |
getURL(int parameterIndex) |
|
java.net.URL |
getURL(java.lang.String parameterName) |
|
private void |
initCallableStatement() |
|
(package private) java.sql.SQLException |
jdbcMethodNotImplemented() |
|
private java.sql.SQLException |
mismatchException(java.lang.String targetTypeName,
int parameterIndex) |
|
void |
registerOutParameter(int parameterIndex,
int jdbcType) |
|
void |
registerOutParameter(int parameterIndex,
int jdbcType,
int scale) |
|
void |
registerOutParameter(int parameterIndex,
int jdbcType,
java.lang.String typeName) |
Derby ignores the typeName argument because UDTs don't need it
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
|
(package private) void |
registerOutParameterX(int parameterIndex,
int jdbcType) |
|
private void |
registerOutParameterX(int parameterIndex,
int jdbcType,
int scale) |
|
void |
reset(boolean fullReset) |
|
void |
resetCallableStatement(Agent agent,
ClientConnection connection,
java.lang.String sql,
int type,
int concurrency,
int holdability) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream) |
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
|
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x) |
|
void |
setBoolean(java.lang.String parameterName,
boolean x) |
|
void |
setByte(java.lang.String parameterName,
byte x) |
|
void |
setBytes(java.lang.String parameterName,
byte[] x) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
long length) |
|
void |
setClob(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
|
void |
setClob(java.lang.String parameterName,
java.sql.Clob x) |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x) |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar calendar) |
|
void |
setDouble(java.lang.String parameterName,
double x) |
|
void |
setFloat(java.lang.String parameterName,
float x) |
|
void |
setInt(java.lang.String parameterName,
int x) |
|
void |
setLong(java.lang.String parameterName,
long x) |
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
|
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value) |
|
void |
setNString(java.lang.String parameterName,
java.lang.String value) |
|
void |
setNull(java.lang.String parameterName,
int sqlType) |
|
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale) |
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x) |
|
void |
setShort(java.lang.String parameterName,
short x) |
|
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
|
void |
setString(java.lang.String parameterName,
java.lang.String x) |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x) |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar calendar) |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x) |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar calendar) |
|
void |
setURL(java.lang.String parameterName,
java.net.URL x) |
|
private void |
setWasNull(int parameterIndex) |
|
boolean |
wasNull() |
|
private boolean |
wasNullX() |
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObjectaddBatch, addBatch, checkForValidParameterIndex, checkForValidScale, checkStatus, completeDescribeInput, completeDescribeOutput, completeLocalCommit, completeLocalRollback, execute, execute, execute, execute, execute, executeBatch, executeLargeUpdate, executeQuery, executeQuery, executeQueryX, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeX, flowPrepareDescribeInputOutput, getMetaData, getParameterMetaData, initResetPreparedStatement, listenToUnitOfWork, markClosed, prepare, resetForReuse, resetPreparedStatement, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setBytesX, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInput, setInt, setIntX, setLong, setLongX, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setNullX, setObject, setObject, setObject, setRef, setRowId, setShort, setShortX, setSQLXML, setString, setStringX, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLaccumulateWarning, cacheCursorAttributesToSendOnPrepare, cancel, checkAutoGeneratedKeysParameters, checkForAppropriateSqlMode, checkForClosedStatement, checkForDuplicateCursorName, checkForStoredProcResultSetCount, clearBatch, clearWarnings, clearWarningsX, close, closeMeOnCompletion, closeOnCompletion, closeX, completeExecute, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, escape, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeX, extractCursorNameFromWhereCurrentOf, getConnection, getConnectionCallbackInterface, getFetchDirection, getFetchSize, getGeneratedKeys, getGuessedResultSetMetaData, getLargeMaxRows, getLargeUpdateCount, getMaterialStatement, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getOwner, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSection, getSqlWarnings, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isQueryMode, isWrapperFor, markClosed, markResultSetsClosed, parseSqlAndSetSqlModes, parseStorProcReturnedScrollableRowset, prepareAutoGeneratedKeysStatement, readClose, readCloseResultSets, readExecuteCall, readOpenQuery, readPrepare, readPrepareDescribeOutput, readSetSpecialRegister, removeClientCursorNameFromCache, resetCursorNameAndRemoveFromWhereCurrentOfMappings, resetResultSetList, resetStatement, resetStatement, resultSetCommitting, resultSetCommitting, setCursorName, setEscapeProcessing, setFetchDirection, setFetchedRowBase, setFetchSize, setLargeMaxRows, setMaterialStatement, setMaxFieldSize, setMaxRows, setOwner, setPoolable, setQueryTimeout, setSection, setupCursorNameCacheAndMappings, setUpdateCount, substituteClientCursorNameWithServerCursorName, unwrap, writeClose, writeCloseResultSets, writeExecuteCall, writeOpenQuery, writePrepare, writePrepareDescribeOutput, writeSetSpecialRegisterclone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitaddBatch, execute, executeLargeUpdate, 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, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLcompleteDescribeInput, completeDescribeOutputaddBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutaccumulateWarning, completeExecute, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, getConnectionCallbackInterface, getGuessedResultSetMetaDatacompleteLocalCommit, completeLocalRollback, listenToUnitOfWorkpublic MaterialPreparedStatement materialCallableStatement_
private int wasNull_
private static final int WAS_NULL
private static final int WAS_NOT_NULL
private static final int WAS_NULL_UNSET
public ClientCallableStatement(Agent agent, ClientConnection connection, java.lang.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.SqlExceptionprivate void initCallableStatement()
public void reset(boolean fullReset)
throws SqlException
reset in class ClientPreparedStatementSqlExceptionpublic void resetCallableStatement(Agent agent, ClientConnection connection, java.lang.String sql, int type, int concurrency, int holdability) throws SqlException
SqlExceptionprotected void finalize()
throws java.lang.Throwable
finalize in class ClientStatementjava.lang.Throwablepublic void clearParameters()
throws java.sql.SQLException
clearParameters in interface java.sql.PreparedStatementclearParameters in class ClientPreparedStatementjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
int jdbcType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionvoid registerOutParameterX(int parameterIndex,
int jdbcType)
throws SqlException
SqlExceptionpublic void registerOutParameter(int parameterIndex,
int jdbcType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionprivate void registerOutParameterX(int parameterIndex,
int jdbcType,
int scale)
throws SqlException
SqlExceptionpublic void registerOutParameter(int parameterIndex,
int jdbcType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.CallableStatementjava.sql.SQLExceptionprivate boolean wasNullX()
throws SqlException
SqlExceptionpublic boolean getBoolean(int parameterIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte getByte(int parameterIndex)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic short getShort(int parameterIndex)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic int getInt(int parameterIndex)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionint getIntX(int parameterIndex)
throws SqlException
SqlExceptionpublic long getLong(int parameterIndex)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionlong getLongX(int parameterIndex)
throws SqlException
SqlExceptionpublic float getFloat(int parameterIndex)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic double getDouble(int parameterIndex)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws java.sql.SQLException,
java.lang.ArithmeticException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionjava.lang.ArithmeticExceptionpublic java.math.BigDecimal getBigDecimal(int parameterIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(int parameterIndex)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(int parameterIndex)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int parameterIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getString(int parameterIndex)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionjava.lang.String getStringX(int parameterIndex)
throws SqlException
SqlExceptionpublic byte[] getBytes(int parameterIndex)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionbyte[] getBytesX(int parameterIndex)
throws SqlException
SqlExceptionpublic java.sql.Blob getBlob(int parameterIndex)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Clob getClob(int parameterIndex)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Array getArray(int parameterIndex)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Ref getRef(int parameterIndex)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(int parameterIndex)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(int parameterIndex,
java.util.Map map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.net.URL getURL(int parameterIndex)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setURL(java.lang.String parameterName,
java.net.URL x)
throws java.sql.SQLException
setURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNull(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBoolean(java.lang.String parameterName,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setByte(java.lang.String parameterName,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setShort(java.lang.String parameterName,
short x)
throws java.sql.SQLException
setShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setInt(java.lang.String parameterName,
int x)
throws java.sql.SQLException
setInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setLong(java.lang.String parameterName,
long x)
throws java.sql.SQLException
setLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setFloat(java.lang.String parameterName,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDouble(java.lang.String parameterName,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setString(java.lang.String parameterName,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBytes(java.lang.String parameterName,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDate(java.lang.String parameterName,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTime(java.lang.String parameterName,
java.sql.Time x)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String parameterName,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar calendar)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar calendar)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar calendar)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getString(java.lang.String parameterName)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic boolean getBoolean(java.lang.String parameterName)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte getByte(java.lang.String parameterName)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic short getShort(java.lang.String parameterName)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic int getInt(java.lang.String parameterName)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic long getLong(java.lang.String parameterName)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic float getFloat(java.lang.String parameterName)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic double getDouble(java.lang.String parameterName)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte[] getBytes(java.lang.String parameterName)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String parameterName)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(java.lang.String parameterName)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String parameterName)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String parameterName)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(java.lang.String parameterName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String parameterName,
java.util.Map map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Ref getRef(java.lang.String parameterName)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Blob getBlob(java.lang.String parameterName)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Clob getClob(java.lang.String parameterName)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Array getArray(java.lang.String parameterName)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String parameterName,
java.util.Calendar calendar)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(java.lang.String parameterName,
java.util.Calendar calendar)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String parameterName,
java.util.Calendar calendar)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.net.URL getURL(java.lang.String parameterName)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getCharacterStream(int parameterIndex)
throws java.sql.SQLException
getCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
long length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
getCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getNCharacterStream(int parameterIndex)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getNCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getNString(int parameterIndex)
throws java.sql.SQLException
getNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getNString(java.lang.String parameterIndex)
throws java.sql.SQLException
getNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.RowId getRowId(int parameterIndex)
throws java.sql.SQLException
getRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.RowId getRowId(java.lang.String parameterName)
throws java.sql.SQLException
getRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setRowId(java.lang.String parameterName,
java.sql.RowId x)
throws java.sql.SQLException
setRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.sql.Blob x)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.sql.Clob x)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNString(java.lang.String parameterName,
java.lang.String value)
throws java.sql.SQLException
setNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
throws java.sql.SQLException
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNClob(java.lang.String parameterName,
java.sql.NClob value)
throws java.sql.SQLException
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.NClob getNClob(int i)
throws java.sql.SQLException
getNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.NClob getNClob(java.lang.String parameterName)
throws java.sql.SQLException
getNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
setSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.SQLXML getSQLXML(int parameterIndex)
throws java.sql.SQLException
getSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.SQLXML getSQLXML(java.lang.String parametername)
throws java.sql.SQLException
getSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
throws java.sql.SQLException
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic <T> T getObject(int parameterIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionprivate java.sql.SQLException mismatchException(java.lang.String targetTypeName,
int parameterIndex)
throws java.sql.SQLException
java.sql.SQLExceptionpublic <T> T getObject(java.lang.String parameterName,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void completeExecuteCall(Sqlca sqlca, Cursor singletonParams)
completeExecuteCall in interface StatementCallbackInterfacecompleteExecuteCall in class ClientStatementprotected java.lang.String getJdbcStatementInterfaceName()
getJdbcStatementInterfaceName in class ClientPreparedStatementprivate void checkGetterPreconditions(int parameterIndex)
throws SqlException
SqlExceptionprivate void checkForValidOutParameter(int parameterIndex)
throws SqlException
SqlExceptionprivate void setWasNull(int parameterIndex)
java.sql.SQLException jdbcMethodNotImplemented()
throws java.sql.SQLException
java.sql.SQLExceptionApache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.