java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapperpublic class VirtuosoCallableStatement extends VirtuosoPreparedStatement implements java.sql.CallableStatement
CallableStatement s = connection.prepareCall(...)
| Modifier and Type | Field | Description |
|---|---|---|
protected int[] |
param_scale |
|
protected int[] |
param_type |
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFOps_vresultSet, sqlbatch, close_flag, closeOnCompletion, connection, cursorName, exec_type, future, isCached, metaData, objparams, parameters, paramsMetaData, prefetch, req_no, result_opened, rpc_timeout, sparql_executed, statid, txn_timeout, type, vresultSet, wait_result| Modifier and Type | Method | Description |
|---|---|---|
java.sql.Array |
getArray(int parameterIndex) |
Gets the value of a JDBC
ARRAY parameter as an
Array object in the Java programming language. |
java.sql.Array |
getArray(java.lang.String parameterName) |
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
Gets 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.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName) |
|
java.sql.Blob |
getBlob(int parameterIndex) |
Gets the value of a JDBC BLOB parameter as a
Blob object in the Java programming language. |
java.sql.Blob |
getBlob(java.lang.String parameterName) |
|
boolean |
getBoolean(int parameterIndex) |
Gets the value of a JDBC BIT parameter as a boolean
in the Java programming language.
|
boolean |
getBoolean(java.lang.String parameterName) |
|
byte |
getByte(int parameterIndex) |
Gets the value of a JDBC TINYINT parameter as a byte
in the Java programming language.
|
byte |
getByte(java.lang.String parameterName) |
|
byte[] |
getBytes(int parameterIndex) |
Gets the value of a JDBC BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language.
|
byte[] |
getBytes(java.lang.String parameterName) |
|
java.io.Reader |
getCharacterStream(int parameterIndex) |
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language. |
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language. |
java.sql.Clob |
getClob(int parameterIndex) |
Gets the value of a JDBC CLOB parameter as a
Clob object in the Java programming language.
|
java.sql.Clob |
getClob(java.lang.String parameterName) |
|
java.sql.Date |
getDate(int parameterIndex) |
Gets the value of a JDBC DATE parameter as a
java.sql.Date object.
|
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal) |
Gets the value of a JDBC DATE parameter as a java.sql.Date object, using
the given Calendar object to construct the date.
|
java.sql.Date |
getDate(java.lang.String parameterName) |
|
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal) |
|
double |
getDouble(int parameterIndex) |
Gets the value of a JDBC DOUBLE parameter as a
double
in the Java programming language. |
double |
getDouble(java.lang.String parameterName) |
|
float |
getFloat(int parameterIndex) |
Gets the value of a JDBC FLOAT parameter as a
float
in the Java programming language. |
float |
getFloat(java.lang.String parameterName) |
|
int |
getInt(int parameterIndex) |
Gets the value of a JDBC INTEGER parameter as an
int
in the Java programming language. |
int |
getInt(java.lang.String parameterName) |
|
long |
getLong(int parameterIndex) |
Gets the value of a JDBC BIGINT parameter as a
long
in the Java programming language. |
long |
getLong(java.lang.String parameterName) |
|
java.io.Reader |
getNCharacterStream(int parameterIndex) |
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language. |
java.io.Reader |
getNCharacterStream(java.lang.String parameterName) |
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language. |
java.sql.NClob |
getNClob(int parameterIndex) |
Retrieves the value of the designated JDBC
NCLOB parameter as a
java.sql.NClob object in the Java programming language. |
java.sql.NClob |
getNClob(java.lang.String parameterName) |
Retrieves the value of a JDBC
NCLOB parameter as a
java.sql.NClob object in the Java programming language. |
java.lang.String |
getNString(int parameterIndex) |
Retrieves the value of the designated
NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language. |
java.lang.String |
getNString(java.lang.String parameterName) |
Retrieves the value of the designated
NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language. |
java.lang.Object |
getObject(int parameterIndex) |
Gets the value of a parameter as an object in the Java
programming language.
|
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type) |
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. |
java.lang.Object |
getObject(int parameterIndex,
java.util.Map map) |
Returns an object representing the value of OUT parameter
i and uses map for the custom mapping of the parameter value.
|
java.lang.Object |
getObject(java.lang.String parameterName) |
|
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
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. |
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map map) |
|
java.sql.Ref |
getRef(int parameterIndex) |
Gets the value of a JDBC REF(<structured-type>)
parameter as a
Ref object in the Java programming language. |
java.sql.Ref |
getRef(java.lang.String parameterName) |
|
java.sql.RowId |
getRowId(int parameterIndex) |
Retrieves the value of the designated JDBC
ROWID parameter as a
java.sql.RowId object. |
java.sql.RowId |
getRowId(java.lang.String parameterName) |
Retrieves the value of the designated JDBC
ROWID parameter as a
java.sql.RowId object. |
short |
getShort(int parameterIndex) |
Gets the value of a JDBC SMALLINT parameter as a
short
in the Java programming language. |
short |
getShort(java.lang.String parameterName) |
|
java.sql.SQLXML |
getSQLXML(int parameterIndex) |
Retrieves the value of the designated
SQL XML parameter as a
java.sql.SQLXML object in the Java programming language. |
java.sql.SQLXML |
getSQLXML(java.lang.String parameterName) |
Retrieves the value of the designated
SQL XML parameter as a
java.sql.SQLXML object in the Java programming language. |
java.lang.String |
getString(int parameterIndex) |
Retrieves the value of a JDBC CHAR, VARCHAR,
or LONGVARCHAR parameter as a String in
the Java programming language.
|
java.lang.String |
getString(java.lang.String parameterName) |
|
java.sql.Time |
getTime(int parameterIndex) |
Get the value of a JDBC TIME parameter as a
java.sql.Time object.
|
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal) |
Gets the value of a JDBC TIME parameter as a java.sql.Time object, using
the given Calendar object to construct the time.
|
java.sql.Time |
getTime(java.lang.String parameterName) |
|
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(int parameterIndex) |
Gets the value of a JDBC TIMESTAMP parameter as a
java.sql.Timestamp object.
|
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal) |
Gets the value of a JDBC TIMESTAMP parameter as a
java.sql.Timestamp object, using the given Calendar object to construct
the Timestamp object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal) |
|
java.net.URL |
getURL(int parameterIndex) |
|
java.net.URL |
getURL(java.lang.String parameterName) |
|
boolean |
hasOut() |
Indicates whether the OUT parameters exist.
|
void |
registerOutParameter(int parameterIndex,
int sqlType) |
Registers the OUT parameter in ordinal position
parameterIndex to the JDBC type sqlType.
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
Registers the parameter in ordinal position
parameterIndex to be of JDBC type sqlType.
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName) |
Registers the designated output parameter.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x) |
Sets the designated parameter to the given input stream.
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x) |
Sets the designated parameter to the given input stream.
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream) |
Sets the designated parameter to a
InputStream object. |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
Sets the designated parameter to a
InputStream object. |
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x) |
Sets the designated parameter to the given
java.sql.Blob object. |
void |
setBoolean(java.lang.String parameterName,
boolean x) |
|
void |
setByte(java.lang.String parameterName,
byte x) |
|
void |
setBytes(java.lang.String parameterName,
byte[] x) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader) |
Sets the designated parameter to the given
Reader
object. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length) |
Sets the designated parameter to the given
Reader
object, which is the given number of characters long. |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader) |
Sets the designated parameter to a
Reader object. |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
Sets the designated parameter to a
Reader object. |
void |
setClob(java.lang.String parameterName,
java.sql.Clob x) |
Sets the designated parameter to the given
java.sql.Clob object. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x) |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal) |
|
void |
setDouble(java.lang.String parameterName,
double x) |
|
void |
setFloat(java.lang.String parameterName,
float x) |
|
void |
setInt(java.lang.String parameterName,
int x) |
|
void |
setLong(java.lang.String parameterName,
long x) |
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
Sets the designated parameter to a
Reader object. |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
Sets the designated parameter to a
Reader object. |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader) |
Sets the designated parameter to a
Reader object. |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
Sets the designated parameter to a
Reader object. |
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value) |
Sets the designated parameter to a
java.sql.NClob object. |
void |
setNString(java.lang.String parameterName,
java.lang.String value) |
Sets the designated parameter to the given
String object. |
void |
setNull(java.lang.String parameterName,
int sqlType) |
|
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale) |
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x) |
Sets the designated parameter to the given
java.sql.RowId object. |
void |
setShort(java.lang.String parameterName,
short x) |
|
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
Sets the designated parameter to the given
java.sql.SQLXML object. |
void |
setString(java.lang.String parameterName,
java.lang.String x) |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x) |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal) |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x) |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal) |
|
void |
setURL(java.lang.String parameterName,
java.net.URL val) |
|
boolean |
wasNull() |
Indicates whether or not the last OUT parameter read had the value of
SQL NULL.
|
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObjectclone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitaddBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLaddBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutaddBatch, clearParameters, close, execute, executeBatch, executeBatchUpdate, executeQuery, executeUpdate, finalize, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClosed, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, setVectoraddBatch, cancel, cancel_rs, clearBatch, clearWarnings, close_rs, closeOnCompletion, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getExecType, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getStmtOpts, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, notify_error, sendQuery, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrappublic void registerOutParameter(int parameterIndex,
int sqlType)
throws VirtuosoException
registerOutParameter in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onsqlType - the JDBC type code defined by java.sql.Types.
If the parameter is of type Numeric or Decimal, the version of
registerOutParameter that accepts a scale value should be used.VirtuosoException - if a database access error occursCallableStatement.registerOutParameter(int, int),
Typespublic void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws VirtuosoException
registerOutParameter in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onsqlType - SQL type code defined by java.sql.Types.scale - the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero.VirtuosoException - if a database access error occursCallableStatement.registerOutParameter(int, int),
Typespublic boolean wasNull()
throws VirtuosoException
wasNull in interface java.sql.CallableStatementVirtuosoException - if a database access error occursCallableStatement.wasNull()public boolean hasOut()
public java.lang.String getString(int parameterIndex)
throws VirtuosoException
getString in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getString(int)public boolean getBoolean(int parameterIndex)
throws VirtuosoException
getBoolean in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getBoolean(int)public byte getByte(int parameterIndex)
throws VirtuosoException
getByte in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getByte(int)public short getShort(int parameterIndex)
throws VirtuosoException
short
in the Java programming language.getShort in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getShort(int)public int getInt(int parameterIndex)
throws VirtuosoException
int
in the Java programming language.getInt in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getInt(int)public long getLong(int parameterIndex)
throws VirtuosoException
long
in the Java programming language.getLong in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getLong(int)public float getFloat(int parameterIndex)
throws VirtuosoException
float
in the Java programming language.getFloat in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getFloat(int)public double getDouble(int parameterIndex)
throws VirtuosoException
double
in the Java programming language.getDouble in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getDouble(int)public java.math.BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws VirtuosoException
getBigDecimal in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onscale - the number of digits to the right of the decimal pointVirtuosoException - if a database access error occursCallableStatement.getBigDecimal(int, int)public byte[] getBytes(int parameterIndex)
throws VirtuosoException
getBytes in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getBytes(int)public java.sql.Date getDate(int parameterIndex)
throws VirtuosoException
getDate in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getDate(int)public java.sql.Time getTime(int parameterIndex)
throws VirtuosoException
getTime in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getTime(int)public java.sql.Timestamp getTimestamp(int parameterIndex)
throws VirtuosoException
getTimestamp in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getTimestamp(int)public java.lang.Object getObject(int parameterIndex)
throws VirtuosoException
getObject in interface java.sql.CallableStatementparameterIndex - The first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getObject(int)public java.math.BigDecimal getBigDecimal(int parameterIndex)
throws VirtuosoException
getBigDecimal in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getBigDecimal(int, int)public java.lang.Object getObject(int parameterIndex,
java.util.Map map)
throws VirtuosoException
getObject in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, and so onmap - the mapping from SQL type names to Java classesVirtuosoException - if a database access error occursCallableStatement.getObject(int)public java.sql.Ref getRef(int parameterIndex)
throws VirtuosoException
Ref object in the Java programming language.getRef in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onVirtuosoException - if a database access error occursCallableStatement.getRef(int)public java.sql.Blob getBlob(int parameterIndex)
throws VirtuosoException
Blob object in the Java programming language.getBlob in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, and so onVirtuosoException - if a database access error occursCallableStatement.getBlob(int)public java.sql.Clob getClob(int parameterIndex)
throws VirtuosoException
getClob in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, and
so onClob object in the
Java programming language. If the value was SQL NULL, the
value null is returned.VirtuosoException - if a database access error occursCallableStatement.getClob(int)public java.sql.Array getArray(int parameterIndex)
throws VirtuosoException
ARRAY parameter as an
Array object in the Java programming language.getArray in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, and
so onArray object in
the Java programming language. If the value was SQL NULL, the
value null is returned.VirtuosoException - if a database access error occurspublic java.sql.Date getDate(int parameterIndex,
java.util.Calendar cal)
throws VirtuosoException
getDate in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so oncal - the Calendar object the driver will use
to construct the dateVirtuosoException - if a database access error occursCallableStatement.getDate(int)public java.sql.Time getTime(int parameterIndex,
java.util.Calendar cal)
throws VirtuosoException
getTime in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so oncal - the Calendar object the driver will use
to construct the timeVirtuosoException - if a database access error occursCallableStatement.getTime(int)public java.sql.Timestamp getTimestamp(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so oncal - the Calendar object the driver will use
to construct the timestampjava.sql.SQLException - if a database access error occurspublic void registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws VirtuosoException
registerOutParameter
should be used for a user-named or REF output parameter. Examples
of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.registerOutParameter in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,...sqlType - a value from TypestypeName - the fully-qualified name of an SQL structured typeVirtuosoException - if a database access error occursCallableStatement.registerOutParameter(int, int)public void registerOutParameter(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.net.URL getURL(int parameterIndex)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setURL(java.lang.String parameterName,
java.net.URL val)
throws java.sql.SQLException
setURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNull(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBoolean(java.lang.String parameterName,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setByte(java.lang.String parameterName,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setShort(java.lang.String parameterName,
short x)
throws java.sql.SQLException
setShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setInt(java.lang.String parameterName,
int x)
throws java.sql.SQLException
setInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setLong(java.lang.String parameterName,
long x)
throws java.sql.SQLException
setLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setFloat(java.lang.String parameterName,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDouble(java.lang.String parameterName,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setString(java.lang.String parameterName,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBytes(java.lang.String parameterName,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDate(java.lang.String parameterName,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTime(java.lang.String parameterName,
java.sql.Time x)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String parameterName,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getString(java.lang.String parameterName)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic boolean getBoolean(java.lang.String parameterName)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte getByte(java.lang.String parameterName)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic short getShort(java.lang.String parameterName)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic int getInt(java.lang.String parameterName)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic long getLong(java.lang.String parameterName)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic float getFloat(java.lang.String parameterName)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic double getDouble(java.lang.String parameterName)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte[] getBytes(java.lang.String parameterName)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String parameterName)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(java.lang.String parameterName)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String parameterName)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String parameterName)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(java.lang.String parameterName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String parameterName,
java.util.Map map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Ref getRef(java.lang.String parameterName)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Blob getBlob(java.lang.String parameterName)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Clob getClob(java.lang.String parameterName)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Array getArray(java.lang.String parameterName)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.net.URL getURL(java.lang.String parameterName)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.RowId getRowId(int parameterIndex)
throws java.sql.SQLException
ROWID parameter as a
java.sql.RowId object.getRowId in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2,...RowId object that represents the JDBC ROWID
value is used as the designated parameter. If the parameter contains
a SQL NULL, then a null value is returned.java.sql.SQLException - if the parameterIndex is not valid;
if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.RowId getRowId(java.lang.String parameterName)
throws java.sql.SQLException
ROWID parameter as a
java.sql.RowId object.getRowId in interface java.sql.CallableStatementparameterName - the name of the parameterRowId object that represents the JDBC ROWID
value is used as the designated parameter. If the parameter contains
a SQL NULL, then a null value is returned.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setRowId(java.lang.String parameterName,
java.sql.RowId x)
throws java.sql.SQLException
java.sql.RowId object. The
driver converts this to a SQL ROWID when it sends it to the
database.setRowId in interface java.sql.CallableStatementparameterName - the name of the parameterx - the parameter valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setNString(java.lang.String parameterName,
java.lang.String value)
throws java.sql.SQLException
String object.
The driver converts this to a SQL NCHAR or
NVARCHAR or LONGNVARCHARsetNString in interface java.sql.CallableStatementparameterName - the name of the parameter to be setvalue - the parameter valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
throws java.sql.SQLException
Reader object. The
Reader reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.setNCharacterStream in interface java.sql.CallableStatementparameterName - the name of the parameter to be setvalue - the parameter valuelength - the number of characters in the parameter data.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setNClob(java.lang.String parameterName,
java.sql.NClob value)
throws java.sql.SQLException
java.sql.NClob object. The object
implements the java.sql.NClob interface. This NClob
object maps to a SQL NCLOB.setNClob in interface java.sql.CallableStatementparameterName - the name of the parameter to be setvalue - the parameter valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader object. The reader must contain the number
of characters specified by length otherwise a SQLException will be
generated when the CallableStatement is executed.
This method differs from the setCharacterStream (int, Reader, int) method
because it informs the driver that the parameter value should be sent to
the server as a CLOB. When the setCharacterStream method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGVARCHAR or a CLOBsetClob in interface java.sql.CallableStatementparameterName - the name of the parameter to be setreader - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if the length specified is less than zero;
a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
InputStream object. The inputstream must contain the number
of characters specified by length, otherwise a SQLException will be
generated when the CallableStatement is executed.
This method differs from the setBinaryStream (int, InputStream, int)
method because it informs the driver that the parameter value should be
sent to the server as a BLOB. When the setBinaryStream method is used,
the driver may have to do extra work to determine whether the parameter
data should be sent to the server as a LONGVARBINARY or a BLOBsetBlob in interface java.sql.CallableStatementparameterName - the name of the parameter to be set
the second is 2, ...inputStream - An object that contains the data to set the parameter
value to.length - the number of bytes in the parameter data.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if the length specified
is less than zero; if the number of bytes in the inputstream does not match
the specfied length; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader object. The reader must contain the number
of characters specified by length otherwise a SQLException will be
generated when the CallableStatement is executed.
This method differs from the setCharacterStream (int, Reader, int) method
because it informs the driver that the parameter value should be sent to
the server as a NCLOB. When the setCharacterStream method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGNVARCHAR or a NCLOBsetNClob in interface java.sql.CallableStatementparameterName - the name of the parameter to be setreader - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if the length specified is less than zero;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.NClob getNClob(int parameterIndex)
throws java.sql.SQLException
NCLOB parameter as a
java.sql.NClob object in the Java programming language.getNClob in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, and
so onNClob object in the
Java programming language. If the value was SQL NULL, the
value null is returned.java.sql.SQLException - if the parameterIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.NClob getNClob(java.lang.String parameterName)
throws java.sql.SQLException
NCLOB parameter as a
java.sql.NClob object in the Java programming language.getNClob in interface java.sql.CallableStatementparameterName - the name of the parameterNClob object in the
Java programming language. If the value was SQL NULL,
the value null is returned.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
java.sql.SQLXML object. The driver converts this to an
SQL XML value when it sends it to the database.setSQLXML in interface java.sql.CallableStatementparameterName - the name of the parameterxmlObject - a SQLXML object that maps an SQL XML valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs;
this method is called on a closed CallableStatement or
the java.xml.transform.Result,
Writer or OutputStream has not been closed for the SQLXML objectjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.SQLXML getSQLXML(int parameterIndex)
throws java.sql.SQLException
SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.getSQLXML in interface java.sql.CallableStatementparameterIndex - index of the first parameter is 1, the second is 2, ...SQLXML object that maps an SQL XML valuejava.sql.SQLException - if the parameterIndex is not valid;
if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.SQLXML getSQLXML(java.lang.String parameterName)
throws java.sql.SQLException
SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.getSQLXML in interface java.sql.CallableStatementparameterName - the name of the parameterSQLXML object that maps an SQL XML valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.lang.String getNString(int parameterIndex)
throws java.sql.SQLException
NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
For the fixed-length type JDBC NCHAR,
the String object
returned has exactly the same value the SQL
NCHAR value had in the
database, including any padding added by the database.
getNString in interface java.sql.CallableStatementparameterIndex - index of the first parameter is 1, the second is 2, ...String object that maps an
NCHAR, NVARCHAR or LONGNVARCHAR valuejava.sql.SQLException - if the parameterIndex is not valid;
if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodsetNString(java.lang.String, java.lang.String)public java.lang.String getNString(java.lang.String parameterName)
throws java.sql.SQLException
NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
For the fixed-length type JDBC NCHAR,
the String object
returned has exactly the same value the SQL
NCHAR value had in the
database, including any padding added by the database.
getNString in interface java.sql.CallableStatementparameterName - the name of the parameterString object that maps an
NCHAR, NVARCHAR or LONGNVARCHAR valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter;
if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodsetNString(java.lang.String, java.lang.String)public java.io.Reader getNCharacterStream(int parameterIndex)
throws java.sql.SQLException
java.io.Reader object in the Java programming language.
It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR parameters.getNCharacterStream in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming language.java.sql.SQLException - if the parameterIndex is not valid;
if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.io.Reader getNCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
java.io.Reader object in the Java programming language.
It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR parameters.getNCharacterStream in interface java.sql.CallableStatementparameterName - the name of the parameterjava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming languagejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.io.Reader getCharacterStream(int parameterIndex)
throws java.sql.SQLException
java.io.Reader object in the Java programming language.getCharacterStream in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, ...java.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming language.java.sql.SQLException - if the parameterIndex is not valid; if a database access error occurs or
this method is called on a closed CallableStatementpublic java.io.Reader getCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
java.io.Reader object in the Java programming language.getCharacterStream in interface java.sql.CallableStatementparameterName - the name of the parameterjava.io.Reader object that contains the parameter
value; if the value is SQL NULL, the value returned is
null in the Java programming languagejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setBlob(java.lang.String parameterName,
java.sql.Blob x)
throws java.sql.SQLException
java.sql.Blob object.
The driver converts this to an SQL BLOB value when it
sends it to the database.setBlob in interface java.sql.CallableStatementparameterName - the name of the parameterx - a Blob object that maps an SQL BLOB valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setClob(java.lang.String parameterName,
java.sql.Clob x)
throws java.sql.SQLException
java.sql.Clob object.
The driver converts this to an SQL CLOB value when it
sends it to the database.setClob in interface java.sql.CallableStatementparameterName - the name of the parameterx - a Clob object that maps an SQL CLOB valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream in interface java.sql.CallableStatementparameterName - the name of the parameterx - the Java input stream that contains the ASCII parameter valuelength - the number of bytes in the streamjava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream object. The data will be read from the stream
as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setBinaryStream in interface java.sql.CallableStatementparameterName - the name of the parameterx - the java input stream which contains the binary parameter valuelength - the number of bytes in the streamjava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setCharacterStream in interface java.sql.CallableStatementparameterName - the name of the parameterreader - the java.io.Reader object that
contains the UNICODE data used as the designated parameterlength - the number of characters in the streamjava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setAsciiStream which takes a length parameter.
setAsciiStream in interface java.sql.CallableStatementparameterName - the name of the parameterx - the Java input stream that contains the ASCII parameter valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream object. The data will be read from the
stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBinaryStream which takes a length parameter.
setBinaryStream in interface java.sql.CallableStatementparameterName - the name of the parameterx - the java input stream which contains the binary parameter valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
Reader
object.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setCharacterStream which takes a length parameter.
setCharacterStream in interface java.sql.CallableStatementparameterName - the name of the parameterreader - the java.io.Reader object that contains the
Unicode datajava.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
throws java.sql.SQLException
Reader object. The
Reader reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNCharacterStream which takes a length parameter.
setNCharacterStream in interface java.sql.CallableStatementparameterName - the name of the parametervalue - the parameter valuejava.sql.SQLException - if parameterName does not correspond to a named
parameter; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; if a database access error occurs; or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic void setClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
Reader object.
This method differs from the setCharacterStream (int, Reader) method
because it informs the driver that the parameter value should be sent to
the server as a CLOB. When the setCharacterStream method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGVARCHAR or a CLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setClob which takes a length parameter.
setClob in interface java.sql.CallableStatementparameterName - the name of the parameterreader - An object that contains the data to set the parameter value to.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or this method is called on
a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
throws java.sql.SQLException
InputStream object.
This method differs from the setBinaryStream (int, InputStream)
method because it informs the driver that the parameter value should be
sent to the server as a BLOB. When the setBinaryStream method is used,
the driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGVARBINARY or a BLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBlob which takes a length parameter.
setBlob in interface java.sql.CallableStatementparameterName - the name of the parameterinputStream - An object that contains the data to set the parameter
value to.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic void setNClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
Reader object.
This method differs from the setCharacterStream (int, Reader) method
because it informs the driver that the parameter value should be sent to
the server as a NCLOB. When the setCharacterStream method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGNVARCHAR or a NCLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNClob which takes a length parameter.
setNClob in interface java.sql.CallableStatementparameterName - the name of the parameterreader - An object that contains the data to set the parameter value to.java.sql.SQLException - if parameterName does not correspond to a named
parameter; if the driver does not support national character sets;
if the driver can detect that a data conversion
error could occur; if a database access error occurs or
this method is called on a closed CallableStatementjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this methodpublic <T> T getObject(int parameterIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
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. If the conversion is not
supported or null is specified for the type, a
SQLException is thrown.
At a minimum, an implementation must support the conversions defined in
Appendix B, Table B-3 and conversion of appropriate user defined SQL
types to a Java type which implements SQLData, or Struct.
Additional conversions may be supported and are vendor defined.
getObject in interface java.sql.CallableStatementparameterIndex - the first parameter is 1, the second is 2, and so ontype - Class representing the Java data type to convert the
designated parameter to.type holding the OUT parameter valuejava.sql.SQLException - if conversion is not supported, type is null or
another error occurs. The getCause() method of the
exception may provide a more detailed exception, for example, if
a conversion error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic <T> T getObject(java.lang.String parameterName,
java.lang.Class<T> type)
throws java.sql.SQLException
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. If the conversion is not
supported or null is specified for the type, a
SQLException is thrown.
At a minimum, an implementation must support the conversions defined in
Appendix B, Table B-3 and conversion of appropriate user defined SQL
types to a Java type which implements SQLData, or Struct.
Additional conversions may be supported and are vendor defined.
getObject in interface java.sql.CallableStatementparameterName - the name of the parametertype - Class representing the Java data type to convert
the designated parameter to.type holding the OUT parameter
valuejava.sql.SQLException - if conversion is not supported, type is null or
another error occurs. The getCause() method of the
exception may provide a more detailed exception, for example, if
a conversion error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this method