CallableStatementWrapper40 (Payara Project 5.182 API)

java.lang.Object
- com.sun.gjc.spi.base.StatementWrapper
- - com.sun.gjc.spi.base.PreparedStatementWrapper
  - - com.sun.gjc.spi.base.CallableStatementWrapper
    - - com.sun.gjc.spi.jdbc40.CallableStatementWrapper40

All Implemented Interfaces:

ResultSetClosedEventListener, StatementLeakListener, AutoCloseable, CallableStatement, PreparedStatement, Statement, Wrapper
```
public class CallableStatementWrapper40
extends CallableStatementWrapper
```
Wrapper for JDBC 4.0 CallableStatement

Field Summary
- Fields inherited from class com.sun.gjc.spi.base.CallableStatementWrapper
  callableStatement
- Fields inherited from class com.sun.gjc.spi.base.PreparedStatementWrapper
  preparedStatement
- Fields inherited from class com.sun.gjc.spi.base.StatementWrapper
  _logger, connection, executor, jdbcStatement, leakDetector, resultSetCount
- Fields inherited from interface java.sql.Statement
  CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors
Constructor and Description
`CallableStatementWrapper40(Connection con, CallableStatement statement, boolean cachingEnabled)` Creates a new instance of CallableStatement wrapper for JDBC 3.0

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`ResultSet`	`executeQuery()` Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
`ResultSet`	`executeQuery(String sql)` Executes the given SQL statement, which returns a single `ResultSet` object.
`Reader`	`getCharacterStream(int parameterIndex)` Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
`Reader`	`getCharacterStream(String parameterName)` Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
`ResultSet`	`getGeneratedKeys()` Retrieves any auto-generated keys created as a result of executing this `Statement` object.
`Reader`	`getNCharacterStream(int parameterIndex)` Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
`Reader`	`getNCharacterStream(String parameterName)` Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
`NClob`	`getNClob(int parameterIndex)` Retrieves the value of the designated JDBC `NCLOB` parameter as a `java.sql.NClob` object in the Java programming language.
`NClob`	`getNClob(String parameterName)` Retrieves the value of a JDBC `NCLOB` parameter as a `java.sql.NClob` object in the Java programming language.
`String`	`getNString(int parameterIndex)` Retrieves the value of the designated `NCHAR`, `NVARCHAR` or `LONGNVARCHAR` parameter as a `String` in the Java programming language.
`String`	`getNString(String parameterName)` Retrieves the value of the designated `NCHAR`, `NVARCHAR` or `LONGNVARCHAR` parameter as a `String` in the Java programming language.
`<T> T`	`getObject(int parameterIndex, Class<T> type)`
`<T> T`	`getObject(String parameterName, Class<T> type)`
`ResultSet`	`getResultSet()` Retrieves the current result as a `ResultSet` object.
`RowId`	`getRowId(int parameterIndex)` Retrieves the value of the designated JDBC `ROWID` parameter as a `java.sql.RowId` object.
`RowId`	`getRowId(String parameterName)` Retrieves the value of the designated JDBC `ROWID` parameter as a `java.sql.RowId` object.
`SQLXML`	`getSQLXML(int parameterIndex)` Retrieves the value of the designated `SQL XML` parameter as a `java.sql.SQLXML` object in the Java programming language.
`SQLXML`	`getSQLXML(String parameterName)` Retrieves the value of the designated `SQL XML` parameter as a `java.sql.SQLXML` object in the Java programming language.
`boolean`	`isClosed()` Retrieves whether this `Statement` object has been closed.
`boolean`	`isPoolable()` Returns a value indicating whether the `Statement` is poolable or not.
`boolean`	`isWrapperFor(Class<?> iface)` Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
`void`	`registerOutParameter(int parameterIndex, SQLType sqlType)` Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
`void`	`registerOutParameter(int parameterIndex, SQLType sqlType, int scale)` Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
`void`	`registerOutParameter(int parameterIndex, SQLType sqlType, String typeName)` Registers the designated output parameter.
`void`	`registerOutParameter(String parameterName, SQLType sqlType)` Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
`void`	`registerOutParameter(String parameterName, SQLType sqlType, int scale)` Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
`void`	`registerOutParameter(String parameterName, SQLType sqlType, String typeName)` Registers the designated output parameter.
`void`	`setAsciiStream(int parameterIndex, InputStream x)` Sets the designated parameter to the given input stream.
`void`	`setAsciiStream(int parameterIndex, InputStream x, long length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void`	`setAsciiStream(String parameterName, InputStream x)` Sets the designated parameter to the given input stream.
`void`	`setAsciiStream(String parameterName, InputStream x, long length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void`	`setBinaryStream(int parameterIndex, InputStream x)` Sets the designated parameter to the given input stream.
`void`	`setBinaryStream(int parameterIndex, InputStream x, long length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void`	`setBinaryStream(String parameterName, InputStream x)` Sets the designated parameter to the given input stream.
`void`	`setBinaryStream(String parameterName, InputStream x, long length)` Sets the designated parameter to the given input stream, which will have the specified number of bytes.
`void`	`setBlob(int parameterIndex, InputStream inputStream)` Sets the designated parameter to a `InputStream` object.
`void`	`setBlob(int parameterIndex, InputStream inputStream, long length)` Sets the designated parameter to a `InputStream` object.
`void`	`setBlob(String parameterName, Blob x)` Sets the designated parameter to the given `java.sql.Blob` object.
`void`	`setBlob(String parameterName, InputStream inputStream)` Sets the designated parameter to a `InputStream` object.
`void`	`setBlob(String parameterName, InputStream inputStream, long length)` Sets the designated parameter to a `InputStream` object.
`void`	`setCharacterStream(int parameterIndex, Reader reader)` Sets the designated parameter to the given `Reader` object.
`void`	`setCharacterStream(int parameterIndex, Reader reader, long length)` Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
`void`	`setCharacterStream(String parameterName, Reader reader)` Sets the designated parameter to the given `Reader` object.
`void`	`setCharacterStream(String parameterName, Reader reader, long length)` Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
`void`	`setClob(int parameterIndex, Reader reader)` Sets the designated parameter to a `Reader` object.
`void`	`setClob(int parameterIndex, Reader reader, long length)` Sets the designated parameter to a `Reader` object.
`void`	`setClob(String parameterName, Clob x)` Sets the designated parameter to the given `java.sql.Clob` object.
`void`	`setClob(String parameterName, Reader reader)` Sets the designated parameter to a `Reader` object.
`void`	`setClob(String parameterName, Reader reader, long length)` Sets the designated parameter to a `Reader` object.
`void`	`setNCharacterStream(int parameterIndex, Reader value)` Sets the designated parameter to a `Reader` object.
`void`	`setNCharacterStream(int parameterIndex, Reader value, long length)` Sets the designated parameter to a `Reader` object.
`void`	`setNCharacterStream(String parameterName, Reader value)` Sets the designated parameter to a `Reader` object.
`void`	`setNCharacterStream(String parameterName, Reader value, long length)` Sets the designated parameter to a `Reader` object.
`void`	`setNClob(int parameterIndex, NClob value)` Sets the designated parameter to a `java.sql.NClob` object.
`void`	`setNClob(int parameterIndex, Reader reader)` Sets the designated parameter to a `Reader` object.
`void`	`setNClob(int parameterIndex, Reader reader, long length)` Sets the designated parameter to a `Reader` object.
`void`	`setNClob(String parameterName, NClob reader)` Sets the designated parameter to a `Reader` object.
`void`	`setNClob(String parameterName, Reader reader)` Sets the designated parameter to a `Reader` object.
`void`	`setNClob(String parameterName, Reader reader, long length)` Sets the designated parameter to a `Reader` object.
`void`	`setNString(int parameterIndex, String value)` Sets the designated paramter to the given `String` object.
`void`	`setNString(String parameterName, String value)` Sets the designated parameter to the given `String` object.
`void`	`setObject(String parameterName, Object parameterValue, SQLType targetSqlType)` Sets the value of the designated parameter with the given object.
`void`	`setObject(String parameterName, Object parameterValue, SQLType targetSqlType, int scaleOrLength)` Sets the value of the designated parameter with the given object.
`void`	`setPoolable(boolean poolable)` Requests that a `Statement` be pooled or not pooled.
`void`	`setRowId(int parameterIndex, RowId x)` Sets the designated parameter to the given `java.sql.RowId` object.
`void`	`setRowId(String parameterName, RowId x)` Sets the designated parameter to the given `java.sql.RowId` object.
`void`	`setSQLXML(int parameterIndex, SQLXML xmlObject)` Sets the designated parameter to the given `java.sql.SQLXML` object.
`void`	`setSQLXML(String parameterName, SQLXML xmlObject)` Sets the designated parameter to the given `java.sql.SQLXML` object.
`<T> T`	`unwrap(Class<T> iface)` Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

