java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper, EngineCallableStatement, EnginePreparedStatement, EngineStatementEmbedCallableStatement42public class EmbedCallableStatement extends EmbedPreparedStatement implements EngineCallableStatement
| Modifier and Type | Field | Description |
|---|---|---|
private boolean |
hasReturnOutputParameter |
|
protected boolean |
wasNull |
factory, localConnpreparedStatement, rMetaDataapplicationStatement, batchStatements, isPoolable, lcc, MaxFieldSize, maxRows, results, resultSetConcurrency, resultSetType, SQLText, timeoutMillis, updateCount| Constructor | Description |
|---|---|
EmbedCallableStatement(EmbedConnection conn,
java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
| Modifier and Type | Method | Description |
|---|---|---|
void |
addBatch() |
JDBC 2.0
Add a set of parameters to the batch.
|
protected void |
checkRequiresCallableStatement(Activation activation) |
Check to see if a statement requires to be executed via a callable statement.
|
protected boolean |
executeStatement(Activation a,
boolean executeQuery,
boolean executeUpdate) |
Execute the current statement.
|
java.sql.Array |
getArray(int i) |
JDBC 2.0
Get an Array OUT parameter.
|
java.sql.Array |
getArray(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC ARRAY parameter as an Array object in the
Java programming language.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
JDBC 2.0
Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal
object with as many digits to the right of the decimal point as the value
contains
|
private java.io.InputStream |
getBinaryStream(int parameterIndex) |
Get binary stream for a parameter.
|
java.sql.Blob |
getBlob(int parameterIndex) |
JDBC 2.0
Get a BLOB OUT parameter.
|
java.sql.Blob |
getBlob(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java
programming language.
|
boolean |
getBoolean(int parameterIndex) |
|
boolean |
getBoolean(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC BIT parameter as a boolean in the Java
programming language.
|
byte |
getByte(int parameterIndex) |
|
byte |
getByte(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java
programming language.
|
byte[] |
getBytes(int parameterIndex) |
|
byte[] |
getBytes(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array
of byte values in the Java programming language.
|
java.io.Reader |
getCharacterStream(int parameterIndex) |
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language. |
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
|
java.sql.Clob |
getClob(int parameterIndex) |
JDBC 2.0
Get a CLOB OUT parameter.
|
java.sql.Clob |
getClob(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java
programming language.
|
java.sql.Date |
getDate(int parameterIndex) |
Get the value of a SQL DATE parameter as a java.sql.Date object
|
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal) |
|
java.sql.Date |
getDate(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object
|
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal) |
JDBC 3.0
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object,
using the given Calendar object to construct the date object.
|
double |
getDouble(int parameterIndex) |
|
double |
getDouble(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java
programming language.
|
float |
getFloat(int parameterIndex) |
|
float |
getFloat(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC FLOAT parameter as a float in the Java
programming language.
|
int |
getInt(int parameterIndex) |
|
int |
getInt(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC INTEGER parameter as a int in the Java
programming language.
|
long |
getLong(int parameterIndex) |
|
long |
getLong(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC BIGINT parameter as a long in the Java
programming language.
|
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 parameterName) |
|
java.lang.Object |
getObject(int parameterIndex) |
|
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
JDBC 2.0
Returns an object representing the value of OUT parameter
i. |
java.lang.Object |
getObject(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a parameter as an Object in the java programming
language.
|
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
JDBC 3.0
Returns an object representing the value of OUT parameter i and uses map
for the custom mapping of the parameter value.
|
java.sql.Ref |
getRef(int i) |
JDBC 2.0
Get a REF(<structured-type>) OUT parameter.
|
java.sql.Ref |
getRef(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC REF (structured-type) parameter as a Ref
object in the Java programming language.
|
java.sql.RowId |
getRowId(int parameterIndex) |
|
java.sql.RowId |
getRowId(java.lang.String parameterName) |
|
short |
getShort(int parameterIndex) |
|
short |
getShort(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java
programming language.
|
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) |
JDBC 3.0
Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as
a String in the Java programming language.
|
java.sql.Time |
getTime(int parameterIndex) |
Get the value of a SQL TIME parameter as a java.sql.Time object.
|
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal) |
|
java.sql.Time |
getTime(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object
|
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal) |
JDBC 3.0
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object,
using the given Calendar object to construct the time object.
|
java.sql.Timestamp |
getTimestamp(int parameterIndex) |
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp
object.
|
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp
object
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal) |
JDBC 3.0
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp
object, using the given Calendar object to construct the Timestamp
object.
|
java.net.URL |
getURL(int parameterIndex) |
JDBC 3.0
Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object
|
java.net.URL |
getURL(java.lang.String parameterName) |
JDBC 3.0
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object
|
private java.sql.SQLException |
mismatchException(java.lang.String targetTypeName,
int parameterIndex) |
|
void |
registerOutParameter(int parameterIndex,
int sqlType) |
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName) |
JDBC 2.0
Derby ignores the typeName argument because UDTs don't need it.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType) |
JDBC 3.0
Registers the OUT parameter named parameterName to the JDBC type sqlType.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale) |
JDBC 3.0
Registers the parameter named parameterName to the JDBC type sqlType.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
JDBC 3.0
Registers the designated output parameter.
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
JDBC 3.0
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x) |
JDBC 3.0
Sets the designated parameter to the given java.math.BigDecimal value.
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
JDBC 3.0
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
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) |
JDBC 3.0
Sets the designated parameter to the given Java boolean value.
|
void |
setByte(java.lang.String parameterName,
byte x) |
JDBC 3.0
Sets the designated parameter to the given Java byte value.
|
void |
setBytes(java.lang.String parameterName,
byte[] x) |
JDBC 3.0
Sets the designated parameter to the given Java array of bytes.
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length) |
JDBC 3.0
Sets the designated parameter to the given Reader object, which is the
given number of characters long.
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
long length) |
Sets the designated parameter to the given Reader, which will have the
specified number of bytes.
|
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) |
JDBC 3.0
Sets the designated parameter to the given java.sql.Date value.
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal) |
JDBC 3.0
Sets the designated parameter to the given java.sql.Date value, using the
given Calendar object.
|
void |
setDouble(java.lang.String parameterName,
double x) |
JDBC 3.0
Sets the designated parameter to the given Java double value.
|
void |
setFloat(java.lang.String parameterName,
float x) |
JDBC 3.0
Sets the designated parameter to the given Java float value.
|
void |
setInt(java.lang.String parameterName,
int x) |
JDBC 3.0
Sets the designated parameter to the given Java int value.
|
void |
setLong(java.lang.String parameterName,
long x) |
JDBC 3.0
Sets the designated parameter to the given Java long value.
|
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) |
JDBC 3.0
Sets the designated parameter to SQL NULL.
|
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
JDBC 3.0
Sets the designated parameter to SQL NULL.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x) |
JDBC 3.0
Sets the value of the designated parameter with the given object.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType) |
JDBC 3.0
Sets the value of the designated parameter with the given object.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale) |
JDBC 3.0
Sets the value of the designated parameter with the given object.
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x) |
|
void |
setShort(java.lang.String parameterName,
short x) |
JDBC 3.0
Sets the designated parameter to the given Java short value.
|
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
|
void |
setString(java.lang.String parameterName,
java.lang.String x) |
JDBC 3.0
Sets the designated parameter to the given Java String value.
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x) |
JDBC 3.0
Sets the designated parameter to the given java.sql.Time value.
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal) |
JDBC 3.0
Sets the designated parameter to the given java.sql.Time value using the
Calendar object
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x) |
JDBC 3.0
Sets the designated parameter to the given java.sql.Timestamp value.
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal) |
JDBC 3.0
Sets the designated parameter to the given java.sql.Timestamp value,
using the given Calendar object
|
void |
setURL(java.lang.String parameterName,
java.net.URL val) |
JDBC 3.0
Sets the designated parameter to the given java.net.URL object.
|
boolean |
wasNull() |
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObjectcommitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, getLanguageConnectionContext, getLCC, handleException, needCommit, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStackaddBatch, clearParameters, closeActions, dataTypeConversion, execute, execute, execute, execute, execute, executeBatchElement, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getMetaData, getParameterJDBCType, getParameterMetaData, getParameterSQLType, getParms, getVersionCounter, newEmbedResultSetMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBrokeredConnectionControl, 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, setURL, toString, transferParametersaddWarning, cancel, checkExecStatus, checkIfInMiddleOfBatch, checkStatus, clearBatch, clearResultSets, clearWarnings, close, closeMeOnCompletion, closeOnCompletion, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getParameterValueSet, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQLText, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, processDynamicResult, resultSetClosing, setApplicationStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, transferBatch, unwrapcloseOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRowsclone, equals, getClass, hashCode, notify, notifyAll, wait, wait, waitclearParameters, 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, setURLaddBatch, cancel, clearBatch, clearWarnings, close, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, 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, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutprivate boolean hasReturnOutputParameter
protected boolean wasNull
public EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
java.sql.SQLException - thrown on failureprotected void checkRequiresCallableStatement(Activation activation)
EmbedStatementcheckRequiresCallableStatement in class EmbedStatementprotected final boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws java.sql.SQLException
EmbedStatementexecuteStatement in class EmbedPreparedStatementjava.sql.SQLException - thrown on failure.public final void registerOutParameter(int parameterIndex,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.registerOutParameter(int, int)public final void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.registerOutParameter(int, int)public void registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLException - if a database-access error occurs.public boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.wasNull()public java.lang.String getString(int parameterIndex)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getString(int)public boolean getBoolean(int parameterIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getBoolean(int)public byte getByte(int parameterIndex)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getByte(int)public short getShort(int parameterIndex)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getShort(int)public int getInt(int parameterIndex)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getInt(int)public long getLong(int parameterIndex)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getLong(int)public final java.math.BigDecimal getBigDecimal(int parameterIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public final java.math.BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getBigDecimal(int, int)public float getFloat(int parameterIndex)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getFloat(int)public double getDouble(int parameterIndex)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getDouble(int)public byte[] getBytes(int parameterIndex)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getBytes(int)public java.sql.Date getDate(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getDate(int)public java.sql.Time getTime(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getTime(int)public java.sql.Timestamp getTimestamp(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getTimestamp(int)public java.sql.Date getDate(int parameterIndex)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(int parameterIndex)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(int parameterIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public final java.lang.Object getObject(int parameterIndex)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLException - NoOutputParameters thrown.CallableStatement.getObject(int)public java.net.URL getURL(int parameterIndex)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementparameterIndex - - the first parameter is 1, the second is 2java.sql.SQLException - Feature not implemented for now.public void setURL(java.lang.String parameterName,
java.net.URL val)
throws java.sql.SQLException
setURL in interface java.sql.CallableStatementparameterName - - the name of the parameterval - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public java.net.URL getURL(java.lang.String parameterName)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public java.sql.Blob getBlob(int parameterIndex)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.sql.Clob getClob(int parameterIndex)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public void addBatch()
throws java.sql.SQLException
EmbedPreparedStatementaddBatch in interface java.sql.PreparedStatementaddBatch in class EmbedPreparedStatementjava.sql.SQLException - if a database-access error occurs.public final java.lang.Object getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
i.
Use the map to determine the class from which to construct data of SQL
structured and distinct types.getObject in interface java.sql.CallableStatementi - the first parameter is 1, the second is 2, ...map - the mapping from SQL type names to Java classesjava.sql.SQLException - if a database-access error occurs.public final java.sql.Ref getRef(int i)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementi - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public final java.sql.Array getArray(int i)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementi - the first parameter is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public final void registerOutParameter(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterName - - the name of the parametersqlType - - the JDBC type code defined by java.sql.Types. If the
parameter is of JDBC type NUMERIC or DECIMAL, the version of
registerOutParameter that accepts a scale value should be used.java.sql.SQLException - Feature not implemented for now.public final void registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterName - - the name of the parametersqlType - - the SQL type code defined by java.sql.Types.typeName - - the fully-qualified name of an SQL structure typejava.sql.SQLException - Feature not implemented for now.public final void registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterName - - the name of the parametersqlType - - the SQL type code defined by java.sql.Types.scale - - the desired number of digits to the right of the decimal
point. It must be greater than or equal to zero.java.sql.SQLException - Feature not implemented for now.public final java.sql.Ref getRef(java.lang.String parameterName)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.sql.Blob getBlob(java.lang.String parameterName)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.sql.Clob getClob(java.lang.String parameterName)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.sql.Array getArray(java.lang.String parameterName)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setNull(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementparameterName - - the name of the parametersqlType - - the SQL type code defined in java.sql.Typesjava.sql.SQLException - Feature not implemented for now.public final void setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementparameterName - - the name of the parametersqlType - - the SQL type code defined in java.sql.TypestypeName - - the fully-qualified name of an SQL user-defined typejava.sql.SQLException - Feature not implemented for now.public final void setBoolean(java.lang.String parameterName,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final boolean getBoolean(java.lang.String parameterName)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setByte(java.lang.String parameterName,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final byte getByte(java.lang.String parameterName)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setShort(java.lang.String parameterName,
short x)
throws java.sql.SQLException
setShort in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final short getShort(java.lang.String parameterName)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setInt(java.lang.String parameterName,
int x)
throws java.sql.SQLException
setInt in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final int getInt(java.lang.String parameterName)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setLong(java.lang.String parameterName,
long x)
throws java.sql.SQLException
setLong in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final long getLong(java.lang.String parameterName)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setFloat(java.lang.String parameterName,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final float getFloat(java.lang.String parameterName)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setDouble(java.lang.String parameterName,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final double getDouble(java.lang.String parameterName)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final java.math.BigDecimal getBigDecimal(java.lang.String parameterName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setString(java.lang.String parameterName,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final java.lang.String getString(java.lang.String parameterName)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setBytes(java.lang.String parameterName,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final byte[] getBytes(java.lang.String parameterName)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final void setDate(java.lang.String parameterName,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final void setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuecal - - the Calendar object the driver will use to construct the
datejava.sql.SQLException - Feature not implemented for now.public final java.sql.Date getDate(java.lang.String parameterName)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.sql.Date getDate(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterName - - the name of the parametercal - - the Calendar object the driver will use to construct the
datejava.sql.SQLException - Feature not implemented for now.public final void setTime(java.lang.String parameterName,
java.sql.Time x)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final java.sql.Time getTime(java.lang.String parameterName)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.sql.Time getTime(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterName - - the name of the parametercal - - the Calendar object the driver will use to construct the
timejava.sql.SQLException - Feature not implemented for now.public final void setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuecal - - the Calendar object the driver will use to construct the
timejava.sql.SQLException - Feature not implemented for now.public final void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuejava.sql.SQLException - Feature not implemented for now.public final void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the parameter valuecal - - the Calendar object the driver will use to construct the
timestamp.java.sql.SQLException - Feature not implemented for now.public final java.sql.Timestamp getTimestamp(java.lang.String parameterName)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.sql.Timestamp getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterName - - the name of the parametercal - - the Calendar object the driver will use to construct the
Timestampjava.sql.SQLException - Feature not implemented for now.public final void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the Java input stream that contains the ASCII parameter valuelength - - the number of bytes in the streamjava.sql.SQLException - Feature not implemented for now.public final void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the Java input stream that contains the binary parameter valuelength - - the number of bytes in the streamjava.sql.SQLException - Feature not implemented for now.public final void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementparameterName - - the name of the parameterreader - - the java.io.Reader object that contains the UNICODE datalength - - the number of characters in the streamjava.sql.SQLException - Feature not implemented for now.public final void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the object containing the input parameter valuetargetSqlType - - the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type.scale - - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC
types, this is the number of digits after the decimal point. For all
other types, this value will be ignored.java.sql.SQLException - Feature not implemented for now.public final java.lang.Object getObject(java.lang.String parameterName)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementparameterName - - the name of the parameterjava.sql.SQLException - Feature not implemented for now.public final java.lang.Object getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementparameterName - - the name of the parametermap - - the mapping from SQL type names to Java classesjava.sql.SQLException - Feature not implemented for now.public final void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the object containing the input parameter valuetargetSqlType - - the SQL type (as defined in java.sql.Types) to be
sent to the database.java.sql.SQLException - Feature not implemented for now.public final void setObject(java.lang.String parameterName,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementparameterName - - the name of the parameterx - - the object containing the input parameter valuejava.sql.SQLException - Feature not implemented for now.public final java.io.Reader getCharacterStream(int parameterIndex)
throws java.sql.SQLException
java.io.Reader object in the Java programming language.
Introduced in JDBC 4.0.getCharacterStream in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned
is null in the Java programming language.java.sql.SQLException - if a database access error occurs or this method is
called on a closed CallableStatementprivate java.io.InputStream getBinaryStream(int parameterIndex)
throws java.sql.SQLException
parameterIndex - first parameter is 1, second is 2 etc.null.java.sql.SQLException - if a database access error occurs.public final java.io.Reader getCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
getCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.io.Reader getNCharacterStream(int parameterIndex)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.io.Reader getNCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
getNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.lang.String getNString(int parameterIndex)
throws java.sql.SQLException
getNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.lang.String getNString(java.lang.String parameterName)
throws java.sql.SQLException
getNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setBlob(java.lang.String parameterName,
java.sql.Blob x)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setClob(java.lang.String parameterName,
java.sql.Clob x)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.sql.RowId getRowId(int parameterIndex)
throws java.sql.SQLException
getRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.sql.RowId getRowId(java.lang.String parameterName)
throws java.sql.SQLException
getRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setRowId(java.lang.String parameterName,
java.sql.RowId x)
throws java.sql.SQLException
setRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setNString(java.lang.String parameterName,
java.lang.String value)
throws java.sql.SQLException
setNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
throws java.sql.SQLException
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setNClob(java.lang.String parameterName,
java.sql.NClob value)
throws java.sql.SQLException
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.sql.NClob getNClob(int i)
throws java.sql.SQLException
getNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.sql.NClob getNClob(java.lang.String parameterName)
throws java.sql.SQLException
getNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
setSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.sql.SQLXML getSQLXML(int parameterIndex)
throws java.sql.SQLException
getSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final java.sql.SQLXML getSQLXML(java.lang.String parametername)
throws java.sql.SQLException
getSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
throws java.sql.SQLException
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic final void setNClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setNClob 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.CallableStatementparameterName - the name of the first parameterx - the java input stream which contains the ASCII parameter valuelength - the number of bytes in the streamjava.sql.SQLException - thrown on failure.public final void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementparameterName - the name of the first parameterx - the java input stream which contains the binary parameter valuelength - the number of bytes in the streamjava.sql.SQLException - thrown on failure.public final void setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
long length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementparameterName - the name of the first parameterx - the java Reader which contains the UNICODE valuelength - the number of bytes in the streamjava.sql.SQLException - thrown on failure.public final <T> T getObject(int parameterIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementgetObject in interface EngineCallableStatementjava.sql.SQLExceptionprivate java.sql.SQLException mismatchException(java.lang.String targetTypeName,
int parameterIndex)
throws java.sql.SQLException
java.sql.SQLExceptionpublic final <T> T getObject(java.lang.String parameterName,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementgetObject in interface EngineCallableStatementjava.sql.SQLExceptionApache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.