Top Fields Constructors Methods
org.apache.derby.client.am

public Class ClientCallableStatement

extends ClientPreparedStatement
implements PreparedStatement, CallableStatement, PreparedStatementCallbackInterface
Class Inheritance
All Implemented Interfaces
org.apache.derby.client.am.PreparedStatementCallbackInterface, org.apache.derby.client.am.StatementCallbackInterface, org.apache.derby.client.am.UnitOfWorkListener, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.lang.AutoCloseable, java.sql.Wrapper
Known Direct Subclasses
org.apache.derby.client.am.ClientCallableStatement42
Imports
java.io.InputStream, .Reader, org.apache.derby.client.ClientPooledConnection, org.apache.derby.shared.common.reference.SQLState, java.math.BigDecimal, java.net.URL, java.sql.Array, .Blob, .CallableStatement, .Clob, .Date, .NClob, .PreparedStatement, .Ref, .RowId, .SQLException, .SQLXML, .Time, .Timestamp, java.util.Calendar, .Map

Field Summary

Modifier and TypeField and Description
public MaterialPreparedStatement
private static final int
private static final int
private static final int
private int
Inherited from org.apache.derby.client.am.ClientPreparedStatement:
materialPreparedStatement_outputRegistered_parameterMetaData_parameterRegistered_parameters_sql_

Constructor Summary

AccessConstructor and Description
public
ClientCallableStatement(Agent
The instance of NetAgent associated with this CallableStatement object.
agent
,
ClientConnection
The connection object associated with this PreparedStatement Object.
connection
,
String
A String object that is the SQL statement to be sent to the database.
sql
,
int
One of the ResultSet type constants
type
,
int
One of the ResultSet concurrency constants
concurrency
,
int
One of the ResultSet holdability constants
holdability
,
ClientPooledConnection
The PooledConnection object that will be used to notify the PooledConnection reference of the Error Occurred and the Close events.
cpc
)

Common constructor for jdbc 2 callable statements with scroll attributes.

Method Summary

Modifier and TypeMethod and Description
private void
checkForValidOutParameter(int parameterIndex)

private void
checkGetterPreconditions(int parameterIndex)

public void
public void
protected void
finalize()

Overrides org.apache.derby.client.am.ClientStatement.finalize.