Methods inherited from class com.sun.gjc.spi.base.CallableStatementWrapper
getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getObject, getObject, getObject, getObject, getRef, getRef, getShort, getShort, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setBigDecimal, setBinaryStream, setBoolean, setByte, setBytes, setCharacterStream, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

Methods inherited from class com.sun.gjc.spi.base.PreparedStatementWrapper
addBatch, clearParameters, close, closeOnCompletion, execute, executeUpdate, getCached, getMetaData, getParameterMetaData, incrementResultSetReferenceCount, isBusy, isCloseOnCompletion, isValid, resultSetClosed, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setBusy, setByte, setBytes, setCached, setCharacterStream, setClob, setDate, setDate, setDouble, setFetchDirection, setFetchSize, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setQueryTimeout, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, setValid

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, executeLargeUpdate, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

- Constructor Detail
  - CallableStatementWrapper40
```
public CallableStatementWrapper40(Connection con,
                                  CallableStatement statement,
                                  boolean cachingEnabled)
                           throws SQLException
```
    Creates a new instance of CallableStatement wrapper for JDBC 3.0
    
    Parameters:
    
    con - ConnectionWrapper
    
    statement - CallableStatement that is wrapped
    
    Throws:
    
    SQLException
- Method Detail
  - getCharacterStream
