java.lang.AutoCloseable
, java.sql.CallableStatement
, java.sql.PreparedStatement
, java.sql.Statement
, java.sql.Wrapper
, EngineCallableStatement
, EnginePreparedStatement
, EngineStatement
EmbedCallableStatement42
public class EmbedCallableStatement extends EmbedPreparedStatement implements EngineCallableStatement
Modifier and Type | Field | Description |
---|---|---|
private boolean |
hasReturnOutputParameter |
|
protected boolean |
wasNull |
factory, localConn
preparedStatement, rMetaData
applicationStatement, 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, setObject
commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, getLanguageConnectionContext, getLCC, handleException, needCommit, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack
addBatch, 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, transferParameters
addWarning, 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, unwrap
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRows
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
clearParameters, 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
addBatch, 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, setQueryTimeout
private 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)
EmbedStatement
checkRequiresCallableStatement
in class EmbedStatement
protected final boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws java.sql.SQLException
EmbedStatement
executeStatement
in class EmbedPreparedStatement
java.sql.SQLException
- thrown on failure.public final void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.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.CallableStatement
java.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.CallableStatement
java.sql.SQLException
- if a database-access error occurs.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.wasNull()
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getString(int)
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getBoolean(int)
public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getByte(int)
public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getShort(int)
public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getInt(int)
public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getLong(int)
public final java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- 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.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getBigDecimal(int, int)
public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getFloat(int)
public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getDouble(int)
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.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.CallableStatement
java.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.CallableStatement
java.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.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getTimestamp(int)
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
parameterIndex
- 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.CallableStatement
parameterIndex
- 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.CallableStatement
parameterIndex
- 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.CallableStatement
java.sql.SQLException
- NoOutputParameters thrown.CallableStatement.getObject(int)
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
parameterIndex
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterIndex
- 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.CallableStatement
parameterIndex
- 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
EmbedPreparedStatement
addBatch
in interface java.sql.PreparedStatement
addBatch
in class EmbedPreparedStatement
java.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.CallableStatement
i
- 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.CallableStatement
i
- 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.CallableStatement
i
- 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterName
- - 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.CallableStatement
parameterIndex
- 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 CallableStatement
private 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.CallableStatement
java.sql.SQLException
public final java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
setRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
setNString
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.NClob getNClob(int i) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
setSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.SQLXML getSQLXML(java.lang.String parametername) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
parameterName
- 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.CallableStatement
parameterName
- 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.CallableStatement
parameterName
- 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.CallableStatement
getObject
in interface EngineCallableStatement
java.sql.SQLException
private java.sql.SQLException mismatchException(java.lang.String targetTypeName, int parameterIndex) throws java.sql.SQLException
java.sql.SQLException
public final <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
getObject
in interface EngineCallableStatement
java.sql.SQLException
Apache Derby V10.14 Internals - Copyright © 2004,2018 The Apache Software Foundation. All Rights Reserved.