Called by the garbage collector on an object when garbage collection determines that there are no more references to the object.
public Array
getArray(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of the designated JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.
public Array
getArray(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of a JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.
public BigDecimal
getBigDecimal(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.CallableStatement.getBigDecimal.

Deprecated
Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point.
public BigDecimal
getBigDecimal(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.
public BigDecimal
getBigDecimal(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getBigDecimal.

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.
public Blob
getBlob(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of the designated JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.
public Blob
getBlob(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of a JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.
public boolean
getBoolean(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
public boolean
getBoolean(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of a JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
public byte
getByte(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
public byte
getByte(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
public byte[]
getBytes(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
public byte[]
getBytes(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
pack-priv byte[]
getBytesX(final int parameterIndex)

public Reader
getCharacterStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public Reader
getCharacterStream(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public Clob
getClob(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
public Clob
getClob(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
public Date
getDate(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
Calendar
the Calendar object the driver will use to construct the date
cal
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
public Date
getDate(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.
public Date
getDate(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
public Date
getDate(String
the name of the parameter
parameterName
,
Calendar
the Calendar object the driver will use to construct the date
calendar
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
public double
getDouble(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
public double
getDouble(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
public float
getFloat(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
public float
getFloat(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
public int
getInt(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
public int
getInt(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
pack-priv int
getIntX(int parameterIndex)

protected String

Returns:

name of java.sql interface
getJdbcStatementInterfaceName
()

Overrides org.apache.derby.client.am.ClientPreparedStatement.getJdbcStatementInterfaceName.

Returns the name of the java.sql interface implemented by this class.
public long
getLong(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
public long
getLong(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
pack-priv long
getLongX(int parameterIndex)

public Reader
getNCharacterStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public Reader
getNCharacterStream(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public NClob
getNClob(int
the first parameter is 1, the second is 2, and so on
i
)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
public NClob
getNClob(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
public String
getNString(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
public String
getNString(String
the name of the parameter
parameterIndex
)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
public Object
getObject(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of the designated parameter as an Object in the Java programming language.
public Object
getObject(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
Map<K, V>
the mapping from SQL type names to Java classes
map
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.
public Object
getObject(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of a parameter as an Object in the Java programming language.
public Object
getObject(String
the name of the parameter
parameterName
,
Map<K, V>
the mapping from SQL type names to Java classes
map
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.
public <T> T
getObject(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
Class<T>
Class representing the Java data type to convert the designated parameter to.
type
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
public <T> T
getObject(String
the name of the parameter
parameterName
,
Class<T>
Class representing the Java data type to convert the designated parameter to.
type
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
public Ref
getRef(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.
public Ref
getRef(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of a JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.
public RowId
getRowId(int
the first parameter is 1, the second is 2,...
parameterIndex
)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
public RowId
getRowId(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
public short
getShort(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
public short
getShort(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
public SQLXML
getSQLXML(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
public SQLXML
getSQLXML(String
the name of the parameter
parametername
)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
public String
getString(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getString.

Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
public String
getString(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getString.

Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
pack-priv String
getStringX(int parameterIndex)

public Time
getTime(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
Calendar
the Calendar object the driver will use to construct the time
cal
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
public Time
getTime(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.
public Time
getTime(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
public Time
getTime(String
the name of the parameter
parameterName
,
Calendar
the Calendar object the driver will use to construct the time
calendar
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
public Timestamp
getTimestamp(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
Calendar
the Calendar object the driver will use to construct the timestamp
cal
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
public Timestamp
getTimestamp(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
public Timestamp
getTimestamp(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
public Timestamp
getTimestamp(String
the name of the parameter
parameterName
,
Calendar
the Calendar object the driver will use to construct the timestamp
calendar
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
public URL
getURL(int
the first parameter is 1, the second is 2,...
parameterIndex
)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
public URL
getURL(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
private void
pack-priv SQLException
private SQLException
mismatchException(String targetTypeName, int parameterIndex)

public void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
int
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.
jdbcType
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
public void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
int
the SQL type code defined by java.sql.Types.
jdbcType
,
int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
scale
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
public void
registerOutParameter(int
the first parameter is 1, the second is 2,...
parameterIndex
,
int
a value from java.sql.Types
jdbcType
,
String
the fully-qualified name of an SQL structured type
typeName
)

Implements java.sql.CallableStatement.registerOutParameter.

Derby ignores the typeName argument because UDTs don't need it
public void
registerOutParameter(String
the name of the parameter
parameterName
,
int
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.
sqlType
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter named parameterName to the JDBC type sqlType.
public void
registerOutParameter(String
the name of the parameter
parameterName
,
int
SQL type code defined by java.sql.Types.
sqlType
,
int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
scale
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter named parameterName to be of JDBC type sqlType.
public void
registerOutParameter(String
the name of the parameter
parameterName
,
int
a value from java.sql.Types
sqlType
,
String
the fully-qualified name of an SQL structured type
typeName
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.
pack-priv void
registerOutParameterX(int parameterIndex, int jdbcType)

private void
registerOutParameterX(int parameterIndex, int jdbcType, int scale)

public void
public void
resetCallableStatement(Agent agent, ClientConnection connection, String sql, int type, int concurrency, int holdability)

public void
setAsciiStream(String
the name of the parameter
parameterName
,
InputStream
the Java input stream that contains the ASCII parameter value
x
,
int
the number of bytes in the stream
length
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void
setAsciiStream(String
the name of the parameter
parameterName
,
InputStream
the Java input stream that contains the ASCII parameter value
x
,
long
the number of bytes in the stream
length
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void
setAsciiStream(String
the name of the parameter
parameterName
,
InputStream
the Java input stream that contains the ASCII parameter value
x
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream.
public void
setBigDecimal(String
the name of the parameter
parameterName
,
BigDecimal
the parameter value
x
)

Implements java.sql.CallableStatement.setBigDecimal.

Sets the designated parameter to the given java.math.BigDecimal value.
public void
setBinaryStream(String
the name of the parameter
parameterName
,
InputStream
the java input stream which contains the binary parameter value
x
,
int
the number of bytes in the stream
length
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public final void
setBinaryStream(String
the name of the parameter
parameterName
,
InputStream
the java input stream which contains the binary parameter value
x
,
long
the number of bytes in the stream
length
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void
setBinaryStream(String
the name of the parameter
parameterName
,
InputStream
the java input stream which contains the binary parameter value
x
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream.
public void
setBlob(String
the name of the parameter
parameterName
,
Blob
a Blob object that maps an SQL BLOB value
x
)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to the given java.sql.Blob object.
public void
setBlob(String
the name of the parameter to be set the second is 2, ...
parameterName
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.
public void
setBlob(String
the name of the parameter
parameterName
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.
public void
setBoolean(String
the name of the parameter
parameterName
,
boolean
the parameter value
x
)

Implements java.sql.CallableStatement.setBoolean.

Sets the designated parameter to the given Java boolean value.
public void
setByte(String
the name of the parameter
parameterName
,
byte
the parameter value
x
)

Implements java.sql.CallableStatement.setByte.

Sets the designated parameter to the given Java byte value.
public void
setBytes(String
the name of the parameter
parameterName
,
byte[]
the parameter value
x
)

Implements java.sql.CallableStatement.setBytes.

Sets the designated parameter to the given Java array of bytes.
public void
setCharacterStream(String
the name of the parameter
parameterName
,
Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
reader
,
int
the number of characters in the stream
length
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.
public final void
setCharacterStream(String
the name of the parameter
parameterName
,
Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
x
,
long
the number of characters in the stream
length
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.
public void
setCharacterStream(String
the name of the parameter
parameterName
,
Reader
the java.io.Reader object that contains the Unicode data
reader
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object.
public void
setClob(String
the name of the parameter
parameterName
,
Clob
a Clob object that maps an SQL CLOB value
x
)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to the given java.sql.Clob object.
public void
setClob(String
the name of the parameter to be set
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.
public void
setClob(String
the name of the parameter
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.
public void
setDate(String
the name of the parameter
parameterName
,
Date
the parameter value
x
)

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
public void
setDate(String
the name of the parameter
parameterName
,
Date
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the date
calendar
)

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
public void
setDouble(String
the name of the parameter
parameterName
,
double
the parameter value
x
)

Implements java.sql.CallableStatement.setDouble.

Sets the designated parameter to the given Java double value.
public void
setFloat(String
the name of the parameter
parameterName
,
float
the parameter value
x
)

Implements java.sql.CallableStatement.setFloat.

Sets the designated parameter to the given Java float value.
public void
setInt(String
the name of the parameter
parameterName
,
int
the parameter value
x
)

Implements java.sql.CallableStatement.setInt.

Sets the designated parameter to the given Java int value.
public void
setLong(String
the name of the parameter
parameterName
,
long
the parameter value
x
)

Implements java.sql.CallableStatement.setLong.

Sets the designated parameter to the given Java long value.
public void
setNCharacterStream(String
the name of the parameter to be set
parameterName
,
Reader
the parameter value
value
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.
public void
setNCharacterStream(String
the name of the parameter
parameterName
,
Reader
the parameter value
value
)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.
public void
setNClob(String
the name of the parameter to be set
parameterName
,
NClob
the parameter value
value
)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a java.sql.NClob object.
public void
setNClob(String
the name of the parameter to be set
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.
public void
setNClob(String
the name of the parameter
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.
public void
setNString(String
the name of the parameter to be set
parameterName
,
String
the parameter value
value
)

Implements java.sql.CallableStatement.setNString.

Sets the designated parameter to the given String object.
public void
setNull(String
the name of the parameter
parameterName
,
int
the SQL type code defined in java.sql.Types
sqlType
)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.
public void
setNull(String
the name of the parameter
parameterName
,
int
a value from java.sql.Types
sqlType
,
String
the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value
typeName
)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.
public void
setObject(String
the name of the parameter
parameterName
,
Object
the object containing the input parameter value
x
,
int
the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
targetSqlType
,
int
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.
scale
)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.
public void
setObject(String
the name of the parameter
parameterName
,
Object
the object containing the input parameter value
x
,
int
the SQL type (as defined in java.sql.Types) to be sent to the database
targetSqlType
)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.
public void
setObject(String
the name of the parameter
parameterName
,
Object
the object containing the input parameter value
x
)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.
public void
setRowId(String
the name of the parameter
parameterName
,
RowId
the parameter value
x
)

Implements java.sql.CallableStatement.setRowId.

Sets the designated parameter to the given java.sql.RowId object.
public void
setShort(String
the name of the parameter
parameterName
,
short
the parameter value
x
)

Implements java.sql.CallableStatement.setShort.

Sets the designated parameter to the given Java short value.
public void
setSQLXML(String
the name of the parameter
parameterName
,
SQLXML
a SQLXML object that maps an SQL XML value
xmlObject
)

Implements java.sql.CallableStatement.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.
public void
setString(String
the name of the parameter
parameterName
,
String
the parameter value
x
)

Implements java.sql.CallableStatement.setString.

Sets the designated parameter to the given Java String value.
public void
setTime(String
the name of the parameter
parameterName
,
Time
the parameter value
x
)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value.
public void
setTime(String
the name of the parameter
parameterName
,
Time
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the time
calendar
)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
public void
setTimestamp(String
the name of the parameter
parameterName
,
Timestamp
the parameter value
x
)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value.
public void
setTimestamp(String
the name of the parameter
parameterName
,
Timestamp
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the timestamp
calendar
)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
public void
setURL(String
the name of the parameter
parameterName
,
URL
the parameter value
x
)

Implements java.sql.CallableStatement.setURL.

Sets the designated parameter to the given java.net.URL object.
private void
setWasNull(int parameterIndex)

public boolean
wasNull()

Implements java.sql.CallableStatement.wasNull.

Retrieves whether the last OUT parameter read had the value of SQL NULL.
private boolean
Inherited from org.apache.derby.client.am.ClientPreparedStatement:
addBatchaddBatchcheckForValidParameterIndexcheckForValidScalecheckStatuscompleteDescribeInputcompleteDescribeOutputcompleteLocalCommitcompleteLocalRollbackexecuteexecuteexecuteexecuteexecuteexecuteBatchexecuteLargeUpdateexecuteQueryexecuteQueryexecuteQueryXexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdateexecuteXflowPrepareDescribeInputOutputgetMetaDatagetParameterMetaDatainitResetPreparedStatementlistenToUnitOfWorkmarkClosedprepareresetForReuseresetPreparedStatementsetArraysetAsciiStreamsetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBooleansetBytesetBytessetBytesXsetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetDatesetDatesetDoublesetFloatsetInputsetIntsetIntXsetLongsetLongXsetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetNullXsetObjectsetObjectsetObjectsetRefsetRowIdsetShortsetShortXsetSQLXMLsetStringsetStringXsetTimesetTimesetTimestampsetTimestampsetUnicodeStreamsetURL