```
public Reader getCharacterStream(int parameterIndex)
                          throws SQLException
```
    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language.
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    Since:
    
    1.6
  - getCharacterStream
```
public Reader getCharacterStream(String parameterName)
                          throws SQLException
```
    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    Returns:
    
    a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getNCharacterStream
```
public Reader getNCharacterStream(int parameterIndex)
                           throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language.
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getNCharacterStream
```
public Reader getNCharacterStream(String parameterName)
                           throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    Returns:
    
    a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getNClob
```
public NClob getNClob(int parameterIndex)
               throws SQLException
```
    Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, and so on
    
    Returns:
    
    the parameter value as a NClob object in the Java programming language. If the value was SQL NULL, the value null is returned.
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getNClob
```
public NClob getNClob(String parameterName)
               throws SQLException
```
    Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    Returns:
    
    the parameter value as a NClob object in the Java programming language. If the value was SQL NULL, the value null is returned.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getNString
```
public String getNString(int parameterIndex)
                  throws 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.
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    Returns:
    
    a String object that maps an NCHAR, NVARCHAR or LONGNVARCHAR value
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
    
    See Also:
    
    setNString(java.lang.String, java.lang.String)
  - getNString
```
public String getNString(String parameterName)
                  throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    Returns:
    
    a String object that maps an NCHAR, NVARCHAR or LONGNVARCHAR value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
    
    See Also:
    
    setNString(java.lang.String, java.lang.String)
  - getRowId
```
public RowId getRowId(int parameterIndex)
               throws SQLException
```
    Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2,...
    
    Returns:
    
    a RowId object that represents the JDBC ROWID value is used as the designated parameter. If the parameter contains a SQL NULL, then a null value is returned.
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getRowId
```
public RowId getRowId(String parameterName)
               throws SQLException
```
    Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    Returns:
    
    a RowId object that represents the JDBC ROWID value is used as the designated parameter. If the parameter contains a SQL NULL, then a null value is returned.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getSQLXML
```
public SQLXML getSQLXML(int parameterIndex)
                 throws SQLException
```
    Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    Returns:
    
    a SQLXML object that maps an SQL XML value
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - getSQLXML
```
public SQLXML getSQLXML(String parameterName)
                 throws SQLException
```
    Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    Returns:
    
    a SQLXML object that maps an SQL XML value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setAsciiStream
