|
Foundation |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.sas.rio.MVACallableStatement
public class MVACallableStatement
Note: None of the methods in this class are supported because SAS software does not support stored procedures. All methods in this class throw a SQLException.
Field Summary |
---|
Fields inherited from class com.sas.rio.MVAStatement |
---|
_currentResultSet, describe, librefs, m_sasifyTableNames, maxFieldSize |
Method Summary | |
---|---|
java.sql.Array |
getArray(int i)
JDBC 2.0 Gets an Array OUT parameter. |
java.sql.Array |
getArray(java.lang.String parameterName)
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex)
Deprecated. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated. |
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName)
Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains. |
java.sql.Blob |
getBlob(int i)
JDBC 2.0 Gets a BLOB OUT parameter. |
java.sql.Blob |
getBlob(java.lang.String parameterName)
Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language. |
boolean |
getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language. |
boolean |
getBoolean(java.lang.String parameterName)
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language. |
byte |
getByte(int parameterIndex)
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language. |
byte |
getByte(java.lang.String parameterName)
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language. |
byte[] |
getBytes(int parameterIndex)
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. |
byte[] |
getBytes(java.lang.String parameterName)
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. |
java.io.Reader |
getCharacterStream(int parameterIndex)
This method is not supported. |
java.io.Reader |
getCharacterStream(java.lang.String parameterName)
This method is not supported. |
java.sql.Clob |
getClob(int i)
JDBC 2.0 Gets a CLOB OUT parameter. |
java.sql.Clob |
getClob(java.lang.String parameterName)
Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming language. |
java.sql.Date |
getDate(int parameterIndex)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. |
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal)
Gets the value of a SQL DATE parameter as a java.sql.Date object. |
java.sql.Date |
getDate(java.lang.String parameterName)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. |
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. |
double |
getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language. |
double |
getDouble(java.lang.String parameterName)
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language. |
float |
getFloat(int parameterIndex)
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language. |
float |
getFloat(java.lang.String parameterName)
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language. |
int |
getInt(int parameterIndex)
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language. |
int |
getInt(java.lang.String parameterName)
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language. |
long |
getLong(int parameterIndex)
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language. |
long |
getLong(java.lang.String parameterName)
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language. |
java.io.Reader |
getNCharacterStream(int parameterIndex)
This method is not supported. |
java.io.Reader |
getNCharacterStream(java.lang.String parameterName)
This method is not supported. |
java.sql.NClob |
getNClob(int parameterIndex)
This method is not supported. |
java.sql.NClob |
getNClob(java.lang.String parameterName)
This method is not supported. |
java.lang.String |
getNString(int parameterIndex)
This method is not supported. |
java.lang.String |
getNString(java.lang.String parameterName)
This method is not supported. |
java.lang.Object |
getObject(int parameterIndex)
Retrieves the value of the designated parameter as an Object in the Java programming language. |
java.lang.Object |
getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
JDBC 2.0 Gets an object representing the value of OUT parameter @i. |
java.lang.Object |
getObject(java.lang.String parameterName)
Retrieves the value of the designated parameter as an Object in the Java programming language. |
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
Retrieves the value of the designated parameter as an Object in the Java programming language. |
java.sql.Ref |
getRef(int i)
JDBC 2.0 Gets a REF(<structured-type>) OUT parameter. |
java.sql.Ref |
getRef(java.lang.String parameterName)
Retrieves the value of the designated JDBC REF( |
java.sql.RowId |
getRowId(int parameterIndex)
This method is not supported. |
java.sql.RowId |
getRowId(java.lang.String parameterName)
This method is not supported. |
short |
getShort(int parameterIndex)
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language. |
short |
getShort(java.lang.String parameterName)
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language. |
java.sql.SQLXML |
getSQLXML(int parameterIndex)
This method is not supported. |
java.sql.SQLXML |
getSQLXML(java.lang.String parameterName)
This method is not supported. |
java.lang.String |
getString(int parameterIndex)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
java.lang.String |
getString(java.lang.String parameterName)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
java.sql.Time |
getTime(int parameterIndex)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. |
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal)
Gets the value of a SQL TIME parameter as a java.sql.Time object. |
java.sql.Time |
getTime(java.lang.String parameterName)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. |
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. |
java.sql.Timestamp |
getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal)
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. |
java.net.URL |
getURL(int parameterIndex)
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object. |
java.net.URL |
getURL(java.lang.String parameterName)
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object. |
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 OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String x)
JDBC 2.0 This method is not yet supported. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
This method is not supported. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
This method is not supported. |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
This method is not supported. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
This method is not supported. |
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x)
This method is not supported. |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
This method is not supported. |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
This method is not supported. |
void |
setBoolean(java.lang.String parameterName,
boolean x)
Sets the designated parameter to the given Java boolean value. |
void |
setByte(java.lang.String parameterName,
byte x)
Sets the designated parameter to the given Java byte value. |
void |
setBytes(java.lang.String parameterName,
byte[] x)
Sets the designated parameter to the given Java array of bytes. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
This method is not supported. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length)
Sets the designated parameter to the given Reader object, which is the given number of characters long. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length)
This method is not supported. |
void |
setClob(java.lang.String parameterName,
java.sql.Clob x)
This method is not supported. |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader)
This method is not supported. |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
This method is not supported. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x)
Sets the designated parameter to the given java.sql.Date value. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Date value. |
void |
setDouble(java.lang.String parameterName,
double x)
Sets the designated parameter to the given Java double value. |
void |
setFloat(java.lang.String parameterName,
float x)
Sets the designated parameter to the given Java float value. |
void |
setInt(java.lang.String parameterName,
int x)
Sets the designated parameter to the given Java int value. |
void |
setLong(java.lang.String parameterName,
long x)
Sets the designated parameter to the given Java long value. |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
This method is not supported. |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
This method is not supported. |
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value)
This method is not supported. |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader)
This method is not supported. |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
This method is not supported. |
void |
setNString(java.lang.String parameterName,
java.lang.String value)
This method is not supported. |
void |
setNull(java.lang.String parameterName,
int sqlType)
Sets the designated parameter to SQL NULL. |
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Sets the designated parameter to SQL NULL. |
void |
setObject(java.lang.String parameterName,
java.lang.Object x)
Sets the value of the designated parameter with the given object. |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object. |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object. |
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x)
This method is not supported. |
void |
setShort(java.lang.String parameterName,
short x)
Sets the designated parameter to the given Java short value. |
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject)
This method is not supported. |
void |
setString(java.lang.String parameterName,
java.lang.String x)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. |
void |
setTime(java.lang.String parameterName,
java.sql.Time x)
Sets the designated parameter to the given java.sql.Time value. |
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Time value. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value. |
void |
setURL(java.lang.String parameterName,
java.net.URL val)
Sets the designated parameter to the given java.net.URL object. |
boolean |
wasNull()
Retrieves whether the last OUT parameter read had the value of SQL NULL. |
Methods inherited from class com.sas.rio.MVAPreparedStatement |
---|
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL |
Method Detail |
---|
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String x) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- The parameter index. The first parameter is 1, the
second parameter is 2, and so on.sqlType
- An SQL type code that is defined by java.sql.Types.x
- An input String.
java.sql.SQLException
- This exception is always thrown.public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
i
- the first parameter is 1, the second is 2, ...map
- the mapping from SQL type names to Java classes
java.sql.SQLException
- This exception is always thrown.public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
i
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Blob getBlob(int i) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
i
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
i
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
i
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, ...
java.sql.SQLException
- This exception is always thrown.public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public int getInt(java.lang.String parameterName) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public long getLong(java.lang.String parameterName) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public short getShort(java.lang.String parameterName) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
- This exception is always thrown.public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated JDBC ROWID
parameter
as a java.sql.RowId
object.
getRowId
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2,...
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of the designated JDBC ROWID
parameter
as a java.sql.RowId
object.
getRowId
in interface java.sql.CallableStatement
parameterName
- the name of the parameter
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
Sets the designated parameter to the given java.sql.RowId
object. The driver converts this to a SQL ROWID
when it
sends it to the database.
setRowId
in interface java.sql.CallableStatement
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
Sets the designated parameter to the given String
object.
The driver converts this to a SQL NCHAR
or
NVARCHAR
or LONGNVARCHAR
setNString
in interface java.sql.CallableStatement
parameterName
- the name of the parameter to be setvalue
- the parameter value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
Sets the designated parameter to a 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.CallableStatement
parameterName
- the name of the parameter to be setvalue
- the parameter valuelength
- the number of characters in the parameter data.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
Sets the designated parameter to a 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.CallableStatement
parameterName
- the name of the parameter to be setvalue
- the parameter value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
Sets the designated parameter to a 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 CLOB
setClob
in interface java.sql.CallableStatement
parameterName
- 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
- Always thrown, to indicate that this method is
not implemented.
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
Sets the designated parameter to a 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 BLOB
setBlob
in interface java.sql.CallableStatement
parameterName
- 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
- Always thrown, to indicate that this method is
not implemented.
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
Sets the designated parameter to a 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 NCLOB
setNClob
in interface java.sql.CallableStatement
parameterName
- 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
- Always thrown, to indicate that this method is
not implemented.
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated JDBC NCLOB
parameter
as a java.sql.NClob
object in the Java programming language.
getNClob
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, and so
on Java programming language. If the value was SQL
NULL
, the value null
is returned.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBC NCLOB
parameter as a
java.sql.NClob
object in the Java programming language.
getNClob
in interface java.sql.CallableStatement
parameterName
- the name of the parameter
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
Sets the designated parameter to the given 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.CallableStatement
parameterName
- the name of the parameterxmlObject
- a SQLXML
object that maps an
SQL XML
value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated SQL XML
parameter as a
java.sql.SQLXML
object in the Java programming language.
getSQLXML
in interface java.sql.CallableStatement
parameterIndex
- index of the first parameter is 1, the second is 2,
...
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of the designated SQL XML
parameter as a
java.sql.SQLXML
object in the Java programming language.
getSQLXML
in interface java.sql.CallableStatement
parameterName
- the name of the parameter
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated 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.CallableStatement
parameterIndex
- index of the first parameter is 1, the second is 2,
...
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
setNString(java.lang.String, java.lang.String)
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of the designated 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.CallableStatement
parameterName
- the name of the parameter
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
setNString(java.lang.String, java.lang.String)
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated parameter as a
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.CallableStatement
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of the designated parameter as a
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.CallableStatement
parameterName
- the name of the parameter
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated parameter as a
java.io.Reader
object in the Java programming language.
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of the designated parameter as a
java.io.Reader
object in the Java programming language.
getCharacterStream
in interface java.sql.CallableStatement
parameterName
- the name of the parameter
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
Sets the designated parameter to the given 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.CallableStatement
parameterName
- the name of the parameterx
- a Blob
object that maps an SQL BLOB
value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
Sets the designated parameter to the given 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.CallableStatement
parameterName
- the name of the parameterx
- a Clob
object that maps an SQL CLOB
value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have
the specified number of bytes. When a very large ASCII value is input to
a 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.CallableStatement
parameterName
- the name of the parameterx
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have
the specified number of bytes. When a very large binary value is input to
a 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.CallableStatement
parameterName
- the name of the parameterx
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
Sets the designated parameter to the given 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.CallableStatement
parameterName
- 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 stream
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
Sets the designated parameter to the given input stream. When a very
large ASCII value is input to a 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.CallableStatement
parameterName
- the name of the parameterx
- the Java input stream that contains the ASCII parameter value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
Sets the designated parameter to the given input stream. When a very
large binary value is input to a 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.CallableStatement
parameterName
- the name of the parameterx
- the java input stream which contains the binary parameter value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
Sets the designated parameter to the given 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.CallableStatement
parameterName
- the name of the parameterreader
- the java.io.Reader
object that contains the
Unicode data
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
Sets the designated parameter to a 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.CallableStatement
parameterName
- the name of the parametervalue
- the parameter value
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
Sets the designated parameter to a 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.CallableStatement
parameterName
- the name of the parameterreader
- An object that contains the data to set the parameter value
to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
Sets the designated parameter to a 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.CallableStatement
parameterName
- the name of the parameterinputStream
- An object that contains the data to set the parameter
value to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
Sets the designated parameter to a 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.CallableStatement
parameterName
- the name of the parameterreader
- An object that contains the data to set the parameter value
to.
java.sql.SQLException
- Always thrown, to indicate that this method is
not implemented.
|
Foundation |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |