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) throws SQLException
[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) throws SQLException
[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