```
public void setAsciiStream(String parameterName,
                           InputStream x)
                    throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - the Java input stream that contains the ASCII parameter value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setAsciiStream
```
public void setAsciiStream(String parameterName,
                           InputStream x,
                           long length)
                    throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - the Java input stream that contains the ASCII parameter value
    
    length - the number of bytes in the stream
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBinaryStream
```
public void setBinaryStream(String parameterName,
                            InputStream x)
                     throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - the java input stream which contains the binary parameter value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBinaryStream
```
public void setBinaryStream(String parameterName,
                            InputStream x,
                            long length)
                     throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - the java input stream which contains the binary parameter value
    
    length - the number of bytes in the stream
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBlob
```
public void setBlob(String parameterName,
                    Blob x)
             throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - a Blob object that maps an SQL BLOB value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBlob
```
public void setBlob(String parameterName,
                    InputStream inputStream)
             throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    inputStream - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBlob
```
public void setBlob(String parameterName,
                    InputStream inputStream,
                    long length)
             throws 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
    
    Parameters:
    
    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.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the length specified is less than zero; if the number of bytes in the inputstream does not match the specfied length; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setCharacterStream
```
public void setCharacterStream(String parameterName,
                               Reader reader)
                        throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    reader - the java.io.Reader object that contains the Unicode data
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setCharacterStream
```
public void setCharacterStream(String parameterName,
                               Reader reader,
                               long length)
                        throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    reader - the java.io.Reader object that contains the UNICODE data used as the designated parameter
    
    length - the number of characters in the stream
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setClob
```
public void setClob(String parameterName,
                    Clob x)
             throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - a Clob object that maps an SQL CLOB value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setClob
```
public void setClob(String parameterName,
                    Reader reader)
             throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNCharacterStream
```
public void setNCharacterStream(String parameterName,
                                Reader value)
                         throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    value - the parameter value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNCharacterStream
```
public void setNCharacterStream(String parameterName,
                                Reader value,
                                long length)
                         throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter to be set
    
    value - the parameter value
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNClob
```
public void setNClob(String parameterName,
                     NClob reader)
              throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setClob
```
public void setClob(String parameterName,
                    Reader reader,
                    long length)
             throws 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
    
    Parameters:
    
    parameterName - the name of the parameter to be set
    
    reader - An object that contains the data to set the parameter value to.
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the length specified is less than zero; a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNClob
```
public void setNClob(String parameterName,
                     Reader reader)
              throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNClob
```
public void setNClob(String parameterName,
                     Reader reader,
                     long length)
              throws 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
    
    Parameters:
    
    parameterName - the name of the parameter to be set
    
    reader - An object that contains the data to set the parameter value to.
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNString
```
public void setNString(String parameterName,
                       String value)
                throws SQLException
```
    Sets the designated parameter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR
    
    Parameters:
    
    parameterName - the name of the parameter to be set
    
    value - the parameter value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setRowId
```
public void setRowId(String parameterName,
                     RowId x)
              throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    x - the parameter value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setSQLXML
```
public void setSQLXML(String parameterName,
                      SQLXML xmlObject)
               throws 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.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    xmlObject - a SQLXML object that maps an SQL XML value
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs; this method is called on a closed CallableStatement or the java.xml.transform.Result, Writer or OutputStream has not been closed for the SQLXML object
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setAsciiStream
```
public void setAsciiStream(int parameterIndex,
                           InputStream x)
                    throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    x - the Java input stream that contains the ASCII parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setAsciiStream
```
public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           long length)
                    throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    x - the Java input stream that contains the ASCII parameter value
    
    length - the number of bytes in the stream
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    Since:
    
    1.6
  - setBinaryStream
```
public void setBinaryStream(int parameterIndex,
                            InputStream x)
                     throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    x - the java input stream which contains the binary parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBinaryStream
