# CallableStatement

Represents a callable statement.

Methods
int | executeUpdate() Executes a statement (insert, update, delete, create, drop) and returns the update count.

int

executeUpdate() throws SQLException
Executes a statement (insert, update, delete, create, drop) and returns the update count. If another result set exists for this statement, this will be closed (even if this statement fails). If auto commit is on, this statement will be committed. If the statement is a DDL statement (create, drop, alter) and does not throw an exception, the current transaction (if any) is committed after executing the statement.
Returns:
the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
Throws:
SQLException - if this object is closed or invalid

Array | getArray(int parameterIndex) Returns the value of the specified column as an Array.
Array | getArray(int parameterIndex) throws SQLException Returns the value of the specified column as an Array. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Array | getArray(String parameterName) Returns the value of the specified column as an Array.
Array | getArray(String parameterName) throws SQLException Returns the value of the specified column as an Array. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
BigDecimal | getBigDecimal(int parameterIndex, int scale) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(int parameterIndex, int scale) throws SQLException Returns the value of the specified column as a BigDecimal. Parameters: parameterIndex - the parameter index (1, 2, ...) scale - is ignored Returns: the value Throws: SQLException - if the column is not found or if this object is closed
BigDecimal | getBigDecimal(int parameterIndex) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(int parameterIndex) throws SQLException Returns the value of the specified column as a BigDecimal. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
BigDecimal | getBigDecimal(String parameterName) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(String parameterName) throws SQLException Returns the value of the specified column as a BigDecimal. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Blob | getBlob(int parameterIndex) Returns the value of the specified column as a Blob.
Blob | getBlob(int parameterIndex) throws SQLException Returns the value of the specified column as a Blob. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Blob | getBlob(String parameterName) Returns the value of the specified column as a Blob.
Blob | getBlob(String parameterName) throws SQLException Returns the value of the specified column as a Blob. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
boolean | getBoolean(int parameterIndex) Returns the value of the specified column as a boolean.
boolean | getBoolean(int parameterIndex) throws SQLException Returns the value of the specified column as a boolean. Parameters: parameterIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
boolean | getBoolean(String parameterName) Returns the value of the specified column as a boolean.
boolean | getBoolean(String parameterName) throws SQLException Returns the value of the specified column as a boolean. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
byte | getByte(int parameterIndex) Returns the value of the specified column as a byte.
byte | getByte(int parameterIndex) throws SQLException Returns the value of the specified column as a byte. Parameters: parameterIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
byte | getByte(String parameterName) Returns the value of the specified column as a byte.
byte | getByte(String parameterName) throws SQLException Returns the value of the specified column as a byte. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
byte[] | getBytes(int parameterIndex) Returns the value of the specified column as a byte array.
byte[] | getBytes(int parameterIndex) throws SQLException Returns the value of the specified column as a byte array. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
byte[] | getBytes(String parameterName) Returns the value of the specified column as a byte array.
byte[] | getBytes(String parameterName) throws SQLException Returns the value of the specified column as a byte array. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Reader | getCharacterStream(int parameterIndex) Returns the value of the specified column as a reader.
Reader | getCharacterStream(int parameterIndex) throws SQLException Returns the value of the specified column as a reader. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Reader | getCharacterStream(String parameterName) Returns the value of the specified column as a reader.
Reader | getCharacterStream(String parameterName) throws SQLException Returns the value of the specified column as a reader. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Clob | getClob(int parameterIndex) Returns the value of the specified column as a Clob.
Clob | getClob(int parameterIndex) throws SQLException Returns the value of the specified column as a Clob. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Clob | getClob(String parameterName) Returns the value of the specified column as a Clob.
Clob | getClob(String parameterName) throws SQLException Returns the value of the specified column as a Clob. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Date | getDate(int parameterIndex) Returns the value of the specified column as a java.sql.Date.
Date | getDate(int parameterIndex) throws SQLException Returns the value of the specified column as a java.sql.Date. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Date | getDate(int parameterIndex, Calendar cal) Returns the value of the specified column as a java.sql.Date using a specified time zone.
Date | getDate(int parameterIndex, Calendar cal) throws SQLException Returns the value of the specified column as a java.sql.Date using a specified time zone. Parameters: parameterIndex - the parameter index (1, 2, ...) cal - the calendar Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Date | getDate(String parameterName, Calendar cal) Returns the value of the specified column as a java.sql.Date using a specified time zone.
Date | getDate(String parameterName, Calendar cal) throws SQLException Returns the value of the specified column as a java.sql.Date using a specified time zone. Parameters: parameterName - the parameter name cal - the calendar Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Date | getDate(String parameterName) Returns the value of the specified column as a java.sql.Date.
Date | getDate(String parameterName) throws SQLException Returns the value of the specified column as a java.sql.Date. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
double | getDouble(int parameterIndex) Returns the value of the specified column as a double.
double | getDouble(int parameterIndex) throws SQLException Returns the value of the specified column as a double. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
double | getDouble(String parameterName) Returns the value of the specified column as a double.
double | getDouble(String parameterName) throws SQLException Returns the value of the specified column as a double. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
float | getFloat(int parameterIndex) Returns the value of the specified column as a float.
float | getFloat(int parameterIndex) throws SQLException Returns the value of the specified column as a float. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
float | getFloat(String parameterName) Returns the value of the specified column as a float.
float | getFloat(String parameterName) throws SQLException Returns the value of the specified column as a float. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
int | getInt(int parameterIndex) Returns the value of the specified column as an int.
int | getInt(int parameterIndex) throws SQLException Returns the value of the specified column as an int. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
int | getInt(String parameterName) Returns the value of the specified column as an int.
int | getInt(String parameterName) throws SQLException Returns the value of the specified column as an int. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
long | getLong(int parameterIndex) Returns the value of the specified column as a long.
long | getLong(int parameterIndex) throws SQLException Returns the value of the specified column as a long. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
long | getLong(String parameterName) Returns the value of the specified column as a long.
long | getLong(String parameterName) throws SQLException Returns the value of the specified column as a long. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Reader | getNCharacterStream(int parameterIndex) Returns the value of the specified column as a reader.
Reader | getNCharacterStream(int parameterIndex) throws SQLException Returns the value of the specified column as a reader. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Reader | getNCharacterStream(String parameterName) Returns the value of the specified column as a reader.
Reader | getNCharacterStream(String parameterName) throws SQLException Returns the value of the specified column as a reader. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
NClob | getNClob(int parameterIndex) Returns the value of the specified column as a Clob.
NClob | getNClob(int parameterIndex) throws SQLException Returns the value of the specified column as a Clob. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
NClob | getNClob(String parameterName) Returns the value of the specified column as a Clob.
NClob | getNClob(String parameterName) throws SQLException Returns the value of the specified column as a Clob. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
String | getNString(int parameterIndex) Returns the value of the specified column as a String.
String | getNString(int parameterIndex) throws SQLException Returns the value of the specified column as a String. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
String | getNString(String parameterName) Returns the value of the specified column as a String.
String | getNString(String parameterName) throws SQLException Returns the value of the specified column as a String. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Object | getObject(int parameterIndex) Returns a column value as a Java object.
Object | getObject(int parameterIndex) throws SQLException Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side). Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value or null Throws: SQLException - if the column is not found or if this object is closed
Object | getObject(int parameterIndex, Map map) [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(int parameterIndex, Map map) throws SQLException [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(String parameterName, Map map) [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(String parameterName, Map map) throws SQLException [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(String parameterName) Returns a column value as a Java object.
Object | getObject(String parameterName) throws SQLException Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side). Parameters: parameterName - the parameter name Returns: the value or null Throws: SQLException - if the column is not found or if this object is closed
T | getObject(int parameterIndex, Class type) [Not supported]
T | getObject(int parameterIndex, Class type) [Not supported] Parameters: parameterIndex - the parameter index (1, 2, ...) type - the class of the returned value
T | getObject(String parameterName, Class type) [Not supported]
T | getObject(String parameterName, Class type) [Not supported] Parameters: parameterName - the parameter name type - the class of the returned value
Ref | getRef(int parameterIndex) [Not supported] Gets a column as a reference.
Ref | getRef(int parameterIndex) throws SQLException [Not supported] Gets a column as a reference.
Ref | getRef(String parameterName) [Not supported] Gets a column as a reference.
Ref | getRef(String parameterName) throws SQLException [Not supported] Gets a column as a reference.
RowId | getRowId(int parameterIndex) [Not supported] Returns the value of the specified column as a row id.
RowId | getRowId(int parameterIndex) throws SQLException [Not supported] Returns the value of the specified column as a row id. Parameters: parameterIndex - the parameter index (1, 2, ...)
RowId | getRowId(String parameterName) [Not supported] Returns the value of the specified column as a row id.
RowId | getRowId(String parameterName) throws SQLException [Not supported] Returns the value of the specified column as a row id. Parameters: parameterName - the parameter name
SQLXML | getSQLXML(int parameterIndex) [Not supported] Returns the value of the specified column as a SQLXML object.
SQLXML | getSQLXML(int parameterIndex) throws SQLException [Not supported] Returns the value of the specified column as a SQLXML object.
SQLXML | getSQLXML(String parameterName) [Not supported] Returns the value of the specified column as a SQLXML object.
SQLXML | getSQLXML(String parameterName) throws SQLException [Not supported] Returns the value of the specified column as a SQLXML object.
short | getShort(int parameterIndex) Returns the value of the specified column as a short.
short | getShort(int parameterIndex) throws SQLException Returns the value of the specified column as a short. Parameters: parameterIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
short | getShort(String parameterName) Returns the value of the specified column as a short.
short | getShort(String parameterName) throws SQLException Returns the value of the specified column as a short. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
String | getString(int parameterIndex) Returns the value of the specified column as a String.
String | getString(int parameterIndex) throws SQLException Returns the value of the specified column as a String. Parameters: parameterIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
String | getString(String parameterName) Returns the value of the specified column as a String.
String | getString(String parameterName) throws SQLException Returns the value of the specified column as a String. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Time | getTime(int parameterIndex) Returns the value of the specified column as a java.sql.Time.
Time | getTime(int parameterIndex) throws SQLException Returns the value of the specified column as a java.sql.Time. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Time | getTime(int parameterIndex, Calendar cal) Returns the value of the specified column as a java.sql.Time using a specified time zone.
Time | getTime(int parameterIndex, Calendar cal) throws SQLException Returns the value of the specified column as a java.sql.Time using a specified time zone. Parameters: parameterIndex - the parameter index (1, 2, ...) cal - the calendar Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Time | getTime(String parameterName, Calendar cal) Returns the value of the specified column as a java.sql.Time using a specified time zone.
Time | getTime(String parameterName, Calendar cal) throws SQLException Returns the value of the specified column as a java.sql.Time using a specified time zone. Parameters: parameterName - the parameter name cal - the calendar Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Time | getTime(String parameterName) Returns the value of the specified column as a java.sql.Time.
Time | getTime(String parameterName) throws SQLException Returns the value of the specified column as a java.sql.Time. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Timestamp | getTimestamp(int parameterIndex) Returns the value of the specified column as a java.sql.Timestamp.
Timestamp | getTimestamp(int parameterIndex) throws SQLException Returns the value of the specified column as a java.sql.Timestamp. Parameters: parameterIndex - the parameter index (1, 2, ...) Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Timestamp | getTimestamp(int parameterIndex, Calendar cal) Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
Timestamp | getTimestamp(int parameterIndex, Calendar cal) throws SQLException Returns the value of the specified column as a java.sql.Timestamp using a specified time zone. Parameters: parameterIndex - the parameter index (1, 2, ...) cal - the calendar Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Timestamp | getTimestamp(String parameterName, Calendar cal) Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
Timestamp | getTimestamp(String parameterName, Calendar cal) throws SQLException Returns the value of the specified column as a java.sql.Timestamp using a specified time zone. Parameters: parameterName - the parameter name cal - the calendar Returns: the value Throws: SQLException - if the column is not found or if this object is closed
Timestamp | getTimestamp(String parameterName) Returns the value of the specified column as a java.sql.Timestamp.
Timestamp | getTimestamp(String parameterName) throws SQLException Returns the value of the specified column as a java.sql.Timestamp. Parameters: parameterName - the parameter name Returns: the value Throws: SQLException - if the column is not found or if this object is closed
URL | getURL(int parameterIndex) [Not supported]
URL | getURL(int parameterIndex) throws SQLException [Not supported]
URL | getURL(String parameterName) [Not supported]
URL | getURL(String parameterName) throws SQLException [Not supported]
void | registerOutParameter(int parameterIndex, int sqlType) Registers the given OUT parameter.
void | registerOutParameter(int parameterIndex, int sqlType) throws SQLException Registers the given OUT parameter. Parameters: parameterIndex - the parameter index (1, 2, ...) sqlType - the data type (Types.x) - ignored
void | registerOutParameter(int parameterIndex, int sqlType, String typeName) Registers the given OUT parameter.
void | registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException Registers the given OUT parameter. Parameters: parameterIndex - the parameter index (1, 2, ...) sqlType - the data type (Types.x) - ignored typeName - the SQL type name - ignored
void | registerOutParameter(int parameterIndex, int sqlType, int scale) Registers the given OUT parameter.
void | registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException Registers the given OUT parameter. Parameters: parameterIndex - the parameter index (1, 2, ...) sqlType - the data type (Types.x) scale - is ignored
void | registerOutParameter(String parameterName, int sqlType, String typeName) Registers the given OUT parameter.
void | registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException Registers the given OUT parameter. Parameters: parameterName - the parameter name sqlType - the data type (Types.x) - ignored typeName - the SQL type name - ignored
void | registerOutParameter(String parameterName, int sqlType, int scale) Registers the given OUT parameter.
void | registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException Registers the given OUT parameter. Parameters: parameterName - the parameter name sqlType - the data type (Types.x) - ignored scale - is ignored
void | registerOutParameter(String parameterName, int sqlType) Registers the given OUT parameter.
void | registerOutParameter(String parameterName, int sqlType) throws SQLException Registers the given OUT parameter. Parameters: parameterName - the parameter name sqlType - the data type (Types.x) - ignored
void | setAsciiStream(String parameterName, InputStream x, long length) Sets the value of a parameter as an ASCII stream.
void | setAsciiStream(String parameterName, InputStream x, long length) throws SQLException Sets the value of a parameter as an ASCII stream. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of bytes Throws: SQLException - if this object is closed
void | setAsciiStream(String parameterName, InputStream x) Sets the value of a parameter as an ASCII stream.
void | setAsciiStream(String parameterName, InputStream x) throws SQLException Sets the value of a parameter as an ASCII stream. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setAsciiStream(String parameterName, InputStream x, int length) Sets the value of a parameter as an ASCII stream.
void | setAsciiStream(String parameterName, InputStream x, int length) throws SQLException Sets the value of a parameter as an ASCII stream. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of bytes Throws: SQLException - if this object is closed
void | setBigDecimal(String parameterName, BigDecimal x) Sets the value of a parameter.
void | setBigDecimal(String parameterName, BigDecimal x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setBinaryStream(String parameterName, InputStream x, int length) Sets the value of a parameter as an input stream.
void | setBinaryStream(String parameterName, InputStream x, int length) throws SQLException Sets the value of a parameter as an input stream. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of bytes Throws: SQLException - if this object is closed
void | setBinaryStream(String parameterName, InputStream x) Sets the value of a parameter as an input stream.
void | setBinaryStream(String parameterName, InputStream x) throws SQLException Sets the value of a parameter as an input stream. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setBinaryStream(String parameterName, InputStream x, long length) Sets the value of a parameter as an input stream.
void | setBinaryStream(String parameterName, InputStream x, long length) throws SQLException Sets the value of a parameter as an input stream. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of bytes Throws: SQLException - if this object is closed
void | setBlob(String parameterName, InputStream x, long length) Sets the value of a parameter as a Blob.
void | setBlob(String parameterName, InputStream x, long length) throws SQLException Sets the value of a parameter as a Blob. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of bytes Throws: SQLException - if this object is closed
void | setBlob(String parameterName, Blob x) Sets the value of a parameter as a Blob.
void | setBlob(String parameterName, Blob x) throws SQLException Sets the value of a parameter as a Blob. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setBlob(String parameterName, InputStream x) Sets the value of a parameter as a Blob.
void | setBlob(String parameterName, InputStream x) throws SQLException Sets the value of a parameter as a Blob. This method does not close the stream. The stream may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setBoolean(String parameterName, boolean x) Sets the value of a parameter.
void | setBoolean(String parameterName, boolean x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setByte(String parameterName, byte x) Sets the value of a parameter.
void | setByte(String parameterName, byte x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setBytes(String parameterName, byte[] x) Sets the value of a parameter as a byte array.
void | setBytes(String parameterName, byte[] x) throws SQLException Sets the value of a parameter as a byte array. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setCharacterStream(String parameterName, Reader x, int length) Sets the value of a parameter as a character stream.
void | setCharacterStream(String parameterName, Reader x, int length) throws SQLException Sets the value of a parameter as a character stream. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of characters Throws: SQLException - if this object is closed
void | setCharacterStream(String parameterName, Reader x) Sets the value of a parameter as a character stream.
void | setCharacterStream(String parameterName, Reader x) throws SQLException Sets the value of a parameter as a character stream. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setCharacterStream(String parameterName, Reader x, long length) Sets the value of a parameter as a character stream.
void | setCharacterStream(String parameterName, Reader x, long length) throws SQLException Sets the value of a parameter as a character stream. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of characters Throws: SQLException - if this object is closed
void | setClob(String parameterName, Reader x, long length) Sets the value of a parameter as a Clob.
void | setClob(String parameterName, Reader x, long length) throws SQLException Sets the value of a parameter as a Clob. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of characters Throws: SQLException - if this object is closed
void | setClob(String parameterName, Clob x) Sets the value of a parameter as a Clob.
void | setClob(String parameterName, Clob x) throws SQLException Sets the value of a parameter as a Clob. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setClob(String parameterName, Reader x) Sets the value of a parameter as a character stream.
void | setClob(String parameterName, Reader x) throws SQLException Sets the value of a parameter as a character stream. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setDate(String parameterName, Date x, Calendar cal) Sets the date using a specified time zone.
void | setDate(String parameterName, Date x, Calendar cal) throws SQLException Sets the date using a specified time zone. The value will be converted to the local time zone. Parameters: parameterName - the parameter name x - the value cal - the calendar Throws: SQLException - if this object is closed
void | setDate(String parameterName, Date x) Sets the value of a parameter.
void | setDate(String parameterName, Date x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setDouble(String parameterName, double x) Sets the value of a parameter.
void | setDouble(String parameterName, double x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setFloat(String parameterName, float x) Sets the value of a parameter.
void | setFloat(String parameterName, float x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setInt(String parameterName, int x) Sets the value of a parameter.
void | setInt(String parameterName, int x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setLong(String parameterName, long x) Sets the value of a parameter.
void | setLong(String parameterName, long x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setNCharacterStream(String parameterName, Reader x, long length) Sets the value of a parameter as a character stream.
void | setNCharacterStream(String parameterName, Reader x, long length) throws SQLException Sets the value of a parameter as a character stream. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of characters Throws: SQLException - if this object is closed
void | setNCharacterStream(String parameterName, Reader x) Sets the value of a parameter as a character stream.
void | setNCharacterStream(String parameterName, Reader x) throws SQLException Sets the value of a parameter as a character stream. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setNClob(String parameterName, NClob x) Sets the value of a parameter as a Clob.
void | setNClob(String parameterName, NClob x) throws SQLException Sets the value of a parameter as a Clob. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setNClob(String parameterName, Reader x, long length) Sets the value of a parameter as a Clob.
void | setNClob(String parameterName, Reader x, long length) throws SQLException Sets the value of a parameter as a Clob. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value length - the maximum number of characters Throws: SQLException - if this object is closed
void | setNClob(String parameterName, Reader x) Sets the value of a parameter as a Clob.
void | setNClob(String parameterName, Reader x) throws SQLException Sets the value of a parameter as a Clob. This method does not close the reader. The reader may be closed after executing the statement. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setNString(String parameterName, String x) Sets the value of a parameter.
void | setNString(String parameterName, String x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setNull(String parameterName, int sqlType, String typeName) Sets a parameter to null.
void | setNull(String parameterName, int sqlType, String typeName) throws SQLException Sets a parameter to null. Parameters: parameterName - the parameter name sqlType - the data type (Types.x) typeName - this parameter is ignored Throws: SQLException - if this object is closed
void | setNull(String parameterName, int sqlType) Sets a parameter to null.
void | setNull(String parameterName, int sqlType) throws SQLException Sets a parameter to null. Parameters: parameterName - the parameter name sqlType - the data type (Types.x) Throws: SQLException - if this object is closed
void | setObject(String parameterName, Object x) Sets the value of a parameter.
void | setObject(String parameterName, Object x) throws SQLException Sets the value of a parameter. Objects of unknown classes are serialized (on the client side). Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setObject(String parameterName, Object x, int targetSqlType) Sets the value of a parameter.

void

setObject(String parameterName, Object x, int targetSqlType) throws SQLException
Sets the value of a parameter. The object is converted, if required, to the specified data type before sending to the database. Objects of unknown classes are serialized (on the client side).
Parameters:
parameterName - the parameter name
x - the value, null is allowed
targetSqlType - the type as defined in java.sql.Types
Throws:
SQLException - if this object is closed

void | setObject(String parameterName, Object x, int targetSqlType, int scale) Sets the value of a parameter.

void

setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
Sets the value of a parameter. The object is converted, if required, to the specified data type before sending to the database. Objects of unknown classes are serialized (on the client side).
Parameters:
parameterName - the parameter name
x - the value, null is allowed
targetSqlType - the type as defined in java.sql.Types
scale - is ignored
Throws:
SQLException - if this object is closed

void | setRowId(String parameterName, RowId x) [Not supported] Sets the value of a parameter as a row id.
void | setRowId(String parameterName, RowId x) throws SQLException [Not supported] Sets the value of a parameter as a row id.
void | setSQLXML(String parameterName, SQLXML x) [Not supported] Sets the value of a parameter as a SQLXML object.
void | setSQLXML(String parameterName, SQLXML x) throws SQLException [Not supported] Sets the value of a parameter as a SQLXML object.
void | setShort(String parameterName, short x) Sets the value of a parameter.
void | setShort(String parameterName, short x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setString(String parameterName, String x) Sets the value of a parameter.
void | setString(String parameterName, String x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setTime(String parameterName, Time x, Calendar cal) Sets the time using a specified time zone.
void | setTime(String parameterName, Time x, Calendar cal) throws SQLException Sets the time using a specified time zone. The value will be converted to the local time zone. Parameters: parameterName - the parameter name x - the value cal - the calendar Throws: SQLException - if this object is closed
void | setTime(String parameterName, Time x) Sets the time using a specified time zone.
void | setTime(String parameterName, Time x) throws SQLException Sets the time using a specified time zone. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setTimestamp(String parameterName, Timestamp x, Calendar cal) Sets the timestamp using a specified time zone.
void | setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException Sets the timestamp using a specified time zone. The value will be converted to the local time zone. Parameters: parameterName - the parameter name x - the value cal - the calendar Throws: SQLException - if this object is closed
void | setTimestamp(String parameterName, Timestamp x) Sets the value of a parameter.
void | setTimestamp(String parameterName, Timestamp x) throws SQLException Sets the value of a parameter. Parameters: parameterName - the parameter name x - the value Throws: SQLException - if this object is closed
void | setURL(String parameterName, URL val) [Not supported]
void | setURL(String parameterName, URL val) throws SQLException [Not supported]
boolean | wasNull() Returns whether the last column accessed was null.
boolean | wasNull() throws SQLException Returns whether the last column accessed was null. Returns: true if the last column accessed was null