com.sas.net.sharenet
Class ShareNetCallableStatement

com.sas.net.sharenet.ShareNetCallableStatement
All Implemented Interfaces:
java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

public class ShareNetCallableStatement
implements java.sql.CallableStatement

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.

See Also:
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.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.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() parameter as a Ref object in the Java programming language.
 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.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, int length)
          Sets the designated parameter to the given input stream, which will have the specified number of bytes.
 void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)
          Sets the designated parameter to the given java.math.BigDecimal value.
 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 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, int length)
          Sets the designated parameter to the given Reader object, which is the given number of characters long.
 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 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 setShort(java.lang.String parameterName, short x)
          Sets the designated parameter to the given Java short value.
 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, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
 
Methods inherited from class com.sas.net.sharenet.ShareNetStatement
addBatch, addWarning, cancel, clearBatch, clearWarnings, close, describe, destroy, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, fieldFormat, fieldNames, fieldType, finalize, findFirstString, getAns, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getVars, getWarnings, isDescribe, numFields, prepare, prepareDescribe, setCursorName, setDescribe, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, setVars
 

Method Detail

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType)
                          throws java.sql.SQLException
Registers the designated output parameter. This method is not supported.

Specified by:
registerOutParameter in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType,
                                 int scale)
                          throws java.sql.SQLException
Registers the designated output parameter. This method is not supported.

Specified by:
registerOutParameter in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType,
                                 java.lang.String typeName)
                          throws java.sql.SQLException
Registers the designated output parameter. This method is not supported.

Specified by:
registerOutParameter in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Retrieves whether the last OUT parameter read had the value of SQL NULL. This method is not supported.

Specified by:
wasNull in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getString

public java.lang.String getString(int parameterIndex)
                           throws java.sql.SQLException
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. This method is not supported.

Specified by:
getString in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBoolean

public boolean getBoolean(int parameterIndex)
                   throws java.sql.SQLException
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language. This method is not supported.

Specified by:
getBoolean in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getByte

public byte getByte(int parameterIndex)
             throws java.sql.SQLException
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language. This method is not supported.

Specified by:
getByte in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getShort

public short getShort(int parameterIndex)
               throws java.sql.SQLException
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language. This method is not supported.

Specified by:
getShort in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getInt

public int getInt(int parameterIndex)
           throws java.sql.SQLException
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language. This method is not supported.

Specified by:
getInt in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getLong

public long getLong(int parameterIndex)
             throws java.sql.SQLException
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language. This method is not supported.

Specified by:
getLong in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getFloat

public float getFloat(int parameterIndex)
               throws java.sql.SQLException
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language. This method is not supported.

Specified by:
getFloat in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getDouble

public double getDouble(int parameterIndex)
                 throws java.sql.SQLException
Retrieves the value of the designated JDBC DOUBLE parameter as a float in the Java programming language. This method is not supported.

Specified by:
getDouble in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int parameterIndex,
                                          int scale)
                                   throws java.sql.SQLException
Deprecated. 

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point. This method is not supported.

Specified by:
getBigDecimal in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBytes

public byte[] getBytes(int parameterIndex)
                throws java.sql.SQLException
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. This method is not supported.

Specified by:
getBytes in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getDate

public java.sql.Date getDate(int parameterIndex)
                      throws java.sql.SQLException
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. This method is not supported.

Specified by:
getDate in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getTime

public java.sql.Time getTime(int parameterIndex)
                      throws java.sql.SQLException
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. This method is not supported.

Specified by:
getTime in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getTimestamp

public java.sql.Timestamp getTimestamp(int parameterIndex)
                                throws java.sql.SQLException
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. This method is not supported.

Specified by:
getTimestamp in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getObject

public java.lang.Object getObject(int parameterIndex)
                           throws java.sql.SQLException
Retrieves the value of the designated parameter as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null. This method is not supported.

Specified by:
getObject in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int parameterIndex)
                                   throws java.sql.SQLException
Deprecated. 

JDBC 2.0 Gets the value of a NUMERIC parameter as a java.math.BigDecimal object. This method is not supported.

Specified by:
getBigDecimal in interface java.sql.CallableStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Returns:
the parameter value (full precision); if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - This exception is always thrown.

