|
Components |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.sas.net.sharenet.ShareNetCallableStatement
public class ShareNetCallableStatement
Note: None of the methods in this class are supported because SAS software does not support stored procedures. All methods in this class throw an SQLException.
ShareNetConnection.prepareCall(java.lang.String)
Field Summary |
---|
Fields inherited from class com.sas.net.sharenet.ShareNetStatement |
---|
connection, describe, fetchSize, maxFieldSize, months, msg, snresultset |
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 a 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 a 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 a 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 a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. |
double |
getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a float 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 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 map)
Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value. |
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 a 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 a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. |
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 a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object. |
java.net.URL |
getURL(int parameterIndex)
Retrieves the value of the designated 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 designated output parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the designated output parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
Registers the designated output parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType)
Registers the designated output parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
Registers the designated output parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Registers the designated output parameter. |
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, using the given Calendar object. |
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)
Sets the designated parameter to the given Java String value. |
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, using the given Calendar object. |
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, using the given Calendar object. |
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.net.sharenet.ShareNetPreparedStatement |
---|
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, getResultSetMetaData, 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, int scale) 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 typeName) 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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) throws java.sql.SQLException
setObject
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, java.util.Calendar cal) throws java.sql.SQLException
setDate
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, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
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 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 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 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 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 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 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 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.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.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.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.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.lang.Object getObject(java.lang.String parameterName, java.util.Map 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 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 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.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.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 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.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(java.lang.String parameterName) throws java.sql.SQLException
getURL
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.
|
Components |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |