Package org.apache.derby.client.am
Class ClientCallableStatement
- java.lang.Object
-
- org.apache.derby.client.am.ClientStatement
-
- org.apache.derby.client.am.ClientPreparedStatement
-
- org.apache.derby.client.am.ClientCallableStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.CallableStatement
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
,PreparedStatementCallbackInterface
,StatementCallbackInterface
,UnitOfWorkListener
- Direct Known Subclasses:
ClientCallableStatement42
public class ClientCallableStatement extends ClientPreparedStatement implements java.sql.PreparedStatement, java.sql.CallableStatement, PreparedStatementCallbackInterface
-
-
Field Summary
Fields 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_
-
Fields inherited from class org.apache.derby.client.am.ClientPreparedStatement
materialPreparedStatement_, outputRegistered_, parameterMetaData_, parameterRegistered_, parameters_, sql_
-
Fields inherited from class org.apache.derby.client.am.ClientStatement
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 Summary
Constructors 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.
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods 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 itvoid
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()
-
Methods inherited from class org.apache.derby.client.am.ClientPreparedStatement
addBatch, 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, setURL
-
Methods inherited from class org.apache.derby.client.am.ClientStatement
accumulateWarning, 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, writeSetSpecialRegister
-
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
-
Methods inherited from interface java.sql.PreparedStatement
addBatch, 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, setURL
-
Methods inherited from interface org.apache.derby.client.am.PreparedStatementCallbackInterface
completeDescribeInput, completeDescribeOutput
-
Methods inherited from interface java.sql.Statement
addBatch, 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, setQueryTimeout
-
Methods inherited from interface org.apache.derby.client.am.StatementCallbackInterface
accumulateWarning, completeExecute, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, getConnectionCallbackInterface, getGuessedResultSetMetaData
-
Methods inherited from interface org.apache.derby.client.am.UnitOfWorkListener
completeLocalCommit, completeLocalRollback, listenToUnitOfWork
-
-
-
-
Field Detail
-
materialCallableStatement_
public MaterialPreparedStatement materialCallableStatement_
-
wasNull_
private int wasNull_
-
WAS_NULL
private static final int WAS_NULL
- See Also:
- Constant Field Values
-
WAS_NOT_NULL
private static final int WAS_NOT_NULL
- See Also:
- Constant Field Values
-
WAS_NULL_UNSET
private static final int WAS_NULL_UNSET
- See Also:
- Constant Field Values
-
-
Constructor Detail
-
ClientCallableStatement
public ClientCallableStatement(Agent agent, ClientConnection connection, java.lang.String sql, int type, int concurrency, int holdability, ClientPooledConnection cpc) throws SqlException
Common constructor for jdbc 2 callable statements with scroll attributes. Called by material statement constructor.- Parameters:
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.- Throws:
SqlException
-
-
Method Detail
-
initCallableStatement
private void initCallableStatement()
-
reset
public void reset(boolean fullReset) throws SqlException
- Overrides:
reset
in classClientPreparedStatement
- Throws:
SqlException
-
resetCallableStatement
public void resetCallableStatement(Agent agent, ClientConnection connection, java.lang.String sql, int type, int concurrency, int holdability) throws SqlException
- Throws:
SqlException
-
finalize
protected void finalize() throws java.lang.Throwable
- Overrides:
finalize
in classClientStatement
- Throws:
java.lang.Throwable
-
clearParameters
public void clearParameters() throws java.sql.SQLException
- Specified by:
clearParameters
in interfacejava.sql.PreparedStatement
- Overrides:
clearParameters
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int jdbcType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameterX
void registerOutParameterX(int parameterIndex, int jdbcType) throws SqlException
- Throws:
SqlException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int jdbcType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameterX
private void registerOutParameterX(int parameterIndex, int jdbcType, int scale) throws SqlException
- Throws:
SqlException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int jdbcType, java.lang.String typeName) throws java.sql.SQLException
Derby ignores the typeName argument because UDTs don't need it- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
wasNull
public boolean wasNull() throws java.sql.SQLException
- Specified by:
wasNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
wasNullX
private boolean wasNullX() throws SqlException
- Throws:
SqlException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getIntX
int getIntX(int parameterIndex) throws SqlException
- Throws:
SqlException
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLongX
long getLongX(int parameterIndex) throws SqlException
- Throws:
SqlException
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException, java.lang.ArithmeticException
Deprecated.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
java.lang.ArithmeticException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getStringX
java.lang.String getStringX(int parameterIndex) throws SqlException
- Throws:
SqlException
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytesX
byte[] getBytesX(int parameterIndex) throws SqlException
- Throws:
SqlException
-
getBlob
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex, java.util.Map map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL x) throws java.sql.SQLException
- Specified by:
setURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
- Specified by:
setBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
- Specified by:
setByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
- Specified by:
setShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
- Specified by:
setInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
- Specified by:
setLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
- Specified by:
setFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
- Specified by:
setDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
setBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
- Specified by:
setString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
- Specified by:
setBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar calendar) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar calendar) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar calendar) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar calendar) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar calendar) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar calendar) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String parameterIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setRowId
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
setRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNString
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int i) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setSQLXML
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
setSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String parametername) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
mismatchException
private java.sql.SQLException mismatchException(java.lang.String targetTypeName, int parameterIndex) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
completeExecuteCall
public void completeExecuteCall(Sqlca sqlca, Cursor singletonParams)
- Specified by:
completeExecuteCall
in interfaceStatementCallbackInterface
- Overrides:
completeExecuteCall
in classClientStatement
-
getJdbcStatementInterfaceName
protected java.lang.String getJdbcStatementInterfaceName()
Returns the name of the java.sql interface implemented by this class.- Overrides:
getJdbcStatementInterfaceName
in classClientPreparedStatement
- Returns:
- name of java.sql interface
-
checkGetterPreconditions
private void checkGetterPreconditions(int parameterIndex) throws SqlException
- Throws:
SqlException
-
checkForValidOutParameter
private void checkForValidOutParameter(int parameterIndex) throws SqlException
- Throws:
SqlException
-
setWasNull
private void setWasNull(int parameterIndex)
-
jdbcMethodNotImplemented
java.sql.SQLException jdbcMethodNotImplemented() throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-