getObject

public java.lang.Object getObject(int i,
                                  java.util.Map map)
                           throws java.sql.SQLException
JDBC 2.0 Gets an object representing the value of OUT parameter @i. Use the @map to determine the class from which to construct data of SQL structured and distinct types. This method is not supported.

Specified by:
getObject in interface java.sql.CallableStatement
Parameters:
i - the first parameter is 1, the second is 2, ...
map - the mapping from SQL type names to Java classes
Returns:
a java.lang.Object holding the OUT parameter value.
Throws:
java.sql.SQLException - This exception is always thrown.

getRef

public java.sql.Ref getRef(int i)
                    throws java.sql.SQLException
JDBC 2.0 Gets a REF(<structured-type>) OUT parameter. This method is not supported.

Specified by:
getRef in interface java.sql.CallableStatement
Parameters:
i - the first parameter is 1, the second is 2, ...
Returns:
an object representing data of an SQL REF Type
Throws:
java.sql.SQLException - This exception is always thrown.

getBlob

public java.sql.Blob getBlob(int i)
                      throws java.sql.SQLException
JDBC 2.0 Gets a BLOB OUT parameter. This method is not supported.

Specified by:
getBlob in interface java.sql.CallableStatement
Parameters:
i - the first parameter is 1, the second is 2, ...
Returns:
an object representing a BLOB
Throws:
java.sql.SQLException - This exception is always thrown.

getClob

public java.sql.Clob getClob(int i)
                      throws java.sql.SQLException
JDBC 2.0 Gets a CLOB OUT parameter. This method is not supported.

Specified by:
getClob in interface java.sql.CallableStatement
Parameters:
i - the first parameter is 1, the second is 2, ...
Returns:
an object representing a CLOB
Throws:
java.sql.SQLException - This exception is always thrown.

getArray

public java.sql.Array getArray(int i)
                        throws java.sql.SQLException
JDBC 2.0 Gets an Array OUT parameter. This method is not supported.

Specified by:
getArray in interface java.sql.CallableStatement
Parameters:
i - the first parameter is 1, the second is 2, ...
Returns:
an object representing an SQL array
Throws:
java.sql.SQLException - This exception is always thrown.

getDate

public java.sql.Date getDate(int parameterIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Gets the value of a SQL DATE parameter as a java.sql.Date object. This method is not supported.

Specified by:
getDate in interface java.sql.CallableStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Returns:
the parameter value; if the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException - This exception is always thrown.

getTime

public java.sql.Time getTime(int parameterIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Gets the value of a SQL TIME parameter as a java.sql.Time object. This method is not supported.

Specified by:
getTime in interface java.sql.CallableStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Returns:
the parameter value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - This exception is always thrown.

getTimestamp

public java.sql.Timestamp getTimestamp(int parameterIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object. This method is not supported.

Specified by:
getTimestamp in interface java.sql.CallableStatement
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Returns:
the parameter value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - This exception is always thrown.

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                                 int sqlType)
                          throws java.sql.SQLException
Registers the designated output parameter. This method is not supported.

Specified by:
registerOutParameter in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                                 int sqlType,
                                 int scale)
                          throws java.sql.SQLException
Registers the designated output parameter. This method is not supported.

Specified by:
registerOutParameter in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                                 int sqlType,
                                 java.lang.String typeName)
                          throws java.sql.SQLException
Registers the designated output parameter. This method is not supported.

Specified by:
registerOutParameter in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getURL

public java.net.URL getURL(int parameterIndex)
                    throws java.sql.SQLException
Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object. This method is not supported.

Specified by:
getURL in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setURL

public void setURL(java.lang.String parameterName,
                   java.net.URL val)
            throws java.sql.SQLException
Sets the designated parameter to the given java.net.URL object. The driver converts this to an SQL DATALINK value when it sends it to the database. This method is not supported.

Specified by:
setURL in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setNull

public void setNull(java.lang.String parameterName,
                    int sqlType)
             throws java.sql.SQLException
Sets the designated parameter to SQL NULL. This method is not supported.

Specified by:
setNull in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setBoolean

public void setBoolean(java.lang.String parameterName,
                       boolean x)
                throws java.sql.SQLException
Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT value when it sends it to the database. This method is not supported.