```
public void setBinaryStream(int parameterIndex,
                            InputStream x,
                            long length)
                     throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    x - the java input stream which contains the binary parameter value
    
    length - the number of bytes in the stream
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    Since:
    
    1.6
  - setBlob
```
public void setBlob(int parameterIndex,
                    InputStream inputStream)
             throws 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 sent 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.
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    inputStream - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement or if parameterIndex does not correspond to a parameter marker in the SQL statement,
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setBlob
```
public void setBlob(int parameterIndex,
                    InputStream inputStream,
                    long length)
             throws 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 PreparedStatement 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
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, 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.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement; if the length specified is less than zero or if the number of bytes in the inputstream does not match the specfied length.
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setCharacterStream
```
public void setCharacterStream(int parameterIndex,
                               Reader reader)
                        throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    reader - the java.io.Reader object that contains the Unicode data
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setCharacterStream
```
public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               long length)
                        throws 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.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    reader - the java.io.Reader object that contains the Unicode data
    
    length - the number of characters in the stream
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    Since:
    
    1.6
  - setClob
```
public void setClob(int parameterIndex,
                    Reader reader)
             throws 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 sent 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.
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatementor if parameterIndex does not correspond to a parameter marker in the SQL statement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setClob
```
public void setClob(int parameterIndex,
                    Reader reader,
                    long length)
             throws 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 PreparedStatement 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 sent to the server as a LONGVARCHAR or a CLOB
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    reader - An object that contains the data to set the parameter value to.
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement or if the length specified is less than zero.
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNCharacterStream
```
public void setNCharacterStream(int parameterIndex,
                                Reader value)
                         throws 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.
    
    Parameters:
    
    parameterIndex - of the first parameter is 1, the second is 2, ...
    
    value - the parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNCharacterStream
```
public void setNCharacterStream(int parameterIndex,
                                Reader value,
                                long length)
                         throws 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.
    
    Parameters:
    
    parameterIndex - of the first parameter is 1, the second is 2, ...
    
    value - the parameter value
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNClob
```
public void setNClob(int parameterIndex,
                     NClob value)
              throws SQLException
```
    Sets the designated parameter to a java.sql.NClob object. The driver converts this to a SQL NCLOB value when it sends it to the database.
    
    Parameters:
    
    parameterIndex - of the first parameter is 1, the second is 2, ...
    
    value - the parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNClob
```
public void setNClob(int parameterIndex,
                     Reader reader)
              throws 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 sent 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.
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    reader - An object that contains the data to set the parameter value to.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNClob
```
public void setNClob(int parameterIndex,
                     Reader reader,
                     long length)
              throws 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 PreparedStatement 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 sent to the server as a LONGNVARCHAR or a NCLOB
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    reader - An object that contains the data to set the parameter value to.
    
    length - the number of characters in the parameter data.
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setNString
```
public void setNString(int parameterIndex,
                       String value)
                throws SQLException
```
    Sets the designated paramter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values) when it sends it to the database.
    
    Parameters:
    
    parameterIndex - of the first parameter is 1, the second is 2, ...
    
    value - the parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setRowId
```
public void setRowId(int parameterIndex,
                     RowId x)
              throws SQLException
```
    Sets the designated parameter to the given java.sql.RowId object. The driver converts this to a SQL ROWID value when it sends it to the database
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    x - the parameter value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method is called on a closed PreparedStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - setSQLXML
```
public void setSQLXML(int parameterIndex,
                      SQLXML xmlObject)
               throws 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.
    
    Parameters:
    
    parameterIndex - index of the first parameter is 1, the second is 2, ...
    
    xmlObject - a SQLXML object that maps an SQL XML value
    
    Throws:
    
    SQLException - if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement or the java.xml.transform.Result, Writer or OutputStream has not been closed for the SQLXML object
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.6
  - isClosed
```
public boolean isClosed()
                 throws SQLException
```
    Retrieves whether this Statement object has been closed. A Statement is closed if the method close has been called on it, or if it is automatically closed.
    
    Returns:
    
    true if this Statement object is closed; false if it is still open
    
    Throws:
    
    SQLException - if a database access error occurs
    
    Since:
    
    1.6
  - isPoolable
```
public boolean isPoolable()
                   throws SQLException
```
    Returns a value indicating whether the Statement is poolable or not.
    
    Returns:
    
    true if the Statement is poolable; false otherwise
    
    Throws:
    
    SQLException - if this method is called on a closed Statement
    
    Since:
    
    1.6
    
    See Also:
    
    setPoolable(boolean)
  - setPoolable
