| 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 org.apache.derby.impl.jdbc.EmbedCallableStatement20
All known Subclasses: org.apache.derby.impl.jdbc.EmbedCallableStatement30,
Method Summary | |
public Array | getArray(int i) JDBC 2.0
Get an Array OUT parameter.
Parameters: i - the first parameter is 1, the second is 2, ... | public Array | getArray(String parameterName) JDBC 3.0
Retrieves the value of a JDBC ARRAY parameter as an Array object
in the Java programming language. | public BigDecimal | getBigDecimal(int parameterIndex) JDBC 2.0
Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... | public 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
Parameters: parameterName - - the name of the parameter the parameter value. | final public BigDecimal | getBigDecimal(int parameterIndex, int scale) | public Blob | getBlob(String parameterName) JDBC 3.0
Retrieves the value of a JDBC BLOB parameter as a Blob object
in the Java programming language. | public boolean | getBoolean(String parameterName) JDBC 3.0
Retrieves the value of a JDBC BIT parameter as a boolean in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public byte | getByte(String parameterName) JDBC 3.0
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public 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.
Parameters: parameterName - - the name of the parameter the parameter value. | public Reader | getCharacterStream(int parameterIndex) Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language.
Introduced in JDBC 4.0.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... | public Clob | getClob(String parameterName) JDBC 3.0
Retrieves the value of a JDBC CLOB parameter as a Clob object
in the Java programming language. | public Date | getDate(String parameterName) JDBC 3.0
Retrieves the value of a JDBC DATE parameter as ajava.sql.Date object
Parameters: parameterName - - the name of the parameter the parameter value. | public 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.
Parameters: parameterName - - the name of the parameter Parameters: cal - - the Calendar object the driver will use to construct the date the parameter value. | public double | getDouble(String parameterName) JDBC 3.0
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public float | getFloat(String parameterName) JDBC 3.0
Retrieves the value of a JDBC FLOAT parameter as a float in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public int | getInt(String parameterName) JDBC 3.0
Retrieves the value of a JDBC INTEGER parameter as a int in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public long | getLong(String parameterName) JDBC 3.0
Retrieves the value of a JDBC BIGINT parameter as a long in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public Object | getObject(int i, java.util.Map map) JDBC 2.0
Returns an object representing the value of OUT parameter @i. | public Object | getObject(String parameterName) JDBC 3.0
Retrieves the value of a parameter as an Object in the java programming language. | public Object | getObject(String parameterName, Map 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. | public Ref | getRef(int i) JDBC 2.0
Get a REF(<structured-type>) OUT parameter.
Parameters: i - the first parameter is 1, the second is 2, ... | public Ref | getRef(String parameterName) JDBC 3.0
Retrieves the value of a JDBC REF ( | public short | getShort(String parameterName) JDBC 3.0
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. | public 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.
Parameters: parameterName - - the name of the parameter the parameter value. | public Time | getTime(String parameterName) JDBC 3.0
Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object
Parameters: parameterName - - the name of the parameter the parameter value. | public 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.
Parameters: parameterName - - the name of the parameter Parameters: cal - - the Calendar object the driver will use to construct the time the parameter value. | public Timestamp | getTimestamp(String parameterName) JDBC 3.0
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object
Parameters: parameterName - - the name of the parameter the parameter value. | public 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.
Parameters: parameterName - - the name of the parameter Parameters: cal - - the Calendar object the driver will use to construct the Timestamp the parameter value. | public void | registerOutParameter(String parameterName, int sqlType) 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.
Parameters: parameterName - - the name of the parameter Parameters: sqlType - - the JDBC type code defined by java.sql.Types. | public void | registerOutParameter(String parameterName, int sqlType, String typeName) JDBC 3.0
Registers the designated output parameter. | public void | registerOutParameter(String parameterName, int sqlType, int scale) JDBC 3.0
Registers the parameter named parameterName to the JDBC type sqlType. | public void | setArray(int i, Array x) JDBC 2.0
Set an Array parameter. | public 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. | public void | setBigDecimal(String parameterName, BigDecimal x) JDBC 3.0
Sets the designated parameter to the given java.math.BigDecimal value. | final public void | setBigDecimal(int parameterIndex, BigDecimal x) Set a parameter to a java.lang.BigDecimal value. | public 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. | public void | setBoolean(String parameterName, boolean x) JDBC 3.0
Sets the designated parameter to the given Java boolean value. | public void | setByte(String parameterName, byte x) JDBC 3.0
Sets the designated parameter to the given Java byte value. | public void | setBytes(String parameterName, byte[] x) JDBC 3.0
Sets the designated parameter to the given Java array of bytes. | public 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. | public void | setDate(String parameterName, Date x) JDBC 3.0
Sets the designated parameter to the given java.sql.Date value. | public 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. | public void | setDouble(String parameterName, double x) JDBC 3.0
Sets the designated parameter to the given Java double value. | public void | setFloat(String parameterName, float x) JDBC 3.0
Sets the designated parameter to the given Java float value. | public void | setInt(String parameterName, int x) JDBC 3.0
Sets the designated parameter to the given Java int value. | public void | setLong(String parameterName, long x) JDBC 3.0
Sets the designated parameter to the given Java long value. | public void | setNull(String parameterName, int sqlType) JDBC 3.0
Sets the designated parameter to SQL NULL. | public void | setNull(String parameterName, int sqlType, String typeName) JDBC 3.0
Sets the designated parameter to SQL NULL. | public void | setObject(String parameterName, Object x, int targetSqlType, int scale) JDBC 3.0
Sets the value of the designated parameter with the given object. | public void | setObject(String parameterName, Object x, int targetSqlType) JDBC 3.0
Sets the value of the designated parameter with the given object. | public void | setObject(String parameterName, Object x) JDBC 3.0
Sets the value of the designated parameter with the given object. | boolean | setObjectConvert(int parameterIndex, Object x) Allow explict setObject conversions by sub-classes for classes
not supported by this variant. | public void | setRef(int i, Ref x) JDBC 2.0
Set a REF(<structured-type>) parameter. | public void | setShort(String parameterName, short x) JDBC 3.0
Sets the designated parameter to the given Java short value. | public void | setString(String parameterName, String x) JDBC 3.0
Sets the designated parameter to the given Java String value. | public void | setTime(String parameterName, Time x) JDBC 3.0
Sets the designated parameter to the given java.sql.Time value. | public void | setTime(String parameterName, Time x, Calendar cal) | public void | setTimestamp(String parameterName, Timestamp x) JDBC 3.0
Sets the designated parameter to the given java.sql.Timestamp value. | public void | setTimestamp(String parameterName, Timestamp x, Calendar cal) |
getArray | public Array getArray(int i) throws SQLException(Code) | | JDBC 2.0
Get an Array OUT parameter.
Parameters: i - the first parameter is 1, the second is 2, ... an object representing an SQL array exception: SQLException - if a database-access error occurs. |
getArray | public Array getArray(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC ARRAY parameter as an Array object
in the Java programming language.
Parameters: parameterName - - the name of the parameter the parameter value as a Array object in the Java Programming language.If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getBigDecimal | public BigDecimal getBigDecimal(int parameterIndex) throws SQLException(Code) | | JDBC 2.0
Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... the parameter value (full precision); if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getBigDecimal | public BigDecimal getBigDecimal(String parameterName) throws SQLException(Code) | | 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
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getBlob | public Blob getBlob(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC BLOB parameter as a Blob object
in the Java programming language.
Parameters: parameterName - - the name of the parameter the parameter value as a Blob object in the Java Programming language.If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getBoolean | public boolean getBoolean(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC BIT parameter as a boolean in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is false. exception: SQLException - Feature not implemented for now. |
getByte | public byte getByte(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getBytes | public byte[] getBytes(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array
of byte values in the Java programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getCharacterStream | public Reader getCharacterStream(int parameterIndex) throws SQLException(Code) | | Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language.
Introduced in JDBC 4.0.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... a java.io.Reader object that contains the parametervalue; if the value is SQL NULL , the value returnedis null in the Java programming language. throws: SQLException - if a database access error occurs or this method iscalled on a closed CallableStatement |
getClob | public Clob getClob(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC CLOB parameter as a Clob object
in the Java programming language.
Parameters: parameterName - - the name of the parameter the parameter value as a Clob object in the Java Programming language.If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getDate | public Date getDate(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC DATE parameter as ajava.sql.Date object
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getDate | public Date getDate(String parameterName, Calendar cal) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: cal - - the Calendar object the driver will use to construct the date the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getDouble | public double getDouble(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getFloat | public float getFloat(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC FLOAT parameter as a float in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getInt | public int getInt(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC INTEGER parameter as a int in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getLong | public long getLong(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC BIGINT parameter as a long in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getObject | public Object getObject(int i, java.util.Map map) throws SQLException(Code) | | 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.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: map - the mapping from SQL type names to Java classes a java.lang.Object holding the OUT parameter value. exception: SQLException - if a database-access error occurs. |
getObject | public Object getObject(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a parameter as an Object in the java programming language.
Parameters: parameterName - - the name of the parameter a java.lang.Object holding the OUT parameter value exception: SQLException - Feature not implemented for now. |
getObject | public Object getObject(String parameterName, Map map) throws SQLException(Code) | | JDBC 3.0
Returns an object representing the value of OUT parameter i and uses map for
the custom mapping of the parameter value.
Parameters: parameterName - - the name of the parameter Parameters: map - - the mapping from SQL type names to Java classes a java.lang.Object holding the OUT parameter value exception: SQLException - Feature not implemented for now. |
getRef | public Ref getRef(int i) throws SQLException(Code) | | JDBC 2.0
Get a REF(<structured-type>) OUT parameter.
Parameters: i - the first parameter is 1, the second is 2, ... an object representing data of an SQL REF Type exception: SQLException - if a database-access error occurs. |
getRef | public Ref getRef(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC REF (Parameters: parameterName - - the name of the parameter the parameter value as a Ref object in the Java Programming language.If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getShort | public short getShort(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java
programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is 0. exception: SQLException - Feature not implemented for now. |
getString | public String getString(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as
a String in the Java programming language.
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getTime | public Time getTime(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getTime | public Time getTime(String parameterName, Calendar cal) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: cal - - the Calendar object the driver will use to construct the time the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getTimestamp | public Timestamp getTimestamp(String parameterName) throws SQLException(Code) | | JDBC 3.0
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object
Parameters: parameterName - - the name of the parameter the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
getTimestamp | public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: cal - - the Calendar object the driver will use to construct the Timestamp the parameter value. If the value is SQL NULL, the result is null. exception: SQLException - Feature not implemented for now. |
registerOutParameter | public void registerOutParameter(String parameterName, int sqlType) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: sqlType - - the JDBC type code defined by java.sql.Types. If theparameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameterthat accepts a scale value should be used. exception: SQLException - Feature not implemented for now. |
registerOutParameter | public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: sqlType - - the SQL type code defined by java.sql.Types. Parameters: typeName - - the fully-qualified name of an SQL structure type exception: SQLException - Feature not implemented for now. |
registerOutParameter | public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException(Code) | | JDBC 3.0
Registers the parameter named parameterName to the JDBC type sqlType.
This method must be called before a stored procedure is executed.
Parameters: parameterName - - the name of the parameter Parameters: sqlType - - the SQL type code defined by java.sql.Types. Parameters: scale - - the desired number of digits to the right of the decimal point.It must be greater than or equal to zero. exception: SQLException - Feature not implemented for now. |
setArray | public void setArray(int i, Array x) throws SQLException(Code) | | JDBC 2.0
Set an Array parameter.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: x - an object representing an SQL array exception: SQLException - Feature not implemented for now. |
setAsciiStream | public void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given input stream, which will have the
specified number of bytes.
Parameters: parameterName - - the name of the parameter Parameters: x - - the Java input stream that contains the ASCII parameter value Parameters: length - - the number of bytes in the stream exception: SQLException - Feature not implemented for now. |
setBigDecimal | public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setBigDecimal | final public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException(Code) | | Set a parameter to a java.lang.BigDecimal value.
The driver converts this to a SQL NUMERIC value when
it sends it to the database.
Parameters: parameterIndex - the first parameter is 1, the second is 2, ... Parameters: x - the parameter value exception: SQLException - thrown on failure. |
setBinaryStream | public void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given input stream, which will have the
specified number of bytes.
Parameters: parameterName - - the name of the parameter Parameters: x - - the Java input stream that contains the binary parameter value Parameters: length - - the number of bytes in the stream exception: SQLException - Feature not implemented for now. |
setBoolean | public void setBoolean(String parameterName, boolean x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setByte | public void setByte(String parameterName, byte x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setBytes | public void setBytes(String parameterName, byte[] x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setCharacterStream | public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given Reader object, which is the given
number of characters long.
Parameters: parameterName - - the name of the parameter Parameters: reader - - the java.io.Reader object that contains the UNICODE data Parameters: length - - the number of characters in the stream exception: SQLException - Feature not implemented for now. |
setDate | public void setDate(String parameterName, Date x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setDate | public void setDate(String parameterName, Date x, Calendar cal) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given java.sql.Date value, using the given
Calendar object.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value Parameters: cal - - the Calendar object the driver will use to construct the date exception: SQLException - Feature not implemented for now. |
setDouble | public void setDouble(String parameterName, double x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setFloat | public void setFloat(String parameterName, float x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setInt | public void setInt(String parameterName, int x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setLong | public void setLong(String parameterName, long x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setNull | public void setNull(String parameterName, int sqlType) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to SQL NULL.
Parameters: parameterName - - the name of the parameter Parameters: sqlType - - the SQL type code defined in java.sql.Types exception: SQLException - Feature not implemented for now. |
setNull | public void setNull(String parameterName, int sqlType, String typeName) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to SQL NULL.
Parameters: parameterName - - the name of the parameter Parameters: sqlType - - the SQL type code defined in java.sql.Types Parameters: typeName - - the fully-qualified name of an SQL user-defined type exception: SQLException - Feature not implemented for now. |
setObject | public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the object containing the input parameter value Parameters: targetSqlType - - the SQL type (as defined in java.sql.Types) to be sent tothe database. The scale argument may further qualify this type. Parameters: scale - - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, thisis the number of digits after the decimal point. For all other types, this valuewill be ignored. exception: SQLException - Feature not implemented for now. |
setObject | public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the object containing the input parameter value Parameters: targetSqlType - - the SQL type (as defined in java.sql.Types) to be sent tothe database. exception: SQLException - Feature not implemented for now. |
setObject | public void setObject(String parameterName, Object x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the object containing the input parameter value exception: SQLException - Feature not implemented for now. |
setObjectConvert | boolean setObjectConvert(int parameterIndex, Object x) throws SQLException(Code) | | Allow explict setObject conversions by sub-classes for classes
not supported by this variant. In this case handle BigDecimal.
true if the object was set successfully, false if no validconversion exists. exception: SQLException - value could not be set. |
setRef | public void setRef(int i, Ref x) throws SQLException(Code) | | JDBC 2.0
Set a REF(<structured-type>) parameter.
Parameters: i - the first parameter is 1, the second is 2, ... Parameters: x - an object representing data of an SQL REF Type exception: SQLException - Feature not implemented for now. |
setShort | public void setShort(String parameterName, short x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setString | public void setString(String parameterName, String x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setTime | public void setTime(String parameterName, Time x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setTime | public void setTime(String parameterName, Time x, Calendar cal) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given java.sql.Time value using the
Calendar object
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value Parameters: cal - - the Calendar object the driver will use to construct the time exception: SQLException - Feature not implemented for now. |
setTimestamp | public void setTimestamp(String parameterName, Timestamp x) throws SQLException(Code) | | 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.
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value exception: SQLException - Feature not implemented for now. |
setTimestamp | public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given java.sql.Timestamp value, using the
given Calendar object
Parameters: parameterName - - the name of the parameter Parameters: x - - the parameter value Parameters: cal - - the Calendar object the driver will use to construct the timestamp. exception: SQLException - Feature not implemented for now. |
Fields inherited from org.apache.derby.impl.jdbc.EmbedCallableStatement | protected boolean wasNull(Code)(Java Doc)
|
Methods inherited from org.apache.derby.impl.jdbc.EmbedCallableStatement | public void addBatch() throws SQLException(Code)(Java Doc) protected void checkRequiresCallableStatement(Activation activation)(Code)(Java Doc) final protected boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws SQLException(Code)(Java Doc) public Blob getBlob(int i) throws SQLException(Code)(Java Doc) public boolean getBoolean(int parameterIndex) throws SQLException(Code)(Java Doc) public byte getByte(int parameterIndex) throws SQLException(Code)(Java Doc) public byte[] getBytes(int parameterIndex) throws SQLException(Code)(Java Doc) public Clob getClob(int i) throws SQLException(Code)(Java Doc) public Date getDate(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Date getDate(int parameterIndex, Calendar cal) throws SQLException(Code)(Java Doc) public double getDouble(int parameterIndex) throws SQLException(Code)(Java Doc) public float getFloat(int parameterIndex) throws SQLException(Code)(Java Doc) public int getInt(int parameterIndex) throws SQLException(Code)(Java Doc) public long getLong(int parameterIndex) throws SQLException(Code)(Java Doc) final public Object getObject(int parameterIndex) throws SQLException(Code)(Java Doc) public short getShort(int parameterIndex) throws SQLException(Code)(Java Doc) public String getString(int parameterIndex) throws SQLException(Code)(Java Doc) public Time getTime(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Time getTime(int parameterIndex, Calendar cal) throws SQLException(Code)(Java Doc) public Timestamp getTimestamp(int parameterIndex) throws SQLException(Code)(Java Doc) public java.sql.Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException(Code)(Java Doc) public URL getURL(int parameterIndex) throws SQLException(Code)(Java Doc) public URL getURL(String parameterName) throws SQLException(Code)(Java Doc) final public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException(Code)(Java Doc) final public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException(Code)(Java Doc) public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException(Code)(Java Doc) public void setURL(String parameterName, URL val) throws SQLException(Code)(Java Doc) public boolean wasNull() throws SQLException(Code)(Java Doc)
|
Methods inherited from org.apache.derby.impl.jdbc.EmbedPreparedStatement | final public void addBatch(String sql) throws SQLException(Code)(Java Doc) public void addBatch() throws SQLException(Code)(Java Doc) public void clearParameters() throws SQLException(Code)(Java Doc) void closeActions() throws SQLException(Code)(Java Doc) final SQLException dataTypeConversion(int column, String sourceType) throws SQLException(Code)(Java Doc) final public boolean execute(String sql) throws SQLException(Code)(Java Doc) final public boolean execute(String sql, int autoGenKeys) throws SQLException(Code)(Java Doc) final public boolean execute(String sql, int[] columnIndexes) throws SQLException(Code)(Java Doc) final public boolean execute(String sql, String[] columnNames) throws SQLException(Code)(Java Doc) final public boolean execute() throws SQLException(Code)(Java Doc) boolean executeBatchElement(Object batchElement) throws SQLException, StandardException(Code)(Java Doc) final public java.sql.ResultSet executeQuery(String sql) throws SQLException(Code)(Java Doc) final public java.sql.ResultSet executeQuery() throws SQLException(Code)(Java Doc) boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws SQLException(Code)(Java Doc) final public int executeUpdate(String sql) throws SQLException(Code)(Java Doc) final public int executeUpdate(String sql, int autoGenKeys) throws SQLException(Code)(Java Doc) final public int executeUpdate(String sql, int[] columnIndexes) throws SQLException(Code)(Java Doc) final public int executeUpdate(String sql, String[] columnNames) throws SQLException(Code)(Java Doc) final public int executeUpdate() throws SQLException(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) public EngineParameterMetaData getEmbedParameterSetMetaData() throws SQLException(Code)(Java Doc) public java.sql.ResultSetMetaData getMetaData() throws SQLException(Code)(Java Doc) protected int getParameterJDBCType(int parameterIndex) throws SQLException(Code)(Java Doc) final protected String getParameterSQLType(int parameterIndex) throws SQLException(Code)(Java Doc) final public ParameterValueSet getParms()(Code)(Java Doc) final protected DataTypeDescriptor[] getTypes(int parameterIndex) throws SQLException(Code)(Java Doc) protected EmbedResultSetMetaData newEmbedResultSetMetaData(ResultDescription resultDesc)(Code)(Java Doc) final public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException(Code)(Java Doc) final public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException(Code)(Java Doc) public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException(Code)(Java Doc) public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException(Code)(Java Doc) final public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException(Code)(Java Doc) final public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException(Code)(Java Doc) public void setBlob(int i, Blob x) throws SQLException(Code)(Java Doc) public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException(Code)(Java Doc) public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException(Code)(Java Doc) public void setBoolean(int parameterIndex, boolean x) throws SQLException(Code)(Java Doc) public void setBrokeredConnectionControl(BrokeredConnectionControl control)(Code)(Java Doc) public void setByte(int parameterIndex, byte x) throws SQLException(Code)(Java Doc) public void setBytes(int parameterIndex, byte x) throws SQLException(Code)(Java Doc) final public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws SQLException(Code)(Java Doc) final public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws SQLException(Code)(Java Doc) public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException(Code)(Java Doc) public void setClob(int i, Clob x) throws SQLException(Code)(Java Doc) public void setClob(int parameterIndex, Reader reader) throws SQLException(Code)(Java Doc) public void setClob(int parameterIndex, Reader reader, long length) throws SQLException(Code)(Java Doc) public void setDate(int parameterIndex, Date x) throws SQLException(Code)(Java Doc) final public void setDate(int parameterIndex, java.sql.Date x, Calendar cal) throws SQLException(Code)(Java Doc) public void setDouble(int parameterIndex, double x) throws SQLException(Code)(Java Doc) public void setFloat(int parameterIndex, float x) throws SQLException(Code)(Java Doc) public void setInt(int parameterIndex, int x) throws SQLException(Code)(Java Doc) public void setLong(int parameterIndex, long x) throws SQLException(Code)(Java Doc) public void setNull(int parameterIndex, int sqlType) throws SQLException(Code)(Java Doc) public void setNull(int paramIndex, int sqlType, String typeName) throws SQLException(Code)(Java Doc) final public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException(Code)(Java Doc) final public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException(Code)(Java Doc) final public void setObject(int parameterIndex, Object x) throws SQLException(Code)(Java Doc) boolean setObjectConvert(int parameterIndex, Object x) throws SQLException(Code)(Java Doc) public void setShort(int parameterIndex, short x) throws SQLException(Code)(Java Doc) public void setString(int parameterIndex, String x) throws SQLException(Code)(Java Doc) public void setTime(int parameterIndex, Time x) throws SQLException(Code)(Java Doc) final public void setTime(int parameterIndex, java.sql.Time x, Calendar cal) throws SQLException(Code)(Java Doc) public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException(Code)(Java Doc) final public void setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar cal) throws SQLException(Code)(Java Doc) final public void setURL(int parameterIndex, java.net.URL x) throws SQLException(Code)(Java Doc) public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException(Code)(Java Doc) public String toString()(Code)(Java Doc) public void transferParameters(EmbedPreparedStatement newStatement) throws SQLException(Code)(Java Doc)
|
|
|