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:

AutoCloseable, CallableStatement, PreparedStatement, Statement, 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 EmbedPreparedStatement

preparedStatement, rMetaData

Fields inherited from class EmbedStatement

applicationStatement, batchStatements, isPoolable, lcc, MaxFieldSize, maxRows, results, resultSetConcurrency, resultSetType, SQLText, timeoutMillis, updateCount

Fields inherited from class ConnectionChild

factory, localConn

Fields inherited from interface Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Constructor	Description
EmbedCallableStatement(EmbedConnection conn, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

Method Summary

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 final boolean	executeStatement(Activation a, boolean executeQuery, boolean executeUpdate)	Execute the current statement.
final Array	getArray(int i)	JDBC 2.0 Get an Array OUT parameter.
final Array	getArray(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
final BigDecimal	getBigDecimal(int parameterIndex)	JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
final BigDecimal	getBigDecimal(int parameterIndex, int scale)	Deprecated.
final BigDecimal	getBigDecimal(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 InputStream	getBinaryStream(int parameterIndex)	Get binary stream for a parameter.
Blob	getBlob(int parameterIndex)	JDBC 2.0 Get a BLOB OUT parameter.
final Blob	getBlob(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)
final boolean	getBoolean(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)
final byte	getByte(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)
final byte[]	getBytes(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.
final Reader	getCharacterStream(int parameterIndex)	Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
final Reader	getCharacterStream(String parameterName)
Clob	getClob(int parameterIndex)	JDBC 2.0 Get a CLOB OUT parameter.
final Clob	getClob(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
Date	getDate(int parameterIndex)	Get the value of a SQL DATE parameter as a java.sql.Date object
Date	getDate(int parameterIndex, Calendar cal)
final Date	getDate(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object
final Date	getDate(String parameterName, 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)
final double	getDouble(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)
final float	getFloat(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)
final int	getInt(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)
final long	getLong(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
final Reader	getNCharacterStream(int parameterIndex)
final Reader	getNCharacterStream(String parameterName)
final NClob	getNClob(int i)
final NClob	getNClob(String parameterName)
final String	getNString(int parameterIndex)
final String	getNString(String parameterName)
final Object	getObject(int parameterIndex)
final <T> T	getObject(int parameterIndex, Class<T> type)	/////////////////////////////////////////////////////////////////
final Object	getObject(int i, Map<String,Class<?>> map)	JDBC 2.0 Returns an object representing the value of OUT parameter i.
final Object	getObject(String parameterName)	JDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language.
final <T> T	getObject(String parameterName, Class<T> type)
final Object	getObject(String parameterName, Map<String,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.
final Ref	getRef(int i)	JDBC 2.0 Get a REF(<structured-type>) OUT parameter.
final Ref	getRef(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC REF (structured-type) parameter as a Ref object in the Java programming language.
final RowId	getRowId(int parameterIndex)
final RowId	getRowId(String parameterName)
short	getShort(int parameterIndex)
final short	getShort(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
final SQLXML	getSQLXML(int parameterIndex)
final SQLXML	getSQLXML(String parametername)
String	getString(int parameterIndex)
final String	getString(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
Time	getTime(int parameterIndex)	Get the value of a SQL TIME parameter as a java.sql.Time object.
Time	getTime(int parameterIndex, Calendar cal)
final Time	getTime(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object
final Time	getTime(String parameterName, 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.
Timestamp	getTimestamp(int parameterIndex)	Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
Timestamp	getTimestamp(int parameterIndex, Calendar cal)
final Timestamp	getTimestamp(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object
final Timestamp	getTimestamp(String parameterName, 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.
URL	getURL(int parameterIndex)	JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object
URL	getURL(String parameterName)	JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object
private SQLException	mismatchException(String targetTypeName, int parameterIndex)
final void	registerOutParameter(int parameterIndex, int sqlType)
final void	registerOutParameter(int parameterIndex, int sqlType, int scale)
void	registerOutParameter(int parameterIndex, int sqlType, String typeName)	JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.
final void	registerOutParameter(String parameterName, int sqlType)	JDBC 3.0 Registers the OUT parameter named parameterName to the JDBC type sqlType.
final void	registerOutParameter(String parameterName, int sqlType, int scale)	JDBC 3.0 Registers the parameter named parameterName to the JDBC type sqlType.
final void	registerOutParameter(String parameterName, int sqlType, String typeName)	JDBC 3.0 Registers the designated output parameter.
final void	setAsciiStream(String parameterName, InputStream x)
final void	setAsciiStream(String parameterName, InputStream x, int length)	JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.
final void	setAsciiStream(String parameterName, InputStream x, long length)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
final void	setBigDecimal(String parameterName, BigDecimal x)	JDBC 3.0 Sets the designated parameter to the given java.math.BigDecimal value.
final void	setBinaryStream(String parameterName, InputStream x)
final void	setBinaryStream(String parameterName, InputStream x, int length)	JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.
final void	setBinaryStream(String parameterName, InputStream x, long length)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
final void	setBlob(String parameterName, InputStream inputStream)
final void	setBlob(String parameterName, InputStream inputStream, long length)
final void	setBlob(String parameterName, Blob x)
final void	setBoolean(String parameterName, boolean x)	JDBC 3.0 Sets the designated parameter to the given Java boolean value.
final void	setByte(String parameterName, byte x)	JDBC 3.0 Sets the designated parameter to the given Java byte value.
final void	setBytes(String parameterName, byte[] x)	JDBC 3.0 Sets the designated parameter to the given Java array of bytes.
final void	setCharacterStream(String parameterName, Reader reader)
final void	setCharacterStream(String parameterName, Reader reader, int length)	JDBC 3.0 Sets the designated parameter to the given Reader object, which is the given number of characters long.
final void	setCharacterStream(String parameterName, Reader x, long length)	Sets the designated parameter to the given Reader, which will have the specified number of bytes.
final void	setClob(String parameterName, Reader reader)
final void	setClob(String parameterName, Reader reader, long length)
final void	setClob(String parameterName, Clob x)
final void	setDate(String parameterName, Date x)	JDBC 3.0 Sets the designated parameter to the given java.sql.Date value.
final void	setDate(String parameterName, Date x, Calendar cal)	JDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
final void	setDouble(String parameterName, double x)	JDBC 3.0 Sets the designated parameter to the given Java double value.
final void	setFloat(String parameterName, float x)	JDBC 3.0 Sets the designated parameter to the given Java float value.
final void	setInt(String parameterName, int x)	JDBC 3.0 Sets the designated parameter to the given Java int value.
final void	setLong(String parameterName, long x)	JDBC 3.0 Sets the designated parameter to the given Java long value.
final void	setNCharacterStream(String parameterName, Reader value)
final void	setNCharacterStream(String parameterName, Reader value, long length)
final void	setNClob(String parameterName, Reader reader)
final void	setNClob(String parameterName, Reader reader, long length)
final void	setNClob(String parameterName, NClob value)
final void	setNString(String parameterName, String value)
final void	setNull(String parameterName, int sqlType)	JDBC 3.0 Sets the designated parameter to SQL NULL.
final void	setNull(String parameterName, int sqlType, String typeName)	JDBC 3.0 Sets the designated parameter to SQL NULL.
final void	setObject(String parameterName, Object x)	JDBC 3.0 Sets the value of the designated parameter with the given object.
final void	setObject(String parameterName, Object x, int targetSqlType)	JDBC 3.0 Sets the value of the designated parameter with the given object.
final void	setObject(String parameterName, Object x, int targetSqlType, int scale)	JDBC 3.0 Sets the value of the designated parameter with the given object.
final void	setRowId(String parameterName, RowId x)
final void	setShort(String parameterName, short x)	JDBC 3.0 Sets the designated parameter to the given Java short value.
final void	setSQLXML(String parameterName, SQLXML xmlObject)
final void	setString(String parameterName, String x)	JDBC 3.0 Sets the designated parameter to the given Java String value.
final void	setTime(String parameterName, Time x)	JDBC 3.0 Sets the designated parameter to the given java.sql.Time value.
final void	setTime(String parameterName, Time x, Calendar cal)	JDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar object
final void	setTimestamp(String parameterName, Timestamp x)	JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value.
final void	setTimestamp(String parameterName, Timestamp x, Calendar cal)	JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object
void	setURL(String parameterName, URL val)	JDBC 3.0 Sets the designated parameter to the given java.net.URL object.
boolean	wasNull()

Methods inherited from class 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 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 ConnectionChild

commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, getLanguageConnectionContext, getLCC, handleException, needCommit, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack

Methods inherited from class Object

clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface CallableStatement

registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject

Methods inherited from interface EngineStatement

closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRows

Methods inherited from interface 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 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

Methods inherited from interface Wrapper

isWrapperFor, unwrap

Field Details

hasReturnOutputParameter

private boolean hasReturnOutputParameter

wasNull

protected boolean wasNull

Constructor Details

EmbedCallableStatement

public EmbedCallableStatement(EmbedConnection conn,
 String sql,
 int resultSetType,
 int resultSetConcurrency,
 int resultSetHoldability)
                       throws SQLException

Throws:

SQLException - thrown on failure

Method Details

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 class EmbedStatement

executeStatement

protected final boolean executeStatement(Activation a,
 boolean executeQuery,
 boolean executeUpdate)
                                  throws SQLException

Description copied from class: EmbedStatement

Execute the current statement.

Overrides:

executeStatement in class EmbedPreparedStatement

Throws:

SQLException - thrown on failure.

registerOutParameter

public final void registerOutParameter(int parameterIndex,
 int sqlType)
                                throws SQLException

Specified by:

registerOutParameter in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.registerOutParameter(int, int)

registerOutParameter

public final void registerOutParameter(int parameterIndex,
 int sqlType,
 int scale)
                                throws SQLException

Specified by:

registerOutParameter in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.registerOutParameter(int, int)

registerOutParameter

public void registerOutParameter(int parameterIndex,
 int sqlType,
 String typeName)
                          throws SQLException

JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.

Specified by:

registerOutParameter in interface CallableStatement

Throws:

SQLException - if a database-access error occurs.

wasNull

public boolean wasNull()
                throws SQLException

Specified by:

wasNull in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.wasNull()

getString

public String getString(int parameterIndex)
                 throws SQLException

Specified by:

getString in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getString(int)

getBoolean

public boolean getBoolean(int parameterIndex)
                   throws SQLException

Specified by:

getBoolean in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getBoolean(int)

getByte

public byte getByte(int parameterIndex)
             throws SQLException

Specified by:

getByte in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getByte(int)

getShort

public short getShort(int parameterIndex)
               throws SQLException

Specified by:

getShort in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getShort(int)

getInt

public int getInt(int parameterIndex)
           throws SQLException

Specified by:

getInt in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getInt(int)

getLong

public long getLong(int parameterIndex)
             throws SQLException

Specified by:

getLong in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getLong(int)

getBigDecimal

public final BigDecimal getBigDecimal(int parameterIndex)
                               throws SQLException

JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.

Specified by:

getBigDecimal in interface 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:

SQLException - if a database-access error occurs.

getBigDecimal

public final BigDecimal getBigDecimal(int parameterIndex,
 int scale)
                               throws SQLException

Deprecated.

Specified by:

getBigDecimal in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getBigDecimal(int, int)

getFloat

public float getFloat(int parameterIndex)
               throws SQLException

Specified by:

getFloat in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getFloat(int)

getDouble

public double getDouble(int parameterIndex)
                 throws SQLException

Specified by:

getDouble in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getDouble(int)

getBytes

public byte[] getBytes(int parameterIndex)
                throws SQLException

Specified by:

getBytes in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getBytes(int)

getDate

public Date getDate(int parameterIndex,
 Calendar cal)
             throws SQLException

Specified by:

getDate in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getDate(int)

getTime

public Time getTime(int parameterIndex,
 Calendar cal)
             throws SQLException

Specified by:

getTime in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getTime(int)

getTimestamp

public Timestamp getTimestamp(int parameterIndex,
 Calendar cal)
                       throws SQLException

Specified by:

getTimestamp in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getTimestamp(int)

getDate

public Date getDate(int parameterIndex)
             throws SQLException

Get the value of a SQL DATE parameter as a java.sql.Date object

Specified by:

getDate in interface 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:

SQLException - if a database-access error occurs.

getTime

public Time getTime(int parameterIndex)
             throws SQLException

Get the value of a SQL TIME parameter as a java.sql.Time object.

Specified by:

getTime in interface 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:

SQLException - if a database-access error occurs.

getTimestamp

public Timestamp getTimestamp(int parameterIndex)
                       throws SQLException

Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.

Specified by:

getTimestamp in interface 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:

SQLException - if a database-access error occurs.

getObject

public final Object getObject(int parameterIndex)
                       throws SQLException

Specified by:

getObject in interface CallableStatement

Throws:

SQLException - NoOutputParameters thrown.

See Also:

• CallableStatement.getObject(int)

getURL

public URL getURL(int parameterIndex)
           throws SQLException

JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object

Specified by:

getURL in interface 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:

SQLException - Feature not implemented for now.

setURL

public void setURL(String parameterName,
 URL val)
            throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

val - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getURL

public URL getURL(String parameterName)
           throws SQLException

JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object

Specified by:

getURL in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is null.

Throws:

SQLException - Feature not implemented for now.

getBlob

public Blob getBlob(int parameterIndex)
             throws SQLException

JDBC 2.0 Get a BLOB OUT parameter.

Specified by:

getBlob in interface CallableStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

Returns:

an object representing a BLOB

Throws:

SQLException - if a database-access error occurs.

getClob

public Clob getClob(int parameterIndex)
             throws SQLException

JDBC 2.0 Get a CLOB OUT parameter.

Specified by:

getClob in interface CallableStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

Returns:

an object representing a CLOB

Throws:

SQLException - if a database-access error occurs.

addBatch

public void addBatch()
              throws SQLException

Description copied from class: EmbedPreparedStatement

JDBC 2.0 Add a set of parameters to the batch.

Specified by:

addBatch in interface PreparedStatement

Overrides:

addBatch in class EmbedPreparedStatement

Throws:

SQLException - if a database-access error occurs.

getObject

public final Object getObject(int i,
 Map<String,Class<?>> map)
                       throws SQLException

JDBC 2.0 Returns an object representing the value of OUT parameter i. Use the map to determine the class from which to construct data of SQL structured and distinct types.

Specified by:

getObject in interface 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:

SQLException - if a database-access error occurs.

getRef

public final Ref getRef(int i)
                 throws SQLException

JDBC 2.0 Get a REF(<structured-type>) OUT parameter.

Specified by:

getRef in interface CallableStatement

Parameters:

i - the first parameter is 1, the second is 2, ...

Returns:

an object representing data of an SQL REF Type

Throws:

SQLException - if a database-access error occurs.

getArray

public final Array getArray(int i)
                     throws SQLException

JDBC 2.0 Get an Array OUT parameter.

Specified by:

getArray in interface CallableStatement

Parameters:

i - the first parameter is 1, the second is 2, ...

Returns:

an object representing an SQL array

Throws:

SQLException - if a database-access error occurs.

registerOutParameter

public final void registerOutParameter(String parameterName,
 int sqlType)
                                throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

sqlType - - 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:

SQLException - Feature not implemented for now.

registerOutParameter

public final void registerOutParameter(String parameterName,
 int sqlType,
 String typeName)
                                throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

sqlType - - the SQL type code defined by java.sql.Types.

typeName - - the fully-qualified name of an SQL structure type

Throws:

SQLException - Feature not implemented for now.

registerOutParameter

public final void registerOutParameter(String parameterName,
 int sqlType,
 int scale)
                                throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

sqlType - - 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:

SQLException - Feature not implemented for now.

getRef

public final Ref getRef(String parameterName)
                 throws 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 interface 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:

SQLException - Feature not implemented for now.

getBlob

public final Blob getBlob(String parameterName)
                   throws 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 interface 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:

SQLException - Feature not implemented for now.

getClob

public final Clob getClob(String parameterName)
                   throws 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 interface 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:

SQLException - Feature not implemented for now.

getArray

public final Array getArray(String parameterName)
                     throws 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 interface 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:

SQLException - Feature not implemented for now.

setNull

public final void setNull(String parameterName,
 int sqlType)
                   throws SQLException

JDBC 3.0 Sets the designated parameter to SQL NULL.

Specified by:

setNull in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

sqlType - - the SQL type code defined in java.sql.Types

Throws:

SQLException - Feature not implemented for now.

setNull

public final void setNull(String parameterName,
 int sqlType,
 String typeName)
                   throws SQLException

JDBC 3.0 Sets the designated parameter to SQL NULL.

Specified by:

setNull in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

sqlType - - the SQL type code defined in java.sql.Types

typeName - - the fully-qualified name of an SQL user-defined type

Throws:

SQLException - Feature not implemented for now.

setBoolean

public final void setBoolean(String parameterName,
 boolean x)
                      throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getBoolean

public final boolean getBoolean(String parameterName)
                         throws SQLException

JDBC 3.0 Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.

Specified by:

getBoolean in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is false.

Throws:

SQLException - Feature not implemented for now.

setByte

public final void setByte(String parameterName,
 byte x)
                   throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getByte

public final byte getByte(String parameterName)
                   throws SQLException

JDBC 3.0 Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

Specified by:

getByte in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setShort

public final void setShort(String parameterName,
 short x)
                    throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getShort

public final short getShort(String parameterName)
                     throws SQLException

JDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

Specified by:

getShort in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setInt

public final void setInt(String parameterName,
 int x)
                  throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getInt

public final int getInt(String parameterName)
                 throws SQLException

JDBC 3.0 Retrieves the value of a JDBC INTEGER parameter as a int in the Java programming language.

Specified by:

getInt in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setLong

public final void setLong(String parameterName,
 long x)
                   throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getLong

public final long getLong(String parameterName)
                   throws SQLException

JDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

Specified by:

getLong in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setFloat

public final void setFloat(String parameterName,
 float x)
                    throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getFloat

public final float getFloat(String parameterName)
                     throws SQLException

JDBC 3.0 Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

Specified by:

getFloat in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setDouble

public final void setDouble(String parameterName,
 double x)
                     throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getDouble

public final double getDouble(String parameterName)
                       throws SQLException

JDBC 3.0 Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

Specified by:

getDouble in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setBigDecimal

public final void setBigDecimal(String parameterName,
 BigDecimal x)
                         throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getBigDecimal

public final BigDecimal getBigDecimal(String parameterName)
                               throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is 0.

Throws:

SQLException - Feature not implemented for now.

setString

public final void setString(String parameterName,
 String x)
                     throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getString

public final String getString(String parameterName)
                       throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is null.

Throws:

SQLException - Feature not implemented for now.

setBytes

public final void setBytes(String parameterName,
 byte[] x)
                    throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getBytes

public final byte[] getBytes(String parameterName)
                      throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is null.

Throws:

SQLException - Feature not implemented for now.

setDate

public final void setDate(String parameterName,
 Date x)
                   throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

setDate

public final void setDate(String parameterName,
 Date x,
 Calendar cal)
                   throws SQLException

JDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

Specified by:

setDate in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

cal - - the Calendar object the driver will use to construct the date

Throws:

SQLException - Feature not implemented for now.

getDate

public final Date getDate(String parameterName)
                   throws SQLException

JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object

Specified by:

getDate in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is null.

Throws:

SQLException - Feature not implemented for now.

getDate

public final Date getDate(String parameterName,
 Calendar cal)
                   throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

cal - - 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:

SQLException - Feature not implemented for now.

setTime

public final void setTime(String parameterName,
 Time x)
                   throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

getTime

public final Time getTime(String parameterName)
                   throws SQLException

JDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object

Specified by:

getTime in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is null.

Throws:

SQLException - Feature not implemented for now.

getTime

public final Time getTime(String parameterName,
 Calendar cal)
                   throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

cal - - 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:

SQLException - Feature not implemented for now.

setTime

public final void setTime(String parameterName,
 Time x,
 Calendar cal)
                   throws SQLException

JDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar object

Specified by:

setTime in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

cal - - the Calendar object the driver will use to construct the time

Throws:

SQLException - Feature not implemented for now.

setTimestamp

public final void setTimestamp(String parameterName,
 Timestamp x)
                        throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

Throws:

SQLException - Feature not implemented for now.

setTimestamp

public final void setTimestamp(String parameterName,
 Timestamp x,
 Calendar cal)
                        throws SQLException

JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object

Specified by:

setTimestamp in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the parameter value

cal - - the Calendar object the driver will use to construct the timestamp.

Throws:

SQLException - Feature not implemented for now.

getTimestamp

public final Timestamp getTimestamp(String parameterName)
                             throws SQLException

JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object

Specified by:

getTimestamp in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

the parameter value. If the value is SQL NULL, the result is null.

Throws:

SQLException - Feature not implemented for now.

getTimestamp

public final Timestamp getTimestamp(String parameterName,
 Calendar cal)
                             throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

cal - - 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:

SQLException - Feature not implemented for now.

setAsciiStream

public final void setAsciiStream(String parameterName,
 InputStream x,
 int length)
                          throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the Java input stream that contains the ASCII parameter value

length - - the number of bytes in the stream

Throws:

SQLException - Feature not implemented for now.

setBinaryStream

public final void setBinaryStream(String parameterName,
 InputStream x,
 int length)
                           throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the Java input stream that contains the binary parameter value

length - - the number of bytes in the stream

Throws:

SQLException - Feature not implemented for now.

setCharacterStream

public final void setCharacterStream(String parameterName,
 Reader reader,
 int length)
                              throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

reader - - the java.io.Reader object that contains the UNICODE data

length - - the number of characters in the stream

Throws:

SQLException - Feature not implemented for now.

setObject

public final void setObject(String parameterName,
 Object x,
 int targetSqlType,
 int scale)
                     throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the object containing the input parameter value

targetSqlType - - 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:

SQLException - Feature not implemented for now.

getObject

public final Object getObject(String parameterName)
                       throws SQLException

JDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language.

Specified by:

getObject in interface CallableStatement

Parameters:

parameterName - - the name of the parameter

Returns:

a java.lang.Object holding the OUT parameter value

Throws:

SQLException - Feature not implemented for now.

getObject

public final Object getObject(String parameterName,
 Map<String,Class<?>> map)
                       throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

map - - the mapping from SQL type names to Java classes

Returns:

a java.lang.Object holding the OUT parameter value

Throws:

SQLException - Feature not implemented for now.

setObject

public final void setObject(String parameterName,
 Object x,
 int targetSqlType)
                     throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the object containing the input parameter value

targetSqlType - - the SQL type (as defined in java.sql.Types) to be sent to the database.

Throws:

SQLException - Feature not implemented for now.

setObject

public final void setObject(String parameterName,
 Object x)
                     throws 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 interface CallableStatement

Parameters:

parameterName - - the name of the parameter

x - - the object containing the input parameter value

Throws:

SQLException - Feature not implemented for now.

getCharacterStream

public final Reader getCharacterStream(int parameterIndex)
                                throws SQLException

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language. Introduced in JDBC 4.0.

Specified by:

getCharacterStream in interface 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 SQL NULL, the value returned is null in the Java programming language.

Throws:

SQLException - if a database access error occurs or this method is called on a closed CallableStatement

getBinaryStream

private InputStream getBinaryStream(int parameterIndex)
                             throws 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:

SQLException - if a database access error occurs.

getCharacterStream

public final Reader getCharacterStream(String parameterName)
                                throws SQLException

Specified by:

getCharacterStream in interface CallableStatement

Throws:

SQLException

getNCharacterStream

public final Reader getNCharacterStream(int parameterIndex)
                                 throws SQLException

Specified by:

getNCharacterStream in interface CallableStatement

Throws:

SQLException

getNCharacterStream

public final Reader getNCharacterStream(String parameterName)
                                 throws SQLException

Specified by:

getNCharacterStream in interface CallableStatement

Throws:

SQLException

getNString

public final String getNString(int parameterIndex)
                        throws SQLException

Specified by:

getNString in interface CallableStatement

Throws:

SQLException

getNString

public final String getNString(String parameterName)
                        throws SQLException

Specified by:

getNString in interface CallableStatement

Throws:

SQLException

setBlob

public final void setBlob(String parameterName,
 Blob x)
                   throws SQLException

Specified by:

setBlob in interface CallableStatement

Throws:

SQLException

setClob

public final void setClob(String parameterName,
 Clob x)
                   throws SQLException

Specified by:

setClob in interface CallableStatement

Throws:

SQLException

getRowId

public final RowId getRowId(int parameterIndex)
                     throws SQLException

Specified by:

getRowId in interface CallableStatement

Throws:

SQLException

getRowId

public final RowId getRowId(String parameterName)
                     throws SQLException

Specified by:

getRowId in interface CallableStatement

Throws:

SQLException

setRowId

public final void setRowId(String parameterName,
 RowId x)
                    throws SQLException

Specified by:

setRowId in interface CallableStatement

Throws:

SQLException

setNString

public final void setNString(String parameterName,
 String value)
                      throws SQLException

Specified by:

setNString in interface CallableStatement

Throws:

SQLException

setNCharacterStream

public final void setNCharacterStream(String parameterName,
 Reader value,
 long length)
                               throws SQLException

Specified by:

setNCharacterStream in interface CallableStatement

Throws:

SQLException

setNClob

public final void setNClob(String parameterName,
 NClob value)
                    throws SQLException

Specified by:

setNClob in interface CallableStatement

Throws:

SQLException

setClob

public final void setClob(String parameterName,
 Reader reader,
 long length)
                   throws SQLException

Specified by:

setClob in interface CallableStatement

Throws:

SQLException

setBlob

public final void setBlob(String parameterName,
 InputStream inputStream,
 long length)
                   throws SQLException

Specified by:

setBlob in interface CallableStatement

Throws:

SQLException

setNClob

public final void setNClob(String parameterName,
 Reader reader,
 long length)
                    throws SQLException

Specified by:

setNClob in interface CallableStatement

Throws:

SQLException

getNClob

public final NClob getNClob(int i)
                     throws SQLException

Specified by:

getNClob in interface CallableStatement

Throws:

SQLException

getNClob

public final NClob getNClob(String parameterName)
                     throws SQLException

Specified by:

getNClob in interface CallableStatement

Throws:

SQLException

setSQLXML

public final void setSQLXML(String parameterName,
 SQLXML xmlObject)
                     throws SQLException

Specified by:

setSQLXML in interface CallableStatement

Throws:

SQLException

getSQLXML

public final SQLXML getSQLXML(int parameterIndex)
                       throws SQLException

Specified by:

getSQLXML in interface CallableStatement

Throws:

SQLException

getSQLXML

public final SQLXML getSQLXML(String parametername)
                       throws SQLException

Specified by:

getSQLXML in interface CallableStatement

Throws:

SQLException

setAsciiStream

public final void setAsciiStream(String parameterName,
 InputStream x)
                          throws SQLException

Specified by:

setAsciiStream in interface CallableStatement

Throws:

SQLException

setBinaryStream

public final void setBinaryStream(String parameterName,
 InputStream x)
                           throws SQLException

Specified by:

setBinaryStream in interface CallableStatement

Throws:

SQLException

setBlob

public final void setBlob(String parameterName,
 InputStream inputStream)
                   throws SQLException

Specified by:

setBlob in interface CallableStatement

Throws:

SQLException

setCharacterStream

public final void setCharacterStream(String parameterName,
 Reader reader)
                              throws SQLException

Specified by:

setCharacterStream in interface CallableStatement

Throws:

SQLException

setClob

public final void setClob(String parameterName,
 Reader reader)
                   throws SQLException

Specified by:

setClob in interface CallableStatement

Throws:

SQLException

setNCharacterStream

public final void setNCharacterStream(String parameterName,
 Reader value)
                               throws SQLException

Specified by:

setNCharacterStream in interface CallableStatement

Throws:

SQLException

setNClob

public final void setNClob(String parameterName,
 Reader reader)
                    throws SQLException

Specified by:

setNClob in interface CallableStatement

Throws:

SQLException

setAsciiStream

public final void setAsciiStream(String parameterName,
 InputStream x,
 long length)
                          throws SQLException

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Specified by:

setAsciiStream in interface CallableStatement

Parameters:

parameterName - the name of the first parameter

x - the java input stream which contains the ASCII parameter value

length - the number of bytes in the stream

Throws:

SQLException - thrown on failure.

setBinaryStream

public final void setBinaryStream(String parameterName,
 InputStream x,
 long length)
                           throws SQLException

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Specified by:

setBinaryStream in interface CallableStatement

Parameters:

parameterName - the name of the first parameter

x - the java input stream which contains the binary parameter value

length - the number of bytes in the stream

Throws:

SQLException - thrown on failure.

setCharacterStream

public final void setCharacterStream(String parameterName,
 Reader x,
 long length)
                              throws SQLException

Sets the designated parameter to the given Reader, which will have the specified number of bytes.

Specified by:

setCharacterStream in interface CallableStatement

Parameters:

parameterName - the name of the first parameter

x - the java Reader which contains the UNICODE value

length - the number of bytes in the stream

Throws:

SQLException - thrown on failure.

getObject

public final <T> T getObject(int parameterIndex,
 Class<T> type)
                      throws SQLException

/////////////////////////////////////////////////////////////////

Specified by:

getObject in interface CallableStatement

Specified by:

getObject in interface EngineCallableStatement

Throws:

SQLException

mismatchException

private SQLException mismatchException(String targetTypeName,
 int parameterIndex)
                                throws SQLException

Throws:

SQLException

getObject

public final <T> T getObject(String parameterName,
 Class<T> type)
                      throws SQLException

Specified by:

getObject in interface CallableStatement

Specified by:

getObject in interface EngineCallableStatement

Throws:

SQLException