```
public void setPoolable(boolean poolable)
                 throws SQLException
```
    Requests that a Statement be pooled or not pooled. The value specified is a hint to the statement pool implementation indicating whether the applicaiton wants the statement to be pooled. It is up to the statement pool manager as to whether the hint is used.
    The poolable value of a statement is applicable to both internal statement caches implemented by the driver and external statement caches implemented by application servers and other applications.
    By default, a Statement is not poolable when created, and a PreparedStatement and CallableStatement are poolable when created.
    
    Parameters:
    
    poolable - requests that the statement be pooled if true and that the statement not be pooled if false
    
    Throws:
    
    SQLException - if this method is called on a closed Statement
    
    Since:
    
    1.6
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.
    
    Parameters:
    
    iface - a Class defining an interface.
    
    Returns:
    
    true if this implements the interface or directly or indirectly wraps an object that does.
    
    Throws:
    
    SQLException - if an error occurs while determining whether this is a wrapper for an object with the given interface.
    
    Since:
    
    1.6
  - unwrap
```
public <T> T unwrap(Class<T> iface)
             throws SQLException
```
    Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
    If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.
    
    Parameters:
    
    iface - A Class defining an interface that the result must implement.
    
    Returns:
    
    an object that implements the interface. May be a proxy for the actual implementing object.
    
    Throws:
    
    SQLException - If no object found that implements the interface
    
    Since:
    
    1.6
  - executeQuery
```
public ResultSet executeQuery()
                       throws SQLException
```
    Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
    
    Returns:
    
    a ResultSet object that contains the data produced by the query; never null
    
    Throws:
    
    SQLException - if a database access error occurs; this method is called on a closed PreparedStatement or the SQL statement does not return a ResultSet object
  - executeQuery
```
public ResultSet executeQuery(String sql)
                       throws SQLException
```
    Executes the given SQL statement, which returns a single ResultSet object.
    
    Parameters:
    
    sql - an SQL statement to be sent to the database, typically a static SQL SELECT statement
    
    Returns:
    
    a ResultSet object that contains the data produced by the given query; never null
    
    Throws:
    
    SQLException - if a database access error occurs, this method is called on a closed Statement or the given SQL statement produces anything other than a single ResultSet object
  - getGeneratedKeys
```
public ResultSet getGeneratedKeys()
                           throws SQLException
```
    Retrieves any auto-generated keys created as a result of executing this Statement object. If this Statement object did not generate any keys, an empty ResultSet object is returned.
    
    Note:If the columns which represent the auto-generated keys were not specified, the JDBC driver implementation will determine the columns which best represent the auto-generated keys.
    
    Returns:
    
    a ResultSet object containing the auto-generated key(s) generated by the execution of this Statement object
    
    Throws:
    
    SQLException - if a database access error occurs or this method is called on a closed Statement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support this method
    
    Since:
    
    1.4
  - getResultSet
```
public ResultSet getResultSet()
                       throws SQLException
```
    Retrieves the current result as a ResultSet object. This method should be called only once per result.
    
    Returns:
    
    the current result as a ResultSet object or null if the result is an update count or there are no more results
    
    Throws:
    
    SQLException - if a database access error occurs or this method is called on a closed Statement
    
    See Also:
    
    PreparedStatementWrapper.execute()
  - getObject
```
public <T> T getObject(int parameterIndex,
                       Class<T> type)
                throws SQLException
```
    Throws:
    
    SQLException
  - getObject
```
public <T> T getObject(String parameterName,
                       Class<T> type)
                throws SQLException
```
    Throws:
    
    SQLException
  - setObject
```
public void setObject(String parameterName,
                      Object parameterValue,
                      SQLType targetSqlType,
                      int scaleOrLength)
               throws SQLException
```
    Sets the value of the designated parameter with the given object. The given Java object will be converted to the given targetSqlType before being sent to the database.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    parameterValue - the object containing the input parameter value
    
    targetSqlType - the SQL type to be sent to the database. The scale argument may further qualify this type.
    
    scaleOrLength - for java.sql.JDBCType.DECIMAL or java.sql.JDBCType.NUMERIC types, this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement or if the Java Object specified by x is an InputStream or Reader object and the value of the scale parameter is less than zero
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified targetSqlType
  - setObject
```
public void setObject(String parameterName,
                      Object parameterValue,
                      SQLType targetSqlType)
               throws SQLException
```
    Sets the value of the designated parameter with the given object. This method is similar to setObject(String parameterName, Object x, SQLType targetSqlType, int scaleOrLength), except that it assumes a scale of zero.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    parameterValue - the object containing the input parameter value
    
    targetSqlType - the SQL type to be sent to the database
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified targetSqlType
  - registerOutParameter
