Package org.apache.derby.impl.jdbc
Class EmbedCallableStatement
- java.lang.Object
-
- org.apache.derby.impl.jdbc.ConnectionChild
-
- org.apache.derby.impl.jdbc.EmbedStatement
-
- org.apache.derby.impl.jdbc.EmbedPreparedStatement
-
- org.apache.derby.impl.jdbc.EmbedCallableStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.CallableStatement
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
,EngineCallableStatement
,EnginePreparedStatement
,EngineStatement
- Direct Known Subclasses:
EmbedCallableStatement42
public class EmbedCallableStatement extends EmbedPreparedStatement implements EngineCallableStatement
Local implementation.
-
-
Field Summary
Fields Modifier and Type Field Description private boolean
hasReturnOutputParameter
protected boolean
wasNull
-
Fields inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement
preparedStatement, rMetaData
-
Fields inherited from class org.apache.derby.impl.jdbc.EmbedStatement
applicationStatement, batchStatements, isPoolable, lcc, MaxFieldSize, maxRows, results, resultSetConcurrency, resultSetType, SQLText, timeoutMillis, updateCount
-
Fields inherited from class org.apache.derby.impl.jdbc.ConnectionChild
factory, localConn
-
-
Constructor Summary
Constructors Constructor Description EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods 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 containsprivate 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 ajava.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 objectjava.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 objectjava.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 parameteri
.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 objectjava.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 objectjava.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 objectjava.net.URL
getURL(java.lang.String parameterName)
JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL objectprivate 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 objectvoid
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 objectvoid
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()
-
Methods inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement
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
-
Methods inherited from class org.apache.derby.impl.jdbc.EmbedStatement
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
-
Methods inherited from class org.apache.derby.impl.jdbc.ConnectionChild
commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, getLanguageConnectionContext, getLCC, handleException, needCommit, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack
-
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
-
Methods inherited from interface org.apache.derby.iapi.jdbc.EngineStatement
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRows
-
Methods inherited from interface java.sql.PreparedStatement
clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
-
Methods inherited from interface java.sql.Statement
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
-
-
-
-
Constructor Detail
-
EmbedCallableStatement
public EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
- Throws:
java.sql.SQLException
- thrown on failure
-
-
Method Detail
-
checkRequiresCallableStatement
protected void checkRequiresCallableStatement(Activation activation)
Description copied from class:EmbedStatement
Check to see if a statement requires to be executed via a callable statement.- Overrides:
checkRequiresCallableStatement
in classEmbedStatement
-
executeStatement
protected final boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws java.sql.SQLException
Description copied from class:EmbedStatement
Execute the current statement.- Overrides:
executeStatement
in classEmbedPreparedStatement
- Throws:
java.sql.SQLException
- thrown on failure.
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.registerOutParameter(int, int)
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.registerOutParameter(int, int)
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
wasNull
public boolean wasNull() throws java.sql.SQLException
- Specified by:
wasNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.wasNull()
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getString(int)
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getBoolean(int)
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getByte(int)
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getShort(int)
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getInt(int)
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getLong(int)
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value (full precision); if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
Deprecated.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getBigDecimal(int, int)
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getFloat(int)
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getDouble(int)
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getBytes(int)
-
getDate
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getDate(int)
-
getTime
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getTime(int)
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getTimestamp(int)
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
Get the value of a SQL DATE parameter as a java.sql.Date object- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
Get the value of a SQL TIME parameter as a java.sql.Time object.- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getObject
public final java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
- NoOutputParameters thrown.- See Also:
CallableStatement.getObject(int)
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- - the first parameter is 1, the second is 2- Returns:
- a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.net.URL object. The driver converts this to an SQL DATALINK value when it sends it to the database.- Specified by:
setURL
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterval
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getBlob
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
JDBC 2.0 Get a BLOB OUT parameter.- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- an object representing a BLOB
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getClob
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
JDBC 2.0 Get a CLOB OUT parameter.- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- an object representing a CLOB
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
addBatch
public void addBatch() throws java.sql.SQLException
Description copied from class:EmbedPreparedStatement
JDBC 2.0 Add a set of parameters to the batch.- Specified by:
addBatch
in interfacejava.sql.PreparedStatement
- Overrides:
addBatch
in classEmbedPreparedStatement
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getObject
public final java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
JDBC 2.0 Returns an object representing the value of OUT parameteri
. Use the map to determine the class from which to construct data of SQL structured and distinct types.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...map
- the mapping from SQL type names to Java classes- Returns:
- a java.lang.Object holding the OUT parameter value.
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getRef
public final java.sql.Ref getRef(int i) throws java.sql.SQLException
JDBC 2.0 Get a REF(<structured-type>) OUT parameter.- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...- Returns:
- an object representing data of an SQL REF Type
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
getArray
public final java.sql.Array getArray(int i) throws java.sql.SQLException
JDBC 2.0 Get an Array OUT parameter.- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...- Returns:
- an object representing an SQL array
- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
registerOutParameter
public final void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
JDBC 3.0 Registers the OUT parameter named parameterName to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
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.- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
registerOutParameter
public final void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
JDBC 3.0 Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-named or REF output parameter.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametersqlType
- - the SQL type code defined by java.sql.Types.typeName
- - the fully-qualified name of an SQL structure type- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
registerOutParameter
public final void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
JDBC 3.0 Registers the parameter named parameterName to the JDBC type sqlType. This method must be called before a stored procedure is executed.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
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.- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getRef
public final java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC REF (structured-type) parameter as a Ref object in the Java programming language.- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value as a Ref object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getBlob
public final java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value as a Blob object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getClob
public final java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value as a Clob object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getArray
public final java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value as a Array object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setNull
public final void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to SQL NULL.- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametersqlType
- - the SQL type code defined in java.sql.Types- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setNull
public final void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to SQL NULL.- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametersqlType
- - the SQL type code defined in java.sql.TypestypeName
- - the fully-qualified name of an SQL user-defined type- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setBoolean
public final void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT value when it sends it to the database.- Specified by:
setBoolean
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getBoolean
public final boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is false.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setByte
public final void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.- Specified by:
setByte
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getByte
public final byte getByte(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setShort
public final void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.- Specified by:
setShort
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getShort
public final short getShort(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setInt
public final void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.- Specified by:
setInt
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getInt
public final int getInt(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC INTEGER parameter as a int in the Java programming language.- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setLong
public final void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database.- Specified by:
setLong
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getLong
public final long getLong(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setFloat
public final void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java float value. The driver converts this to an SQL FLOAT value when it sends it to the database.- Specified by:
setFloat
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getFloat
public final float getFloat(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setDouble
public final void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.- Specified by:
setDouble
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getDouble
public final double getDouble(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setBigDecimal
public final void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.- Specified by:
setBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
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- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setString
public final void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java String value. The driver converts this to an SQL VARCHAR OR LONGVARCHAR value (depending on the argument's size relative the driver's limits on VARCHAR values) when it sends it to the database.- Specified by:
setString
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getString
public final java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.- Specified by:
getString
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setBytes
public final void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL VARBINARY OR LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values)when it sends it to the database.- Specified by:
setBytes
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getBytes
public final byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setDate
public final void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.sql.Date value. The driver converts this to an SQL DATE value when it sends it to the database.- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setDate
public final void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter valuecal
- - the Calendar object the driver will use to construct the date- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getDate
public final java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getDate
public final java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
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.- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametercal
- - the Calendar object the driver will use to construct the date- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setTime
public final void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database.- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getTime
public final java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getTime
public final java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
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.- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametercal
- - the Calendar object the driver will use to construct the time- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setTime
public final void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar object- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter valuecal
- - the Calendar object the driver will use to construct the time- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setTimestamp
public final void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setTimestamp
public final void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the parameter valuecal
- - the Calendar object the driver will use to construct the timestamp.- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getTimestamp
public final java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getTimestamp
public final java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
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.- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametercal
- - the Calendar object the driver will use to construct the Timestamp- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the Java input stream that contains the ASCII parameter valuelength
- - the number of bytes in the stream- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the Java input stream that contains the binary parameter valuelength
- - the number of bytes in the stream- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
JDBC 3.0 Sets the designated parameter to the given Reader object, which is the given number of characters long.- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterreader
- - the java.io.Reader object that contains the UNICODE datalength
- - the number of characters in the stream- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setObject
public final void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
JDBC 3.0 Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the java.lang equivalent objects should be used.- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Parameters:
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.- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getObject
public final java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
JDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameter- Returns:
- a java.lang.Object holding the OUT parameter value
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getObject
public final java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
JDBC 3.0 Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parametermap
- - the mapping from SQL type names to Java classes- Returns:
- a java.lang.Object holding the OUT parameter value
- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setObject
public final void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
JDBC 3.0 Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Parameters:
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.- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
setObject
public final void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
JDBC 3.0 Sets the value of the designated parameter with the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types.- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- - the name of the parameterx
- - the object containing the input parameter value- Throws:
java.sql.SQLException
- Feature not implemented for now.
-
getCharacterStream
public final java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated parameter as ajava.io.Reader
object in the Java programming language. Introduced in JDBC 4.0.- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...- Returns:
- a
java.io.Reader
object that contains the parameter value; if the value is SQLNULL
, the value returned isnull
in the Java programming language. - Throws:
java.sql.SQLException
- if a database access error occurs or this method is called on a closedCallableStatement
-
getBinaryStream
private java.io.InputStream getBinaryStream(int parameterIndex) throws java.sql.SQLException
Get binary stream for a parameter.- Parameters:
parameterIndex
- first parameter is 1, second is 2 etc.- Returns:
- a stream for the binary parameter, or
null
. - Throws:
java.sql.SQLException
- if a database access error occurs.
-
getCharacterStream
public final java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public final java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public final java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public final java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public final java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public final void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public final void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public final java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public final java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setRowId
public final void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
setRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNString
public final void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public final void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public final void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public final void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public final java.sql.NClob getNClob(int i) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public final java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setSQLXML
public final void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
setSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public final java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public final java.sql.SQLXML getSQLXML(java.lang.String parametername) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public final void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public final void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the first parameterx
- the java input stream which contains the ASCII parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- thrown on failure.
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the first parameterx
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- thrown on failure.
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLException
Sets the designated parameter to the given Reader, which will have the specified number of bytes.- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the first parameterx
- the java Reader which contains the UNICODE valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- thrown on failure.
-
getObject
public final <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Specified by:
getObject
in interfaceEngineCallableStatement
- Throws:
java.sql.SQLException
-
mismatchException
private java.sql.SQLException mismatchException(java.lang.String targetTypeName, int parameterIndex) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getObject
public final <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Specified by:
getObject
in interfaceEngineCallableStatement
- Throws:
java.sql.SQLException
-
-