Specified by:
setBoolean in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setByte

public void setByte(java.lang.String parameterName,
                    byte x)
             throws java.sql.SQLException
Sets the designated parameter to the given Java byte value. The driver converts this to an SQL TINYINT value when it sends it to the database. This method is not supported.

Specified by:
setByte in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setShort

public void setShort(java.lang.String parameterName,
                     short x)
              throws java.sql.SQLException
Sets the designated parameter to the given Java short value. The driver converts this to an SQL SMALLINT value when it sends it to the database. This method is not supported.

Specified by:
setShort in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setInt

public void setInt(java.lang.String parameterName,
                   int x)
            throws java.sql.SQLException
Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database. This method is not supported.

Specified by:
setInt in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setLong

public void setLong(java.lang.String parameterName,
                    long x)
             throws java.sql.SQLException
Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database. This method is not supported.

Specified by:
setLong in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setFloat

public void setFloat(java.lang.String parameterName,
                     float x)
              throws java.sql.SQLException
Sets the designated parameter to the given Java float value. The driver converts this to an SQL FLOAT value when it sends it to the database. This method is not supported.

Specified by:
setFloat in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setDouble

public void setDouble(java.lang.String parameterName,
                      double x)
               throws java.sql.SQLException
Sets the designated parameter to the given Java double value. The driver converts this to an SQL DOUBLE value when it sends it to the database. This method is not supported.

Specified by:
setDouble in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setBigDecimal

public void setBigDecimal(java.lang.String parameterName,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException
Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database. This method is not supported.

Specified by:
setBigDecimal in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setString

public void setString(java.lang.String parameterName,
                      java.lang.String x)
               throws java.sql.SQLException
Sets the designated parameter to the given Java String value. The driver converts this to an SQL VARCHAR or LONGVARCHAR value (depending on the argument's size relative to the driver's limits on VARCHAR values) when it sends it to the database. This method is not supported.

Specified by:
setString in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setBytes

public void setBytes(java.lang.String parameterName,
                     byte[] x)
              throws java.sql.SQLException
Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL VARBINARY or LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values) when it sends it to the database. This method is not supported.

Specified by:
setBytes in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setDate

public void setDate(java.lang.String parameterName,
                    java.sql.Date x)
             throws java.sql.SQLException
Sets the designated parameter to the given java.sql.Date value. The driver converts this to an SQL DATE value when it sends it to the database. This method is not supported.

Specified by:
setDate in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setTime

public void setTime(java.lang.String parameterName,
                    java.sql.Time x)
             throws java.sql.SQLException
Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database. This method is not supported.

Specified by:
setTime in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setTimestamp

