| Modifier and Type | Field and Description |
|---|---|
| private boolean | |
| protected boolean |
| Access | Constructor and Description |
|---|---|
| public | EmbedCallableStatement(EmbedConnection conn, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
|
| Modifier and Type | Method and Description |
|---|---|
| public void | addBatch()
Overrides org. Implements java. Adds a set of parameters to this |
| protected void | checkRequiresCallableStatement(Activation activation)
Overrides org. Check to see if a statement requires to be executed via a callable statement. |
| protected final boolean | executeStatement(Activation a, boolean executeQuery, boolean executeUpdate)
Overrides org. Execute the current statement. |
| public final Array | Returns: an object representing an SQL arraythe first parameter is 1, the second is 2, ... i)Implements java. JDBC 2.0 Get an Array OUT parameter. |
| public final Array | Returns: the parameter value as a Array object in the Java Programming language. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language. |
| public final BigDecimal | Returns: the parameter value (full precision); if the value is SQL NULL, the result is nullthe first parameter is 1, the second is 2, ... parameterIndex)Implements java. JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object. |
| public final 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.
Deprecated
Retrieves the value of the designated JDBC |
| public final BigDecimal | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. 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 | Returns: a stream for the binary parameter, ornull.first parameter is 1, second is 2 etc. parameterIndex)Get binary stream for a parameter. |
| public Blob | Returns: an object representing a BLOBthe first parameter is 1, the second is 2, ... parameterIndex)Implements java. JDBC 2.0 Get a BLOB OUT parameter. |
| public final Blob | Returns: the parameter value as a Blob object in the Java Programming language. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC BLOB parameter as a 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. Retrieves the value of the designated JDBC |
| public final boolean | Returns: the parameter value. If the value is SQL NULL, the result is false.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC BIT 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. Retrieves the value of the designated JDBC |
| public final byte | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. JDBC 3.0 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. Retrieves the value of the designated JDBC |
| public final byte[] | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. |
| public final Reader | Returns: ajava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned
is null in the Java programming language.the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated parameter as a
|
| public final Reader | getCharacterStream(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated parameter as a
|
| public Clob | Returns: an object representing a CLOBthe first parameter is 1, the second is 2, ... parameterIndex)Implements java. JDBC 2.0 Get a CLOB OUT parameter. |
| public final Clob | Returns: the parameter value as a Clob object in the Java Programming language. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC CLOB parameter as a 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 cal)Calendar object the driver will use
to construct the dateImplements java. Retrieves the value of the designated JDBC |
| public Date | Returns: the parameter value; if the value is SQL NULL, the result is nullthe first parameter is 1, the second is 2, ... parameterIndex)Implements java. Get the value of a SQL DATE parameter as a java.sql.Date object |
| public final Date | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object |
| public final Date | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName, Calendar - the Calendar object the driver will use to construct the
date cal)Implements java. 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. |
| public double | getDouble(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final double | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. JDBC 3.0 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. Retrieves the value of the designated JDBC |
| public final float | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. JDBC 3.0 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. Retrieves the value of the designated JDBC |
| public final int | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC INTEGER parameter as a int in the Java programming language. |
| public long | getLong(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final long | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language. |
| public final Reader | getNCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated parameter as a
|
| public final Reader | getNCharacterStream(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated parameter as a
|
| public final NClob | getNClob(int
the first parameter is 1, the second is 2, and
so on i)Implements java. Retrieves the value of the designated JDBC |
| public final NClob | getNClob(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final String | getNString(int
index of the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated |
| public final String | getNString(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated |
| public final Object | getObject(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated parameter as an |
| public final Object | Returns: a java.lang.Object holding the OUT parameter value.the first parameter is 1, the second is 2, ... i, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Implements java. JDBC 2.0
Returns an object representing the value of OUT parameter |
| public final Object | Returns: a java.lang.Object holding the OUT parameter value- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language. |
| public final Object | Returns: a java.lang.Object holding the OUT parameter value- the name of the parameter parameterName, Map<String, Class<?>> - the mapping from SQL type names to Java classes map)Implements java. 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 final <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 org. Returns an object representing the value of OUT parameter
|
| public final <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 org. Returns an object representing the value of OUT parameter
|
| public final Ref | Returns: an object representing data of an SQL REF Typethe first parameter is 1, the second is 2, ... i)Implements java. JDBC 2.0 Get a REF(<structured-type>) OUT parameter. |
| public final Ref | Returns: the parameter value as a Ref object in the Java Programming language. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC REF (structured-type) parameter as a Ref object in the Java programming language. |
| public final RowId | getRowId(int
the first parameter is 1, the second is 2,... parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final RowId | getRowId(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated JDBC |
| public short | getShort(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final short | Returns: the parameter value. If the value is SQL NULL, the result is 0.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language. |
| public final SQLXML | getSQLXML(int
index of the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated |
| public final SQLXML | getSQLXML(String
the name of the parameter parametername)Implements java. Retrieves the value of the designated |
| public String | getString(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final String | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
| public Time | getTime(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. Retrieves the value of the designated JDBC |
| public Time | Returns: the parameter value; if the value is SQL NULL, the result is nullthe first parameter is 1, the second is 2, ... parameterIndex)Implements java. Get the value of a SQL TIME parameter as a java.sql.Time object. |
| public final Time | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object |
| public final Time | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName, Calendar - the Calendar object the driver will use to construct the
time cal)Implements java. 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. |
| public Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. Retrieves the value of the designated JDBC |
| public Timestamp | Returns: the parameter value; if the value is SQL NULL, the result is nullthe first parameter is 1, the second is 2, ... parameterIndex)Implements java. Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object. |
| public final Timestamp | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object |
| public final Timestamp | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName, Calendar - the Calendar object the driver will use to construct the
Timestamp cal)Implements java. 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. |
| public URL | Returns: a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter- the first parameter is 1, the second is 2 parameterIndex)Implements java. JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object |
| public URL | Returns: the parameter value. If the value is SQL NULL, the result is null.- the name of the parameter parameterName)Implements java. JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object |
| private SQLException | |
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the JDBC type code defined by sqlType)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.Implements java. Registers the OUT parameter in ordinal position
|
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the SQL type code defined by sqlType, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Implements java. Registers the parameter in ordinal position
|
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,... parameterIndex, int a value from sqlType, String java.the fully-qualified name of an SQL structured type typeName)Implements java. JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it. |
| public final 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. JDBC 3.0 Registers the OUT parameter named parameterName to the JDBC type sqlType. |
| public final void | registerOutParameter(String
- the name of the parameter parameterName, int - the SQL type code defined by java.sql.Types. sqlType, String - the fully-qualified name of an SQL structure type typeName)Implements java. JDBC 3.0 Registers the designated output parameter. |
| public final void | registerOutParameter(String
- the name of the parameter parameterName, int - the 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. JDBC 3.0 Registers the parameter named parameterName to the JDBC type sqlType. |
| public final 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. JDBC 3.0 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)Implements java. Sets the designated parameter to the given input stream. |
| public final void | setAsciiStream(String
the name of the first parameter parameterName, InputStream the java input stream which contains the ASCII parameter value x, long the number of bytes in the stream length)Implements java. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public final void | setBigDecimal(String
- the name of the parameter parameterName, BigDecimal - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given java.math.BigDecimal value. |
| public final void | setBinaryStream(String
- the name of the parameter parameterName, InputStream - the Java input stream that contains the binary parameter value x, int - the number of bytes in the stream length)Implements java. JDBC 3.0 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)Implements java. Sets the designated parameter to the given input stream. |
| public final void | setBinaryStream(String
the name of the first 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. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public final void | setBlob(String
the name of the parameter parameterName, Blob a x)Blob object that maps an SQL BLOB valueImplements java. Sets the designated parameter to the given |
| public final 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. Sets the designated parameter to an |
| public final 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. Sets the designated parameter to an |
| public final void | setBoolean(String
- the name of the parameter parameterName, boolean - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java boolean value. |
| public final void | setByte(String
- the name of the parameter parameterName, byte - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java byte value. |
| public final void | setBytes(String
- the name of the parameter parameterName, byte[] - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java array of bytes. |
| public final void | setCharacterStream(String
- the name of the parameter parameterName, Reader - the java.io.Reader object that contains the UNICODE data reader, int - the number of characters in the stream length)Implements java. JDBC 3.0 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 reader)java.io.Reader object that contains the
Unicode dataImplements java. Sets the designated parameter to the given |
| public final void | setCharacterStream(String
the name of the first parameter parameterName, Reader the java Reader which contains the UNICODE value x, long the number of bytes in the stream length)Implements java. Sets the designated parameter to the given Reader, which will have the specified number of bytes. |
| public final void | setClob(String
the name of the parameter parameterName, Clob a x)Clob object that maps an SQL CLOB valueImplements java. Sets the designated parameter to the given |
| public final 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. Sets the designated parameter to a |
| public final 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. Sets the designated parameter to a |
| public final void | setDate(String
- the name of the parameter parameterName, Date - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given java.sql.Date value. |
| public final 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 cal)Implements java. JDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. |
| public final void | setDouble(String
- the name of the parameter parameterName, double - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java double value. |
| public final void | setFloat(String
- the name of the parameter parameterName, float - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java float value. |
| public final void | setInt(String
- the name of the parameter parameterName, int - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java int value. |
| public final void | setLong(String
- the name of the parameter parameterName, long - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java long value. |
| public final 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. Sets the designated parameter to a |
| public final void | setNCharacterStream(String
the name of the parameter parameterName, Reader the parameter value value)Implements java. Sets the designated parameter to a |
| public final void | setNClob(String
the name of the parameter to be set parameterName, NClob the parameter value value)Implements java. Sets the designated parameter to a |
| public final 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. Sets the designated parameter to a |
| public final 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. Sets the designated parameter to a |
| public final void | setNString(String
the name of the parameter to be set parameterName, String the parameter value value)Implements java. Sets the designated parameter to the given |
| public final void | setNull(String
- the name of the parameter parameterName, int - the SQL type code defined in java.sql.Types sqlType)Implements java. JDBC 3.0 Sets the designated parameter to SQL NULL. |
| public final void | setNull(String
- the name of the parameter parameterName, int - the SQL type code defined in java.sql.Types sqlType, String - the fully-qualified name of an SQL user-defined type typeName)Implements java. JDBC 3.0 Sets the designated parameter to SQL NULL. |
| public final 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. JDBC 3.0 Sets the value of the designated parameter with the given object. |
| public final 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. JDBC 3.0 Sets the value of the designated parameter with the given object. |
| public final void | setObject(String
- the name of the parameter parameterName, Object - the object containing the input parameter value x)Implements java. JDBC 3.0 Sets the value of the designated parameter with the given object. |
| public final void | setRowId(String
the name of the parameter parameterName, RowId the parameter value x)Implements java. Sets the designated parameter to the given |
| public final void | setShort(String
- the name of the parameter parameterName, short - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java short value. |
| public final void | setSQLXML(String
the name of the parameter parameterName, SQLXML a xmlObject)SQLXML object that maps an SQL XML valueImplements java. Sets the designated parameter to the given |
| public final void | setString(String
- the name of the parameter parameterName, String - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given Java String value. |
| public final void | setTime(String
- the name of the parameter parameterName, Time - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given java.sql.Time value. |
| public final 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 cal)Implements java. JDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar object |
| public final void | setTimestamp(String
- the name of the parameter parameterName, Timestamp - the parameter value x)Implements java. JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value. |
| public final 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. cal)Implements java. JDBC 3.0 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 val)Implements java. JDBC 3.0 Sets the designated parameter to the given java.net.URL object. |
| public boolean | wasNull()
Implements java. Retrieves whether the last OUT parameter read had the value of
SQL |