```
public void registerOutParameter(int parameterIndex,
                                 SQLType sqlType)
                          throws SQLException
```
    Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, and so on
    
    sqlType - the JDBC type code defined by SQLType to use to register the OUT Parameter. If the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified sqlType
  - registerOutParameter
```
public void registerOutParameter(int parameterIndex,
                                 SQLType sqlType,
                                 int scale)
                          throws SQLException
```
    Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType. This version of registerOutParameter should be used when the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, and so on
    
    sqlType - the JDBC type code defined by SQLType to use to register the OUT Parameter.
    
    scale - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified sqlType
  - registerOutParameter
```
public void registerOutParameter(int parameterIndex,
                                 SQLType sqlType,
                                 String typeName)
                          throws SQLException
```
    Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-defined or REF output parameter.
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2,...
    
    sqlType - the JDBC type code defined by SQLType to use to register the OUT Parameter.
    
    typeName - the fully-qualified name of an SQL structured type
    
    Throws:
    
    SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified sqlType
  - registerOutParameter
```
public void registerOutParameter(String parameterName,
                                 SQLType sqlType)
                          throws SQLException
```
    Registers the OUT parameter named parameterName to the JDBC type sqlType.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    sqlType - the JDBC type code defined by SQLType to use to register the OUT Parameter. If the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified sqlType or if the JDBC driver does not support this method
  - registerOutParameter
```
public void registerOutParameter(String parameterName,
                                 SQLType sqlType,
                                 int scale)
                          throws SQLException
```
    Registers the parameter named parameterName to be of JDBC type sqlType. This version of registerOutParameter should be used when the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    sqlType - the JDBC type code defined by SQLType to use to register the OUT Parameter.
    
    scale - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified sqlType or if the JDBC driver does not support this method
  - registerOutParameter
```
public void registerOutParameter(String parameterName,
                                 SQLType sqlType,
                                 String typeName)
                          throws SQLException
```
    Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-named or REF output parameter.
    
    Parameters:
    
    parameterName - the name of the parameter
    
    sqlType - the JDBC type code defined by SQLType to use to register the OUT Parameter.
    
    typeName - the fully-qualified name of an SQL structured type
    
    Throws:
    
    SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement
    
    SQLFeatureNotSupportedException - if the JDBC driver does not support the specified sqlType or if the JDBC driver does not support this method

Class CallableStatementWrapper40

Field Summary

Fields inherited from class com.sun.gjc.spi.base.CallableStatementWrapper

Fields inherited from class com.sun.gjc.spi.base.PreparedStatementWrapper

Fields inherited from class com.sun.gjc.spi.base.StatementWrapper

Fields inherited from interface java.sql.Statement

Constructor Summary

Method Summary

Methods inherited from class com.sun.gjc.spi.base.CallableStatementWrapper

Methods inherited from class com.sun.gjc.spi.base.PreparedStatementWrapper

Methods inherited from class com.sun.gjc.spi.base.StatementWrapper

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.PreparedStatement

Methods inherited from interface java.sql.Statement

Constructor Detail

CallableStatementWrapper40

Method Detail

getCharacterStream

getCharacterStream

getNCharacterStream

getNCharacterStream

getNClob

getNClob

getNString

getNString

getRowId

getRowId

getSQLXML

getSQLXML

setAsciiStream

setAsciiStream

setBinaryStream

setBinaryStream

setBlob

setBlob

setBlob

setCharacterStream

setCharacterStream

setClob

setClob

setNCharacterStream

setNCharacterStream

setNClob

setClob

setNClob

setNClob

setNString

setRowId

setSQLXML

setAsciiStream

setAsciiStream

setBinaryStream

setBinaryStream

setBlob

setBlob

setCharacterStream

setCharacterStream

setClob

setClob

setNCharacterStream

setNCharacterStream

setNClob

setNClob

setNClob

setNString

setRowId

setSQLXML

isClosed

isPoolable

setPoolable

isWrapperFor

unwrap

executeQuery

executeQuery

getGeneratedKeys

getResultSet

getObject

getObject

setObject

setObject