public void setTimestamp(java.lang.String parameterName,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException
Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database. This method is not supported.

Specified by:
setTimestamp in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setAsciiStream

public void setAsciiStream(java.lang.String parameterName,
                           java.io.InputStream x,
                           int length)
                    throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes. Sets the designated parameter to the given input stream, which will have the specified number of bytes. This method is not supported.

Specified by:
setAsciiStream in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setBinaryStream

public void setBinaryStream(java.lang.String parameterName,
                            java.io.InputStream x,
                            int length)
                     throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes. This method is not supported.

Specified by:
setBinaryStream in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setObject

public void setObject(java.lang.String parameterName,
                      java.lang.Object x,
                      int targetSqlType,
                      int scale)
               throws java.sql.SQLException
Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the java.lang equivalent objects should be used. This method is not supported.

Specified by:
setObject in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setObject

public void setObject(java.lang.String parameterName,
                      java.lang.Object x,
                      int targetSqlType)
               throws java.sql.SQLException
Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero. This method is not supported.

Specified by:
setObject in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setObject

public void setObject(java.lang.String parameterName,
                      java.lang.Object x)
               throws java.sql.SQLException
Sets the value of the designated parameter with the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types. This method is not supported.

Specified by:
setObject in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setCharacterStream

public void setCharacterStream(java.lang.String parameterName,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException
Sets the designated parameter to the given Reader object, which is the given number of characters long. This method is not supported.

Specified by:
setCharacterStream in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setDate

public void setDate(java.lang.String parameterName,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database This method is not supported.

Specified by:
setDate in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setTime

public void setTime(java.lang.String parameterName,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIME value, which the driver then sends to the database. This method is not supported.

Specified by:
setTime in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setTimestamp

public void setTimestamp(java.lang.String parameterName,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIMESTAMP value, which the driver then sends to the database. This method is not supported.

Specified by:
setTimestamp in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

setNull

public void setNull(java.lang.String parameterName,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException
Sets the designated parameter to SQL NULL. This method is not supported.

Specified by:
setNull in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getString

public java.lang.String getString(java.lang.String parameterName)
                           throws java.sql.SQLException
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language. This method is not supported.

Specified by:
getString in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBoolean

public boolean getBoolean(java.lang.String parameterName)
                   throws java.sql.SQLException
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language. This method is not supported.

Specified by:
getBoolean in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getByte

public byte getByte(java.lang.String parameterName)
             throws java.sql.SQLException
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language. This method is not supported.

Specified by:
getByte in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getShort

public short getShort(java.lang.String parameterName)
               throws java.sql.SQLException
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language. This method is not supported.

Specified by:
getShort in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getInt

public int getInt(java.lang.String parameterName)
           throws java.sql.SQLException
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language. This method is not supported.

Specified by:
getInt in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getLong

public long getLong(java.lang.String parameterName)
             throws java.sql.SQLException
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language. This method is not supported.

Specified by:
getLong in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getFloat

public float getFloat(java.lang.String parameterName)
               throws java.sql.SQLException
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language. This method is not supported.

Specified by:
getFloat in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getDouble

public double getDouble(java.lang.String parameterName)
                 throws java.sql.SQLException
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language. This method is not supported.

Specified by:
getDouble in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBytes

public byte[] getBytes(java.lang.String parameterName)
                throws java.sql.SQLException
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. This method is not supported.

Specified by:
getBytes in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getDate

public java.sql.Date getDate(java.lang.String parameterName)
                      throws java.sql.SQLException
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object. This method is not supported.

Specified by:
getDate in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getTime

public java.sql.Time getTime(java.lang.String parameterName)
                      throws java.sql.SQLException
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object. This method is not supported.

Specified by:
getTime in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String parameterName)
                                throws java.sql.SQLException
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object. This method is not supported.

Specified by:
getTimestamp in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getObject

public java.lang.Object getObject(java.lang.String parameterName)
                           throws java.sql.SQLException
Retrieves the value of the designated parameter as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null. This method is not supported.

Specified by:
getObject in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String parameterName)
                                   throws java.sql.SQLException
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. This method is not supported.

Specified by:
getBigDecimal in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getObject

public java.lang.Object getObject(java.lang.String parameterName,
                                  java.util.Map map)
                           throws java.sql.SQLException
Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value. This method is not supported.

Specified by:
getObject in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getRef

public java.sql.Ref getRef(java.lang.String parameterName)
                    throws java.sql.SQLException
Retrieves the value of a JDBC REF() parameter as a Ref object in the Java programming language. This method is not supported.

Specified by:
getRef in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getBlob

public java.sql.Blob getBlob(java.lang.String parameterName)
                      throws java.sql.SQLException
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language. This method is not supported.

Specified by:
getBlob in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getClob

public java.sql.Clob getClob(java.lang.String parameterName)
                      throws java.sql.SQLException
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language. This method is not supported.

Specified by:
getClob in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getArray

public java.sql.Array getArray(java.lang.String parameterName)
                        throws java.sql.SQLException
Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language. This method is not supported.

Specified by:
getArray in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getDate

public java.sql.Date getDate(java.lang.String parameterName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. This method is not supported.

Specified by:
getDate in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getTime

public java.sql.Time getTime(java.lang.String parameterName,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. This method is not supported.

Specified by:
getTime in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String parameterName,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object. This method is not supported.

Specified by:
getTimestamp in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.

getURL

public java.net.URL getURL(java.lang.String parameterName)
                    throws java.sql.SQLException
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object. This method is not supported.

Specified by:
getURL in interface java.sql.CallableStatement
Throws:
java.sql.SQLException - This exception is always thrown.



Copyright © 2009 SAS Institute Inc. All Rights Reserved.