|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.lapetus_ltd.api.db.control.TLptsRowSet
public final class TLptsRowSet
Class Description : This class implements the javax.sql.RowSet.
PreparedStatement.execute()
.
TLptsFactoryRowSet.executeSelectStatement(TLptsStatement, int, int, boolean)
ILptsFactoryRowSetListener
.
Nested Class Summary | |
---|---|
class |
TLptsRowSet.ResultSetObjectLists
This class is used to transport the complete data for a row of the data source. |
Field Summary |
---|
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
TLptsRowSet(TLptsStatement statement,
java.sql.ResultSet resultSet)
Constructor for a TLptsRowSet. |
|
TLptsRowSet(TLptsStatement statement,
javax.sql.RowSet rowSet)
Constructor for a TLptsRowSet. |
Method Summary | ||
---|---|---|
boolean |
absolute(int row)
Javadoc taken from RowSet interface : Moves the cursor to the given row number in this ResultSet object. |
|
void |
addRowSetListener(javax.sql.RowSetListener listener)
Javadoc taken from RowSet interface : Registers the given listener so that it will be notified of events that occur on this RowSet object. |
|
void |
afterLast()
Javadoc taken from RowSet interface : Moves the cursor to the end of this ResultSet object, just after the
last row. |
|
void |
beforeFirst()
Javadoc taken from RowSet interface : Moves the cursor to the front of this ResultSet object, just before the
first row. |
|
void |
cancelRowUpdates()
Javadoc taken from RowSet interface : Cancels the updates made to the current row in this ResultSet object. |
|
void |
clearParameters()
Javadoc taken from RowSet interface : Clears the parameters set for this RowSet object's command. |
|
void |
clearWarnings()
Javadoc taken from RowSet interface : Clears all warnings reported on this ResultSet object. |
|
void |
close()
Javadoc taken from RowSet interface : Releases this ResultSet object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
|
void |
closeWE()
Without Exception version: Releases this ResultSet object's database and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
|
void |
deleteRow()
Javadoc taken from RowSet interface : Deletes the current row from this ResultSet object
and from the underlying database. |
|
void |
execute()
Javadoc taken from RowSet interface : Fills this RowSet object with data. |
|
int |
findColumn(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Maps the given ResultSet column label to its
ResultSet column index. |
|
boolean |
first()
Javadoc taken from RowSet interface : Moves the cursor to the first row in this ResultSet object. |
|
java.sql.Array |
getArray(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as an Array object
in the Java programming language. |
|
java.sql.Array |
getArray(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as an Array object
in the Java programming language. |
|
java.io.InputStream |
getAsciiStream(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a stream of ASCII characters. |
|
java.io.InputStream |
getAsciiStream(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a stream of
ASCII characters. |
|
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a
java.math.BigDecimal with full precision. |
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a
java.math.BigDecimal with full precision. |
|
java.io.InputStream |
getBinaryStream(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a stream of
uninterpreted bytes. |
|
java.io.InputStream |
getBinaryStream(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted
byte s. |
|
java.sql.Blob |
getBlob(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object
in the Java programming language. |
|
java.sql.Blob |
getBlob(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object
in the Java programming language. |
|
boolean |
getBoolean(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a boolean in the Java programming language. |
|
boolean |
getBoolean(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a boolean in the Java programming language. |
|
byte |
getByte(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a byte in the Java programming language. |
|
byte |
getByte(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a byte in the Java programming language. |
|
byte[] |
getBytes(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a byte array in the Java programming language. |
|
byte[] |
getBytes(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a byte array in the Java programming language. |
|
java.io.Reader |
getCharacterStream(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
|
java.io.Reader |
getCharacterStream(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
|
java.lang.String |
getCharSet()
This is the charset used for encoding the string values. |
|
java.sql.Clob |
getClob(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object
in the Java programming language. |
|
java.sql.Clob |
getClob(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object
in the Java programming language. |
|
java.util.List<java.lang.String> |
getColumnNames()
This function gets all the column names for the current rowset. |
|
java.util.List<java.lang.String> |
getColumnNames(java.util.Set<java.lang.Integer> columnIndexes)
This function gets the requested column names for the current rowset by their index. |
|
java.lang.String |
getCommand()
Javadoc taken from RowSet interface : Retrieves this RowSet object's command property. |
|
int |
getConcurrency()
Javadoc taken from RowSet interface : Retrieves the concurrency mode of this ResultSet object. |
|
TLptsRowSet.ResultSetObjectLists |
getCurrentRowObjectLists()
This function retrieves lists of all the objects in the current row of this row set. |
|
java.lang.String |
getCursorName()
Javadoc taken from RowSet interface : Retrieves the name of the SQL cursor used by this ResultSet
object. |
|
java.lang.String |
getDataSourceName()
Javadoc taken from RowSet interface : Retrieves the logical name that identifies the data source for this RowSet object. |
|
java.sql.Date |
getDate(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Date object in the Java programming language. |
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object
in the Java programming language. |
|
java.sql.Date |
getDate(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Date object in the Java programming language. |
|
java.sql.Date |
getDate(java.lang.String columnLabel,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object
in the Java programming language. |
|
double |
getDouble(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a double in the Java programming language. |
|
double |
getDouble(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a double in the Java programming language. |
|
boolean |
getEscapeProcessing()
Javadoc taken from RowSet interface : Retrieves whether escape processing is enabled for this RowSet object. |
|
int |
getFetchDirection()
Javadoc taken from RowSet interface : Retrieves the fetch direction for this ResultSet object. |
|
int |
getFetchSize()
Javadoc taken from RowSet interface : Retrieves the fetch size for this ResultSet object. |
|
float |
getFloat(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a float in the Java programming language. |
|
float |
getFloat(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a float in the Java programming language. |
|
int |
getHoldability()
Javadoc taken from RowSet interface : Retrieves the holdability of this ResultSet object |
|
java.lang.String |
getId()
Gets this TLptsRowSet's ID. |
|
int |
getInt(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
an int in the Java programming language. |
|
int |
getInt(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
an int in the Java programming language. |
|
long |
getLong(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a long in the Java programming language. |
|
long |
getLong(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a long in the Java programming language. |
|
int |
getMaxFieldSize()
Javadoc taken from RowSet interface : Retrieves the maximum number of bytes that may be returned for certain column values. |
|
int |
getMaxRows()
Javadoc taken from RowSet interface : Retrieves the maximum number of rows that this RowSet
object can contain. |
|
java.sql.ResultSetMetaData |
getMetaData()
Javadoc taken from RowSet interface : Retrieves the number, types and properties of this ResultSet object's columns. |
|
java.io.Reader |
getNCharacterStream(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
|
java.io.Reader |
getNCharacterStream(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
|
java.sql.NClob |
getNClob(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object
in the Java programming language. |
|
java.sql.NClob |
getNClob(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object
in the Java programming language. |
|
java.lang.String |
getNString(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a String in the Java programming language. |
|
java.lang.String |
getNString(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a String in the Java programming language. |
|
java.lang.Object |
getObject(int columnIndex)
Javadoc taken from RowSet interface : Gets the value of the designated column in the current row of this ResultSet object as
an Object in the Java programming language. |
|
java.lang.Object |
getObject(int columnIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as an Object
in the Java programming language. |
|
java.lang.Object |
getObject(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Gets the value of the designated column in the current row of this ResultSet object as
an Object in the Java programming language. |
|
java.lang.Object |
getObject(java.lang.String columnLabel,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as an Object
in the Java programming language. |
|
java.lang.String |
getPassword()
Javadoc taken from RowSet interface : Retrieves the password used to create a database connection. |
|
int |
getQueryTimeout()
Javadoc taken from RowSet interface : Retrieves the maximum number of seconds the driver will wait for a statement to execute. |
|
java.sql.Ref |
getRef(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object
in the Java programming language. |
|
java.sql.Ref |
getRef(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object
in the Java programming language. |
|
int |
getRow()
Javadoc taken from RowSet interface : Retrieves the current row number. |
|
int |
getRowCount()
This function returns the row count for the rowset at the time of calling it. |
|
java.sql.RowId |
getRowId(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java
programming language. |
|
java.sql.RowId |
getRowId(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java
programming language. |
|
short |
getShort(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a short in the Java programming language. |
|
short |
getShort(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a short in the Java programming language. |
|
java.sql.SQLXML |
getSQLXML(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet as a
java.sql.SQLXML object in the Java programming language. |
|
java.sql.SQLXML |
getSQLXML(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet as a
java.sql.SQLXML object in the Java programming language. |
|
java.sql.Statement |
getStatement()
Javadoc taken from RowSet interface : Retrieves the Statement object that produced this
ResultSet object. |
|
java.lang.String |
getStatementId()
Gets the ID of the Statement used to generate this RowSet. |
|
java.sql.Statement |
getStatementWE()
Convenience function. |
|
java.lang.String |
getString(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a String in the Java programming language. |
|
java.lang.String |
getString(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a String in the Java programming language. |
|
java.sql.Time |
getTime(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Time object in the Java programming language. |
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object
in the Java programming language. |
|
java.sql.Time |
getTime(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Time object in the Java programming language. |
|
java.sql.Time |
getTime(java.lang.String columnLabel,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object
in the Java programming language. |
|
java.sql.Timestamp |
getTimestamp(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Timestamp object in the Java programming language. |
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Timestamp object in the Java programming language. |
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
|
int |
getTransactionIsolation()
Javadoc taken from RowSet interface : Retrieves the transaction isolation level set for this RowSet object. |
|
int |
getType()
Javadoc taken from RowSet interface : Retrieves the type of this ResultSet object. |
|
java.util.Map<java.lang.String,java.lang.Class<?>> |
getTypeMap()
Javadoc taken from RowSet interface : Retrieves the Map object associated with this
RowSet object, which specifies the custom mapping
of SQL user-defined types, if any. |
|
java.lang.String |
getUrl()
Javadoc taken from RowSet interface : Retrieves the url property this RowSet object will use to
create a connection if it uses the DriverManager
instead of a DataSource object to establish the connection. |
|
java.net.URL |
getURL(int columnIndex)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL
object in the Java programming language. |
|
java.net.URL |
getURL(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL
object in the Java programming language. |
|
java.lang.String |
getUsername()
Javadoc taken from RowSet interface : Retrieves the username used to create a database connection for this RowSet object. |
|
java.sql.SQLWarning |
getWarnings()
Javadoc taken from RowSet interface : Retrieves the first warning reported by calls on this ResultSet object. |
|
void |
insertRow()
Javadoc taken from RowSet interface : Inserts the contents of the insert row into this ResultSet object and into the database. |
|
boolean |
isAfterLast()
Javadoc taken from RowSet interface : Retrieves whether the cursor is after the last row in this ResultSet object. |
|
boolean |
isBeforeFirst()
Javadoc taken from RowSet interface : Retrieves whether the cursor is before the first row in this ResultSet object. |
|
boolean |
isClosed()
Javadoc taken from RowSet interface : Retrieves whether this ResultSet object has been closed. |
|
boolean |
isFirst()
Javadoc taken from RowSet interface : Retrieves whether the cursor is on the first row of this ResultSet object. |
|
boolean |
isLast()
Javadoc taken from RowSet interface : Retrieves whether the cursor is on the last row of this ResultSet object. |
|
boolean |
isReadOnly()
Javadoc taken from RowSet interface : Retrieves whether this RowSet object is read-only. |
|
boolean |
isWrapperFor(java.lang.Class<?> iface)
Javadoc taken from RowSet interface : Returns true if this either implements the interface argument or is directly or indirectly a wrapper Javadoc taken from RowSet interface : for an object that does. |
|
boolean |
last()
Javadoc taken from RowSet interface : Moves the cursor to the last row in this ResultSet object. |
|
void |
moveToCurrentRow()
Javadoc taken from RowSet interface : Moves the cursor to the remembered cursor position, usually the current row. |
|
void |
moveToInsertRow()
Javadoc taken from RowSet interface : Moves the cursor to the insert row. |
|
boolean |
next()
Javadoc taken from RowSet interface : Moves the cursor froward one row from its current position. |
|
boolean |
nextWE()
Javadoc taken from RowSet interface : ILptsRowset interface function. |
|
boolean |
previous()
Javadoc taken from RowSet interface : Moves the cursor to the previous row in this ResultSet object. |
|
void |
refreshRow()
Javadoc taken from RowSet interface : Refreshes the current row with its most recent value in the database. |
|
boolean |
relative(int rows)
Javadoc taken from RowSet interface : Moves the cursor a relative number of rows, either positive or negative. |
|
void |
removeRowSetListener(javax.sql.RowSetListener listener)
Javadoc taken from RowSet interface : Removes the specified listener from the list of components that will be notified when an event occurs on this RowSet object. |
|
boolean |
rowDeleted()
Javadoc taken from RowSet interface : Retrieves whether a row has been deleted. |
|
boolean |
rowInserted()
Javadoc taken from RowSet interface : Retrieves whether the current row has had an insertion. |
|
boolean |
rowUpdated()
Javadoc taken from RowSet interface : Retrieves whether the current row has been updated. |
|
void |
setArray(int i,
java.sql.Array x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given Array value. |
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given input stream. |
|
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.io.InputStream value. |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given input stream. |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.math.BigDeciaml value. |
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.math.BigDecimal value. |
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given input stream. |
|
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.io.InputStream value. |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given input stream. |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void |
setBlob(int i,
java.sql.Blob x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given Blob value. |
|
void |
setBlob(int parameterIndex,
java.io.InputStream inputStream)
Javadoc taken from RowSet interface : Sets the designated parameter to a InputStream object. |
|
void |
setBlob(int parameterIndex,
java.io.InputStream inputStream,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a InputStream object. |
|
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Blob object. |
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
Javadoc taken from RowSet interface : Sets the designated parameter to a InputStream object. |
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a InputStream object. |
|
void |
setBoolean(int parameterIndex,
boolean x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java boolean value. |
|
void |
setBoolean(java.lang.String parameterName,
boolean x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java boolean value. |
|
void |
setByte(int parameterIndex,
byte x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java byte value. |
|
void |
setByte(java.lang.String parameterName,
byte x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java byte value. |
|
void |
setBytes(int parameterIndex,
byte[] x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java array of byte values. |
|
void |
setBytes(java.lang.String parameterName,
byte[] x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java array of bytes. |
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Reader
object. |
|
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.io.Reader value. |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Reader
object. |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Reader
object, which is the given number of characters long. |
|
void |
setCharSet(java.lang.String charSet)
Set the charset to tbe used for String processing by the rowset. |
|
void |
setClob(int i,
java.sql.Clob x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given Clob value. |
|
void |
setClob(int parameterIndex,
java.io.Reader reader)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setClob(int parameterIndex,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setClob(java.lang.String parameterName,
java.sql.Clob x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Clob object. |
|
void |
setClob(java.lang.String parameterName,
java.io.Reader reader)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setCommand(java.lang.String cmd)
Javadoc taken from RowSet interface : Sets this RowSet object's command property to the given
SQL query. |
|
void |
setConcurrency(int concurrency)
Javadoc taken from RowSet interface : Sets the concurrency of this RowSet object to the given
concurrency level. |
|
void |
setDataSourceName(java.lang.String name)
Javadoc taken from RowSet interface : Sets the data source name property for this RowSet object to the
given String . |
|
void |
setDate(int parameterIndex,
java.sql.Date x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.sql.Date value. |
|
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given java.sql.Date value. |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Date value
using the default time zone of the virtual machine that is running
the application. |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Date value,
using the given Calendar object. |
|
void |
setDouble(int parameterIndex,
double x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java double value. |
|
void |
setDouble(java.lang.String parameterName,
double x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java double value. |
|
void |
setEscapeProcessing(boolean enable)
Javadoc taken from RowSet interface : Sets escape processing for this RowSet object on or
off. |
|
void |
setFetchDirection(int direction)
Javadoc taken from RowSet interface : Gives a hint as to the direction in which the rows in this ResultSet object will be processed. |
|
void |
setFetchSize(int rows)
Javadoc taken from RowSet interface : Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. |
|
void |
setFloat(int parameterIndex,
float x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java float value. |
|
void |
setFloat(java.lang.String parameterName,
float x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java float value. |
|
void |
setInt(int parameterIndex,
int x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java int value. |
|
void |
setInt(java.lang.String parameterName,
int x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java int value. |
|
void |
setLong(int parameterIndex,
long x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java long value. |
|
void |
setLong(java.lang.String parameterName,
long x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java long value. |
|
void |
setMaxFieldSize(int max)
Javadoc taken from RowSet interface : Sets the maximum number of bytes that can be returned for a column value to the given number of bytes. |
|
void |
setMaxRows(int max)
Javadoc taken from RowSet interface : Sets the maximum number of rows that this RowSet
object can contain to the specified number. |
|
void |
setNCharacterStream(int parameterIndex,
java.io.Reader value)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to a Reader object. |
|
void |
setNCharacterStream(int parameterIndex,
java.io.Reader value,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNClob(int parameterIndex,
java.sql.NClob value)
Javadoc taken from RowSet interface : Sets the designated parameter to a java.sql.NClob object. |
|
void |
setNClob(int parameterIndex,
java.io.Reader reader)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNClob(int parameterIndex,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value)
Javadoc taken from RowSet interface : Sets the designated parameter to a java.sql.NClob object. |
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Sets the designated parameter to a Reader object. |
|
void |
setNString(int parameterIndex,
java.lang.String value)
Javadoc taken from RowSet interface : Sets the designated paramter to the given String object. |
|
void |
setNString(java.lang.String parameterName,
java.lang.String value)
Javadoc taken from RowSet interface : Sets the designated paramter to the given String object. |
|
void |
setNull(int parameterIndex,
int sqlType)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's SQL
command to SQL NULL . |
|
void |
setNull(int paramIndex,
int sqlType,
java.lang.String typeName)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's SQL
command to SQL NULL . |
|
void |
setNull(java.lang.String parameterName,
int sqlType)
Javadoc taken from RowSet interface : Sets the designated parameter to SQL NULL . |
|
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Javadoc taken from RowSet interface : Sets the designated parameter to SQL NULL . |
|
void |
setObject(int parameterIndex,
java.lang.Object x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with a Java Object . |
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with a Java Object . |
|
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scaleOrLength)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given Java Object . |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x)
Javadoc taken from RowSet interface : Sets the value of the designated parameter with the given object. |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
Javadoc taken from RowSet interface : Sets the value of the designated parameter with the given object. |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
Javadoc taken from RowSet interface : Sets the value of the designated parameter with the given object. |
|
void |
setPassword(java.lang.String password)
Javadoc taken from RowSet interface : Sets the database password for this RowSet object to
the given String . |
|
void |
setQueryTimeout(int seconds)
Javadoc taken from RowSet interface : Sets the maximum time the driver will wait for a statement to execute to the given number of seconds. |
|
void |
setReadOnly(boolean value)
Javadoc taken from RowSet interface : Sets whether this RowSet object is read-only to the
given boolean . |
|
void |
setRef(int i,
java.sql.Ref x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given Ref value. |
|
void |
setRowId(int parameterIndex,
java.sql.RowId x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.RowId object. |
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.RowId object. |
|
void |
setShort(int parameterIndex,
short x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java short value. |
|
void |
setShort(java.lang.String parameterName,
short x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java short value. |
|
void |
setSQLXML(int parameterIndex,
java.sql.SQLXML xmlObject)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.SQLXML object. |
|
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.SQLXML object. |
|
void |
setString(int parameterIndex,
java.lang.String x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given Java String value. |
|
void |
setString(java.lang.String parameterName,
java.lang.String x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given Java String value. |
|
void |
setTime(int parameterIndex,
java.sql.Time x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.sql.Time value. |
|
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given java.sql.Time value. |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Time value. |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Time value,
using the given Calendar object. |
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
to the given java.sql.Timestamp value. |
|
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Sets the designated parameter in this RowSet object's command
with the given java.sql.Timestamp value. |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Timestamp value. |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.sql.Timestamp value,
using the given Calendar object. |
|
void |
setTransactionIsolation(int level)
Javadoc taken from RowSet interface : Sets the transaction isolation level for this RowSet obejct. |
|
void |
setType(int type)
Javadoc taken from RowSet interface : Sets the type of this RowSet object to the given type. |
|
void |
setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
Javadoc taken from RowSet interface : Installs the given java.util.Map object as the default
type map for this RowSet object. |
|
void |
setURL(int parameterIndex,
java.net.URL x)
Javadoc taken from RowSet interface : Sets the designated parameter to the given java.net.URL value. |
|
void |
setUrl(java.lang.String url)
Javadoc taken from RowSet interface : Sets the URL this RowSet object will use when it uses the
DriverManager to create a connection. |
|
void |
setUsername(java.lang.String name)
Javadoc taken from RowSet interface : Sets the username property for this RowSet object to the
given String . |
|
|
unwrap(java.lang.Class<T> iface)
Javadoc taken from RowSet interface : Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. |
|
void |
updateArray(int columnIndex,
java.sql.Array x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Array value. |
|
void |
updateArray(java.lang.String columnLabel,
java.sql.Array x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Array value. |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x)
Javadoc taken from RowSet interface : Updates the designated column with an ascii stream value. |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
Javadoc taken from RowSet interface : Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
Javadoc taken from RowSet interface : Updates the designated column with an ascii stream value. |
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Javadoc taken from RowSet interface : Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
Javadoc taken from RowSet interface : Updates the designated column with a java.math.BigDecimal
value. |
|
void |
updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.BigDecimal
value. |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x)
Javadoc taken from RowSet interface : Updates the designated column with a binary stream value. |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
Javadoc taken from RowSet interface : Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
Javadoc taken from RowSet interface : Updates the designated column with a binary stream value. |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
Javadoc taken from RowSet interface : Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
Javadoc taken from RowSet interface : Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void |
updateBlob(int columnIndex,
java.sql.Blob x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Blob value. |
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream)
Javadoc taken from RowSet interface : Updates the designated column using the given input stream. |
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length)
Javadoc taken from RowSet interface : Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void |
updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Blob value. |
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream)
Javadoc taken from RowSet interface : Updates the designated column using the given input stream. |
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length)
Javadoc taken from RowSet interface : Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void |
updateBoolean(int columnIndex,
boolean x)
Javadoc taken from RowSet interface : Updates the designated column with a boolean value. |
|
void |
updateBoolean(java.lang.String columnLabel,
boolean x)
Javadoc taken from RowSet interface : Updates the designated column with a boolean value. |
|
void |
updateByte(int columnIndex,
byte x)
Javadoc taken from RowSet interface : Updates the designated column with a byte value. |
|
void |
updateByte(java.lang.String columnLabel,
byte x)
Javadoc taken from RowSet interface : Updates the designated column with a byte value. |
|
void |
updateBytes(int columnIndex,
byte[] x)
Javadoc taken from RowSet interface : Updates the designated column with a byte array value. |
|
void |
updateBytes(java.lang.String columnLabel,
byte[] x)
Javadoc taken from RowSet interface : Updates the designated column with a byte array value. |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value. |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value. |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
int length)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateClob(int columnIndex,
java.sql.Clob x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Clob value. |
|
void |
updateClob(int columnIndex,
java.io.Reader reader)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object. |
|
void |
updateClob(int columnIndex,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object, which is the given number of characters long. |
|
void |
updateClob(java.lang.String columnLabel,
java.sql.Clob x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Clob value. |
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object. |
|
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object, which is the given number of characters long. |
|
void |
updateDate(int columnIndex,
java.sql.Date x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Date value. |
|
void |
updateDate(java.lang.String columnLabel,
java.sql.Date x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Date value. |
|
void |
updateDouble(int columnIndex,
double x)
Javadoc taken from RowSet interface : Updates the designated column with a double value. |
|
void |
updateDouble(java.lang.String columnLabel,
double x)
Javadoc taken from RowSet interface : Updates the designated column with a double value. |
|
void |
updateFloat(int columnIndex,
float x)
Javadoc taken from RowSet interface : Updates the designated column with a float value. |
|
void |
updateFloat(java.lang.String columnLabel,
float x)
Javadoc taken from RowSet interface : Updates the designated column with a float value. |
|
void |
updateInt(int columnIndex,
int x)
Javadoc taken from RowSet interface : Updates the designated column with an int value. |
|
void |
updateInt(java.lang.String columnLabel,
int x)
Javadoc taken from RowSet interface : Updates the designated column with an int value. |
|
void |
updateLong(int columnIndex,
long x)
Javadoc taken from RowSet interface : Updates the designated column with a long value. |
|
void |
updateLong(java.lang.String columnLabel,
long x)
Javadoc taken from RowSet interface : Updates the designated column with a long value. |
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value. |
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value. |
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void |
updateNClob(int columnIndex,
java.sql.NClob nClob)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.NClob value. |
|
void |
updateNClob(int columnIndex,
java.io.Reader reader)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
The data will be read from the stream
as needed until end-of-stream is reached. |
|
void |
updateNClob(int columnIndex,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object, which is the given number of characters long. |
|
void |
updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.NClob value. |
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object. |
|
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
Javadoc taken from RowSet interface : Updates the designated column using the given Reader
object, which is the given number of characters long. |
|
void |
updateNString(int columnIndex,
java.lang.String nString)
Javadoc taken from RowSet interface : Updates the designated column with a String value. |
|
void |
updateNString(java.lang.String columnLabel,
java.lang.String nString)
Javadoc taken from RowSet interface : Updates the designated column with a String value. |
|
void |
updateNull(int columnIndex)
Javadoc taken from RowSet interface : Updates the designated column with a null value. |
|
void |
updateNull(java.lang.String columnLabel)
Javadoc taken from RowSet interface : Updates the designated column with a null value. |
|
void |
updateObject(int columnIndex,
java.lang.Object x)
Javadoc taken from RowSet interface : Updates the designated column with an Object value. |
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scaleOrLength)
Javadoc taken from RowSet interface : Updates the designated column with an Object value. |
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x)
Javadoc taken from RowSet interface : Updates the designated column with an Object value. |
|
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x,
int scaleOrLength)
Javadoc taken from RowSet interface : Updates the designated column with an Object value. |
|
void |
updateRef(int columnIndex,
java.sql.Ref x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Ref value. |
|
void |
updateRef(java.lang.String columnLabel,
java.sql.Ref x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Ref value. |
|
void |
updateRow()
Javadoc taken from RowSet interface : Updates the underlying database with the new contents of the current row of this ResultSet object. |
|
void |
updateRowId(int columnIndex,
java.sql.RowId x)
Javadoc taken from RowSet interface : Updates the designated column with a RowId value. |
|
void |
updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
Javadoc taken from RowSet interface : Updates the designated column with a RowId value. |
|
void |
updateShort(int columnIndex,
short x)
Javadoc taken from RowSet interface : Updates the designated column with a short value. |
|
void |
updateShort(java.lang.String columnLabel,
short x)
Javadoc taken from RowSet interface : Updates the designated column with a short value. |
|
void |
updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.SQLXML value. |
|
void |
updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.SQLXML value. |
|
void |
updateString(int columnIndex,
java.lang.String x)
Javadoc taken from RowSet interface : Updates the designated column with a String value. |
|
void |
updateString(java.lang.String columnLabel,
java.lang.String x)
Javadoc taken from RowSet interface : Updates the designated column with a String value. |
|
void |
updateTime(int columnIndex,
java.sql.Time x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Time value. |
|
void |
updateTime(java.lang.String columnLabel,
java.sql.Time x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Time value. |
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Timestamp
value. |
|
void |
updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
Javadoc taken from RowSet interface : Updates the designated column with a java.sql.Timestamp
value. |
|
boolean |
wasNull()
Javadoc taken from RowSet interface : Reports whether the last column read had a value of SQL NULL . |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface java.sql.ResultSet |
---|
getBigDecimal, getBigDecimal, getUnicodeStream, getUnicodeStream |
Constructor Detail |
---|
public TLptsRowSet(TLptsStatement statement, java.sql.ResultSet resultSet)
Constructor for a TLptsRowSet.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes :
statement
- The statement to be executed.resultSet
- The resultset which was derived from the PrepareStatement of TLptsStatement.public TLptsRowSet(TLptsStatement statement, javax.sql.RowSet rowSet)
Constructor for a TLptsRowSet.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes :
statement
- The statement to be executed.rowSet
- The external rowset to wrap.Method Detail |
---|
public boolean absolute(int row) throws java.sql.SQLException
ResultSet
object.
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to
an absolute row position with respect to
the end of the result set. For example, calling the method
absolute(-1)
positions the
cursor on the last row; calling the method absolute(-2)
moves the cursor to the next-to-last row, and so on.
An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.
Note: Calling absolute(1)
is the same
as calling first()
. Calling absolute(-1)
is the same as calling last()
.
absolute
in interface java.sql.ResultSet
row
- the number of the row to which the cursor should move.
A positive number indicates the row number counting from the
beginning of the result set; a negative number indicates the
row number counting from the end of the result set
true
if the cursor is moved to a position in this
ResultSet
object;
false
if the cursor is before the first row or after the
last row
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set
or the result set type is TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void addRowSetListener(javax.sql.RowSetListener listener)
RowSet
object.
addRowSetListener
in interface javax.sql.RowSet
listener
- a component that has implemented the RowSetListener
interface and wants to be notified when events occur on this
RowSet
objectremoveRowSetListener(javax.sql.RowSetListener)
public void afterLast() throws java.sql.SQLException
ResultSet
object, just after the
last row. This method has no effect if the result set contains no rows.
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set
or the result set type is TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void beforeFirst() throws java.sql.SQLException
ResultSet
object, just before the
first row. This method has no effect if the result set contains no rows.
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set or the
result set type is TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void cancelRowUpdates() throws java.sql.SQLException
ResultSet
object.
This method may be called after calling an
updater method(s) and before calling
the method updateRow
to roll back
the updates made to a row. If no updates have been made or
updateRow
has already been called, this method has no
effect.
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set;
the result set concurrency is CONCUR_READ_ONLY
or if this method is called when the cursor is
on the insert row
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void clearParameters() throws java.sql.SQLException
RowSet
object's command.
In general, parameter values remain in force for repeated use of a
RowSet
object. Setting a parameter value automatically clears its
previous value. However, in some cases it is useful to immediately
release the resources used by the current parameter values, which can
be done by calling the method clearParameters
.
clearParameters
in interface javax.sql.RowSet
java.sql.SQLException
- if a database access error occurspublic void clearWarnings() throws java.sql.SQLException
ResultSet
object.
After this method is called, the method getWarnings
returns null
until a new warning is
reported for this ResultSet
object.
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result setpublic void close() throws java.sql.SQLException
ResultSet
object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
The closing of a ResultSet
object does not close the Blob
,
Clob
or NClob
objects created by the ResultSet
. Blob
,
Clob
or NClob
objects remain valid for at least the duration of the
transaction in which they are creataed, unless their free
method is invoked.
ResultSet
is closed, any ResultSetMetaData
instances that were created by calling the getMetaData
method remain accessible.
Note: A ResultSet
object
is automatically closed by the
Statement
object that generated it when
that Statement
object is closed,
re-executed, or is used to retrieve the next result from a
sequence of multiple results.
close
on a ResultSet
object that is already closed is a no-op.
close
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurspublic void closeWE()
ResultSet
object's database and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
The closing of a ResultSet
object does not close the Blob
,
Clob
or NClob
objects created by the ResultSet
. Blob
,
Clob
or NClob
objects remain valid for at least the duration of the
transaction in which they are creataed, unless their free
method is invoked.
ResultSet
is closed, any ResultSetMetaData
instances that were created by calling the getMetaData
method remain accessible.
Note: A ResultSet
object
is automatically closed by the
Statement
object that generated it when
that Statement
object is closed,
re-executed, or is used to retrieve the next result from a
sequence of multiple results.
close
on a ResultSet
object that is already closed is a no-op.
public void deleteRow() throws java.sql.SQLException
ResultSet
object
and from the underlying database. This method cannot be called when
the cursor is on the insert row.
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
;
this method is called on a closed result set
or if this method is called when the cursor is on the insert row
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void execute() throws java.sql.SQLException
RowSet
object with data.
The execute
method may use the following properties
to create a connection for reading data: url, data source name,
user name, password, transaction isolation, and type map.
The execute
method may use the following properties
to create a statement to execute a command:
command, read only, maximum field size,
maximum rows, escape processing, and query timeout.
If the required properties have not been set, an exception is
thrown. If this method is successful, the current contents of the rowset are
discarded and the rowset's metadata is also (re)set. If there are
outstanding updates, they are ignored.
If this RowSet
object does not maintain a continuous connection
with its source of data, it may use a reader (a RowSetReader
object) to fill itself with data. In this case, a reader will have been
registered with this RowSet
object, and the method
execute
will call on the reader's readData
method as part of its implementation.
execute
in interface javax.sql.RowSet
java.sql.SQLException
- if a database access error occurs or any of the
properties necessary for making a connection and creating
a statement have not been setpublic int findColumn(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
column label to its
ResultSet
column index.
findColumn
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
java.sql.SQLException
- if the ResultSet
object
does not contain a column labeled columnLabel
, a database access error occurs
or this method is called on a closed result setpublic boolean first() throws java.sql.SQLException
ResultSet
object.
first
in interface java.sql.ResultSet
true
if the cursor is on a valid row;
false
if there are no rows in the result set
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set
or the result set type is TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
ResultSet
object as an Array
object
in the Java programming language.
getArray
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
Array
object representing the SQL
ARRAY
value in the specified column
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.Array getArray(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as an Array
object
in the Java programming language.
getArray
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Array
object representing the SQL ARRAY
value in
the specified column
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a stream of ASCII characters. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
getAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.io.InputStream getAsciiStream(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a stream of
ASCII characters. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values.
The JDBC driver will
do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
getAsciiStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
,
the value returned is null
.
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
ResultSet
object as a
java.math.BigDecimal
with full precision.
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the value returned is
null
in the Java programming language.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.math.BigDecimal getBigDecimal(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a
java.math.BigDecimal
with full precision.
getBigDecimal
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the value returned is
null
in the Java programming language.
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as a stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
getBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the value returned is
null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.io.InputStream getBinaryStream(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a stream of uninterpreted
byte
s.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be
read prior to getting the value of any other column. The next
call to a getter method implicitly closes the stream. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
getBinaryStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the result is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
ResultSet
object as a Blob
object
in the Java programming language.
getBlob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
Blob
object representing the SQL
BLOB
value in the specified column
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.Blob getBlob(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a Blob
object
in the Java programming language.
getBlob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Blob
object representing the SQL BLOB
value in the specified column
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean getBoolean(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a boolean
in the Java programming language.
If the designated column has a datatype of CHAR or VARCHAR
and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
and contains a 0, a value of false
is returned. If the designated column has a datatype
of CHAR or VARCHAR
and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
and contains a 1, a value of true
is returned.
getBoolean
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is false
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic boolean getBoolean(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a boolean
in the Java programming language.
If the designated column has a datatype of CHAR or VARCHAR
and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
and contains a 0, a value of false
is returned. If the designated column has a datatype
of CHAR or VARCHAR
and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT
and contains a 1, a value of true
is returned.
getBoolean
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is false
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic byte getByte(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a byte
in the Java programming language.
getByte
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic byte getByte(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a byte
in the Java programming language.
getByte
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic byte[] getBytes(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.
getBytes
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic byte[] getBytes(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.
getBytes
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.
getCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming language.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.io.Reader getCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.
getCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming language
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.lang.String getCharSet()
This is the charset used for encoding the string values.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes :When the row event is generated by the internal processing of the rowset, the string objects are contained in a specialised
class, which holds both the driver supplied string and the raw bytes for encoding with other charsets.
The function getCurrentRowObjectLists()
utilises this charset and processes the string types.
public java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
ResultSet
object as a Clob
object
in the Java programming language.
getClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
Clob
object representing the SQL
CLOB
value in the specified column
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.Clob getClob(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a Clob
object
in the Java programming language.
getClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Clob
object representing the SQL CLOB
value in the specified column
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.util.List<java.lang.String> getColumnNames()
private void processRowSet(TLptsRowSet rowSet) { ListcolumnHeaders = rowSet.getColumnNames(); displayRowSetInTable(rowSet,columnHeaders); }
public java.util.List<java.lang.String> getColumnNames(java.util.Set<java.lang.Integer> columnIndexes)
This function gets the requested column names for the current rowset by their index.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : Never, an empty list in the worst case. Notes : Example :private void processRowSet(TLptsRowSet rowSet, SetcolumnIndexes) { //Column Indexes are 1,3,5, so getColumnNames will return names //for the first, third and fifth columns. List columnHeaders = rowSet.getColumnNames(columnIndexes); displayRowSetInTable(rowSet,columnHeaders); }
columnIndexes
- The column indexes (1 based) of the columns for which the names are required.
public java.lang.String getCommand()
RowSet
object's command property.
The command property contains a command string, which must be an SQL
query, that can be executed to fill the rowset with data.
The default value is null
.
getCommand
in interface javax.sql.RowSet
null
setCommand(java.lang.String)
public int getConcurrency() throws java.sql.SQLException
ResultSet
object.
The concurrency used is determined by the
Statement
object that created the result set.
getConcurrency
in interface java.sql.ResultSet
ResultSet.CONCUR_READ_ONLY
or ResultSet.CONCUR_UPDATABLE
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result setpublic TLptsRowSet.ResultSetObjectLists getCurrentRowObjectLists()
TLptsRowSet.ResultSetObjectLists
.
private void processRowSet(TLptsRowSet rowSet) { ResultSetObjectLists rso = rowSet.getCurrentRowObjectLists(); for(Object obj : rs.getObjectList()) processObject(obj); }
public java.lang.String getCursorName() throws java.sql.SQLException
ResultSet
object.
In SQL, a result table is retrieved through a cursor that is
named. The current row of a result set can be updated or deleted
using a positioned update/delete statement that references the
cursor name. To insure that the cursor has the proper isolation
level to support update, the cursor's SELECT
statement
should be of the form SELECT FOR UPDATE
. If
FOR UPDATE
is omitted, the positioned updates may fail.
The JDBC API supports this SQL feature by providing the name of the
SQL cursor used by a ResultSet
object.
The current row of a ResultSet
object
is also the current row of this SQL cursor.
getCursorName
in interface java.sql.ResultSet
ResultSet
object's cursor
java.sql.SQLException
- if a database access error occurs or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.String getDataSourceName()
RowSet
object.
getDataSourceName
in interface javax.sql.RowSet
setDataSourceName(java.lang.String)
,
setUrl(java.lang.String)
public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a java.sql.Date
object in the Java programming language.
getDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Date
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the date if the underlying database does not store
timezone information.
getDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar
object
to use in constructing the date
java.sql.Date
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setpublic java.sql.Date getDate(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a java.sql.Date
object in the Java programming language.
getDate
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Date getDate(java.lang.String columnLabel, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Date
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the date if the underlying database does not store
timezone information.
getDate
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columncal
- the java.util.Calendar
object
to use in constructing the date
java.sql.Date
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setpublic double getDouble(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a double
in the Java programming language.
getDouble
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic double getDouble(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a double
in the Java programming language.
getDouble
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic boolean getEscapeProcessing() throws java.sql.SQLException
RowSet
object.
If escape scanning is enabled, which is the default, the driver will do
escape substitution before sending an SQL statement to the database.
getEscapeProcessing
in interface javax.sql.RowSet
true
if escape processing is enabled;
false
if it is disabled
java.sql.SQLException
- if a database access error occurssetEscapeProcessing(boolean)
public int getFetchDirection() throws java.sql.SQLException
ResultSet
object.
getFetchDirection
in interface java.sql.ResultSet
ResultSet
object
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result setsetFetchDirection(int)
public int getFetchSize() throws java.sql.SQLException
ResultSet
object.
getFetchSize
in interface java.sql.ResultSet
ResultSet
object
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result setsetFetchSize(int)
public float getFloat(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a float
in the Java programming language.
getFloat
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic float getFloat(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a float
in the Java programming language.
getFloat
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic int getHoldability() throws java.sql.SQLException
ResultSet
object
getHoldability
in interface java.sql.ResultSet
ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result setpublic java.lang.String getId()
Gets this TLptsRowSet's ID.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes : Example :private String rowSetId; .. private void processRowSet(TLptsRowSet rowSet) { if(rowSet.getId.equals(rowSetId)) process(rowSet); else TLPtsLogger.logError("Wrong RowSet to process",null); }
public int getInt(int columnIndex) throws java.sql.SQLException
ResultSet
object as
an int
in the Java programming language.
getInt
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic int getInt(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
an int
in the Java programming language.
getInt
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic long getLong(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a long
in the Java programming language.
getLong
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic long getLong(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a long
in the Java programming language.
getLong
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic int getMaxFieldSize() throws java.sql.SQLException
BINARY
,
VARBINARY
, LONGVARBINARYBINARY
, CHAR
,
VARCHAR
, LONGVARCHAR
, NCHAR
and NVARCHAR
columns.
If the limit is exceeded, the excess data is silently discarded.
getMaxFieldSize
in interface javax.sql.RowSet
java.sql.SQLException
- if a database access error occurssetMaxFieldSize(int)
public int getMaxRows() throws java.sql.SQLException
RowSet
object can contain.
If the limit is exceeded, the excess rows are silently dropped.
getMaxRows
in interface javax.sql.RowSet
RowSet
object can contain; zero means unlimited
java.sql.SQLException
- if a database access error occurssetMaxRows(int)
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
ResultSet
object's columns.
getMetaData
in interface java.sql.ResultSet
ResultSet
object's columns
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result setpublic java.io.Reader getNCharacterStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.
It is intended for use when
accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming language.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.io.Reader getNCharacterStream(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.
It is intended for use when
accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming language
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.NClob getNClob(int columnIndex) throws java.sql.SQLException
ResultSet
object as a NClob
object
in the Java programming language.
getNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NClob
object representing the SQL
NCLOB
value in the specified column
java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set
or if a database access error occurs
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.NClob getNClob(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a NClob
object
in the Java programming language.
getNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NClob
object representing the SQL NCLOB
value in the specified column
java.sql.SQLException
- if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set
or if a database access error occurs
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.String getNString(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a String
in the Java programming language.
It is intended for use when
accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.String getNString(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a String
in the Java programming language.
It is intended for use when
accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
Gets the value of the designated column in the current row
of this ResultSet
object as
an Object
in the Java programming language.
This method will return the value of the given column as a
Java object. The type of the Java object will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification. If the value is an SQL NULL
,
the driver returns a Java null
.
This method may also be used to read database-specific abstract data types.
In the JDBC 2.0 API, the behavior of methodgetObject
is extended to materialize
data of SQL user-defined types.
If Connection.getTypeMap
does not throw a
SQLFeatureNotSupportedException
,
then when a column contains a structured or distinct value,
the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
If Connection.getTypeMap
does throw a
SQLFeatureNotSupportedException
,
then structured values are not supported, and distinct values
are mapped to the default Java class as determined by the
underlying SQL type of the DISTINCT type.
getObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.lang.Object
holding the column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
ResultSet
object as an Object
in the Java programming language.
If the value is an SQL NULL
,
the driver returns a Java null
.
This method uses the given Map
object
for the custom mapping of the
SQL structured or distinct type that is being retrieved.
getObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...map
- a java.util.Map
object that contains the mapping
from SQL type names to classes in the Java programming language
Object
in the Java programming language
representing the SQL value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.Object getObject(java.lang.String columnLabel) throws java.sql.SQLException
Gets the value of the designated column in the current row
of this ResultSet
object as
an Object
in the Java programming language.
This method will return the value of the given column as a
Java object. The type of the Java object will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification. If the value is an SQL NULL
,
the driver returns a Java null
.
getObject
is extended to materialize
data of SQL user-defined types. When a column contains
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
java.lang.Object
holding the column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.lang.Object getObject(java.lang.String columnLabel, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
ResultSet
object as an Object
in the Java programming language.
If the value is an SQL NULL
,
the driver returns a Java null
.
This method uses the specified Map
object for
custom mapping if appropriate.
getObject
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnmap
- a java.util.Map
object that contains the mapping
from SQL type names to classes in the Java programming language
Object
representing the SQL value in the
specified column
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.String getPassword()
execute
. It is not usually part of the serialized state
of a RowSet
object.
getPassword
in interface javax.sql.RowSet
setPassword(java.lang.String)
public int getQueryTimeout() throws java.sql.SQLException
SQLException
is thrown.
getQueryTimeout
in interface javax.sql.RowSet
java.sql.SQLException
- if a database access error occurssetQueryTimeout(int)
public java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
ResultSet
object as a Ref
object
in the Java programming language.
getRef
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
Ref
object representing an SQL REF
value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.Ref getRef(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a Ref
object
in the Java programming language.
getRef
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Ref
object representing the SQL REF
value in the specified column
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic int getRow() throws java.sql.SQLException
getRow
method
is optional for ResultSet
s with a result
set type of TYPE_FORWARD_ONLY
getRow
in interface java.sql.ResultSet
0
if there is no current row
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic int getRowCount()
This function returns the row count for the rowset at the time of calling it.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes :
public java.sql.RowId getRowId(int columnIndex) throws java.sql.SQLException
ResultSet
object as a java.sql.RowId
object in the Java
programming language.
getRowId
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...
NULL
the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.RowId getRowId(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a java.sql.RowId
object in the Java
programming language.
getRowId
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
the
value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic short getShort(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a short
in the Java programming language.
getShort
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic short getShort(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a short
in the Java programming language.
getShort
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.SQLXML getSQLXML(int columnIndex) throws java.sql.SQLException
ResultSet
as a
java.sql.SQLXML
object in the Java programming language.
getSQLXML
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
SQLXML
object that maps an SQL XML
value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.SQLXML getSQLXML(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
as a
java.sql.SQLXML
object in the Java programming language.
getSQLXML
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
SQLXML
object that maps an SQL XML
value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.sql.Statement getStatement() throws java.sql.SQLException
Statement
object that produced this
ResultSet
object.
If the result set was generated some other way, such as by a
DatabaseMetaData
method, this method may return
null
.
getStatement
in interface java.sql.ResultSet
Statment
object that produced
this ResultSet
object or null
if the result set was produced some other way
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result setpublic java.lang.String getStatementId()
Gets the ID of the Statement used to generate this RowSet.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes :
public java.sql.Statement getStatementWE()
TLptsLogger
contains the error.public java.lang.String getString(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a String
in the Java programming language.
getString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.lang.String getString(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a String
in the Java programming language.
getString
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a java.sql.Time
object in the Java programming language.
getTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Time
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the time if the underlying database does not store
timezone information.
getTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar
object
to use in constructing the time
java.sql.Time
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setpublic java.sql.Time getTime(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a java.sql.Time
object in the Java programming language.
getTime
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
,
the value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Time getTime(java.lang.String columnLabel, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Time
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the time if the underlying database does not store
timezone information.
getTime
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columncal
- the java.util.Calendar
object
to use in constructing the time
java.sql.Time
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setpublic java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a java.sql.Timestamp
object in the Java programming language.
getTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
NULL
, the
value returned is null
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Timestamp
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.
getTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar
object
to use in constructing the timestamp
java.sql.Timestamp
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setpublic java.sql.Timestamp getTimestamp(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as
a java.sql.Timestamp
object in the Java programming language.
getTimestamp
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs or this method is
called on a closed result setpublic java.sql.Timestamp getTimestamp(java.lang.String columnLabel, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Timestamp
object
in the Java programming language.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.
getTimestamp
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columncal
- the java.util.Calendar
object
to use in constructing the date
java.sql.Timestamp
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnLabel is not valid or
if a database access error occurs
or this method is called on a closed result setpublic int getTransactionIsolation()
RowSet
object.
getTransactionIsolation
in interface javax.sql.RowSet
Connection.TRANSACTION_READ_UNCOMMITTED
,
Connection.TRANSACTION_READ_COMMITTED
,
Connection.TRANSACTION_REPEATABLE_READ
, or
Connection.TRANSACTION_SERIALIZABLE
setTransactionIsolation(int)
public int getType() throws java.sql.SQLException
ResultSet
object.
The type is determined by the Statement
object
that created the result set.
getType
in interface java.sql.ResultSet
ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
,
or ResultSet.TYPE_SCROLL_SENSITIVE
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result setpublic java.util.Map<java.lang.String,java.lang.Class<?>> getTypeMap() throws java.sql.SQLException
Map
object associated with this
RowSet
object, which specifies the custom mapping
of SQL user-defined types, if any. The default is for the
type map to be empty.
getTypeMap
in interface javax.sql.RowSet
java.util.Map
object containing the names of
SQL user-defined types and the Java classes to which they are
to be mapped
java.sql.SQLException
- if a database access error occurssetTypeMap(java.util.Map>)
public java.lang.String getUrl() throws java.sql.SQLException
RowSet
object will use to
create a connection if it uses the DriverManager
instead of a DataSource
object to establish the connection.
The default value is null
.
getUrl
in interface javax.sql.RowSet
java.sql.SQLException
- if a database access error occurssetUrl(java.lang.String)
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
ResultSet
object as a java.net.URL
object in the Java programming language.
getURL
in interface java.sql.ResultSet
columnIndex
- the index of the column 1 is the first, 2 is the second,...
java.net.URL
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs; this method
is called on a closed result set or if a URL is malformed
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.net.URL getURL(java.lang.String columnLabel) throws java.sql.SQLException
ResultSet
object as a java.net.URL
object in the Java programming language.
getURL
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
java.net.URL
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs; this method
is called on a closed result set or if a URL is malformed
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic java.lang.String getUsername()
RowSet
object.
The username property is set at run time before calling the method
execute
. It is
not usually part of the serialized state of a RowSet
object.
getUsername
in interface javax.sql.RowSet
setUsername(java.lang.String)
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
ResultSet
object.
Subsequent warnings on this ResultSet
object
will be chained to the SQLWarning
object that
this method returns.
The warning chain is automatically cleared each time a new
row is read. This method may not be called on a ResultSet
object that has been closed; doing so will cause an
SQLException
to be thrown.
ResultSet
methods. Any warning caused by
Statement
methods
(such as reading OUT parameters) will be chained on the
Statement
object.
getWarnings
in interface java.sql.ResultSet
SQLWarning
object reported or
null
if there are none
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result setpublic void insertRow() throws java.sql.SQLException
ResultSet
object and into the database.
The cursor must be on the insert row when this method is called.
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
,
this method is called on a closed result set,
if this method is called when the cursor is not on the insert row,
or if not all of non-nullable columns in
the insert row have been given a non-null value
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean isAfterLast() throws java.sql.SQLException
ResultSet
object.
Note:Support for the isAfterLast
method
is optional for ResultSet
s with a result
set type of TYPE_FORWARD_ONLY
isAfterLast
in interface java.sql.ResultSet
true
if the cursor is after the last row;
false
if the cursor is at any other position or the
result set contains no rows
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean isBeforeFirst() throws java.sql.SQLException
ResultSet
object.
Note:Support for the isBeforeFirst
method
is optional for ResultSet
s with a result
set type of TYPE_FORWARD_ONLY
isBeforeFirst
in interface java.sql.ResultSet
true
if the cursor is before the first row;
false
if the cursor is at any other position or the
result set contains no rows
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean isClosed() throws java.sql.SQLException
ResultSet
object has been closed. A ResultSet
is closed if the
method close has been called on it, or if it is automatically closed.
isClosed
in interface java.sql.ResultSet
ResultSet
object is closed; false if it is still open
java.sql.SQLException
- if a database access error occurspublic boolean isFirst() throws java.sql.SQLException
ResultSet
object.
Note:Support for the isFirst
method
is optional for ResultSet
s with a result
set type of TYPE_FORWARD_ONLY
isFirst
in interface java.sql.ResultSet
true
if the cursor is on the first row;
false
otherwise
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean isLast() throws java.sql.SQLException
ResultSet
object.
Note: Calling the method isLast
may be expensive
because the JDBC driver
might need to fetch ahead one row in order to determine
whether the current row is the last row in the result set.
Note: Support for the isLast
method
is optional for ResultSet
s with a result
set type of TYPE_FORWARD_ONLY
isLast
in interface java.sql.ResultSet
true
if the cursor is on the last row;
false
otherwise
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean isReadOnly()
RowSet
object is read-only.
If updates are possible, the default is for a rowset to be
updatable.
Attempts to update a read-only rowset will result in an
SQLException
being thrown.
isReadOnly
in interface javax.sql.RowSet
true
if this RowSet
object is
read-only; false
if it is updatablesetReadOnly(boolean)
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
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.
isWrapperFor
in interface java.sql.Wrapper
iface
- a Class defining an interface.
java.sql.SQLException
- if an error occurs while determining whether this is a wrapper
for an object with the given interface.public boolean last() throws java.sql.SQLException
ResultSet
object.
last
in interface java.sql.ResultSet
true
if the cursor is on a valid row;
false
if there are no rows in the result set
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set
or the result set type is TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs; this
method is called on a closed result set
or the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void moveToInsertRow() throws java.sql.SQLException
insertRow
methods may be
called when the cursor is on the insert row. All of the columns in
a result set must be given a value each time this method is
called before calling insertRow
.
An updater method must be called before a
getter method can be called on a column value.
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs; this
method is called on a closed result set
or the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean next() throws java.sql.SQLException
ResultSet
cursor is initially positioned
before the first row; the first call to the method
next
makes the first row the current row; the
second call makes the second row the current row, and so on.
When a call to the next
method returns false
,
the cursor is positioned after the last row. Any
invocation of a ResultSet
method which requires a
current row will result in a SQLException
being thrown.
If the result set type is TYPE_FORWARD_ONLY
, it is vendor specified
whether their JDBC driver implementation will return false
or
throw an SQLException
on a
subsequent call to next
.
If an input stream is open for the current row, a call
to the method next
will
implicitly close it. A ResultSet
object's
warning chain is cleared when a new row is read.
next
in interface java.sql.ResultSet
true
if the new current row is valid;
false
if there are no more rows
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result setpublic boolean nextWE()
ILptsRowset interface function.
This is equivalent to the resultSet.next(), with the exception of the fact that no exception is thrown. The SQLException that is normally thrown from next() is absorbed into the logging system and is reported as an error. Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes : Example :private void processRowSet(TLptsRowSet rowSet) { while(rowSet.nextWE()) { ... //We want to process only the first 100 rows if(rowSet.getRowCount()>=100) break; } }
public boolean previous() throws java.sql.SQLException
ResultSet
object.
When a call to the previous
method returns false
,
the cursor is positioned before the first row. Any invocation of a
ResultSet
method which requires a current row will result in a
SQLException
being thrown.
If an input stream is open for the current row, a call to the method
previous
will implicitly close it. A ResultSet
object's warning change is cleared when a new row is read.
previous
in interface java.sql.ResultSet
true
if the cursor is now positioned on a valid row;
false
if the cursor is positioned before the first row
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set
or the result set type is TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void refreshRow() throws java.sql.SQLException
The refreshRow
method provides a way for an
application to
explicitly tell the JDBC driver to refetch a row(s) from the
database. An application may want to call refreshRow
when
caching or prefetching is being done by the JDBC driver to
fetch the latest value of a row from the database. The JDBC driver
may actually refresh multiple rows at once if the fetch size is
greater than one.
All values are refetched subject to the transaction isolation
level and cursor sensitivity. If refreshRow
is called after
calling an updater method, but before calling
the method updateRow
, then the
updates made to the row are lost. Calling the method
refreshRow
frequently will likely slow performance.
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error
occurs; this method is called on a closed result set;
the result set type is TYPE_FORWARD_ONLY
or if this
method is called when the cursor is on the insert row
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this method or this method is not supported for the specified result
set type and result set concurrency.public boolean relative(int rows) throws java.sql.SQLException
relative(0)
is valid, but does
not change the cursor position.
Note: Calling the method relative(1)
is identical to calling the method next()
and
calling the method relative(-1)
is identical
to calling the method previous()
.
relative
in interface java.sql.ResultSet
rows
- an int
specifying the number of rows to
move from the current row; a positive number moves the cursor
forward; a negative number moves the cursor backward
true
if the cursor is on a row;
false
otherwise
java.sql.SQLException
- if a database access error occurs; this method
is called on a closed result set or the result set type is
TYPE_FORWARD_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void removeRowSetListener(javax.sql.RowSetListener listener)
RowSet
object.
removeRowSetListener
in interface javax.sql.RowSet
listener
- a component that has been registered as a listener for this
RowSet
objectaddRowSetListener(javax.sql.RowSetListener)
public boolean rowDeleted() throws java.sql.SQLException
ResultSet
object can detect deletions.
Note: Support for the rowDeleted
method is optional with a result set
concurrency of CONCUR_READ_ONLY
rowDeleted
in interface java.sql.ResultSet
true
if the current row is detected to
have been deleted by the owner or another; false
otherwise
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodDatabaseMetaData.deletesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
ResultSet
object can detect visible inserts.
Note: Support for the rowInserted
method is optional with a result set
concurrency of CONCUR_READ_ONLY
rowInserted
in interface java.sql.ResultSet
true
if the current row is detected to
have been inserted; false
otherwise
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodDatabaseMetaData.insertsAreDetected(int)
public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
method is optional with a result set
concurrency of CONCUR_READ_ONLY
rowUpdated
in interface java.sql.ResultSet
true
if the current row is detected to
have been visibly updated by the owner or another; false
otherwise
java.sql.SQLException
- if a database access error occurs
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodDatabaseMetaData.updatesAreDetected(int)
public void setArray(int i, java.sql.Array x) throws java.sql.SQLException
RowSet
object's command
with the given Array
value. The driver will convert this
to the ARRAY
value that the Array
object
represents before sending it to the database.
setArray
in interface javax.sql.RowSet
i
- the first parameter is 1, the second is 2, ...x
- an object representing an SQL array
java.sql.SQLException
- if a database access error occurspublic void setAsciiStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
RowSet
object's command
to the given input stream.
When a very large ASCII value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream
. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setAsciiStream
which takes a length parameter.
setAsciiStream
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the Java input stream that contains the ASCII parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed PreparedStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
RowSet
object's command
to the given java.io.InputStream
value.
It may be more practical to send a very large ASCII value via a
java.io.InputStream
rather than as a LONGVARCHAR
parameter. The driver will read the data from the stream
as needed until it reaches end-of-file.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream
java.sql.SQLException
- if a database access error occurspublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream
. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setAsciiStream
which takes a length parameter.
setAsciiStream
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the Java input stream that contains the ASCII parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream
. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
RowSet
object's command
to the given java.math.BigDeciaml
value.
The driver converts this to
an SQL NUMERIC
value before sending it to the database.
setBigDecimal
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
java.math.BigDecimal
value.
The driver converts this to an SQL NUMERIC
value when
it sends it to the database.
setBigDecimal
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetBigDecimal(int, int)
public void setBinaryStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
RowSet
object's command
to the given input stream.
When a very large binary value is input to a LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream
object. The data will be read from the
stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBinaryStream
which takes a length parameter.
setBinaryStream
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java input stream which contains the binary parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed PreparedStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
RowSet
object's command
to the given java.io.InputStream
value.
It may be more practical to send a very large binary value via a
java.io.InputStream
rather than as a LONGVARBINARY
parameter. The driver will read the data from the stream
as needed until it reaches end-of-file.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setBinaryStream
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream
java.sql.SQLException
- if a database access error occurspublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream
object. The data will be read from the
stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBinaryStream
which takes a length parameter.
setBinaryStream
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the java input stream which contains the binary parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream
object. The data will be read from the stream
as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setBinaryStream
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setBlob(int i, java.sql.Blob x) throws java.sql.SQLException
RowSet
object's command
with the given Blob
value. The driver will convert this
to the BLOB
value that the Blob
object
represents before sending it to the database.
setBlob
in interface javax.sql.RowSet
i
- the first parameter is 1, the second is 2, ...x
- an object representing a BLOB
java.sql.SQLException
- if a database access error occurspublic void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException
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.
setBlob
in interface javax.sql.RowSet
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.
java.sql.SQLException
- 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,
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
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
setBlob
in interface javax.sql.RowSet
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.
java.sql.SQLException
- if a database access error occurs,
this method is called on a closed PreparedStatement
,
if parameterIndex does not correspond
to a parameter marker in the SQL statement, if the length specified
is less than zero or if the number of bytes in the inputstream does not match
the specfied length.
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
java.sql.Blob
object.
The driver converts this to an SQL BLOB
value when it
sends it to the database.
setBlob
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- a Blob
object that maps an SQL BLOB
value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
InputStream
object.
This method differs from the setBinaryStream (int, InputStream)
method because it informs the driver that the parameter value should be
sent to the server as a BLOB
. When the setBinaryStream
method is used,
the driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGVARBINARY
or a BLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBlob
which takes a length parameter.
setBlob
in interface javax.sql.RowSet
parameterName
- the name of the parameterinputStream
- An object that contains the data to set the parameter
value to.
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
InputStream
object. The inputstream
must contain the number
of characters specified by length, otherwise a SQLException
will be
generated when the CallableStatement
is executed.
This method differs from the setBinaryStream (int, InputStream, int)
method because it informs the driver that the parameter value should be
sent to the server as a BLOB
. When the setBinaryStream
method is used,
the driver may have to do extra work to determine whether the parameter
data should be sent to the server as a LONGVARBINARY
or a BLOB
setBlob
in interface javax.sql.RowSet
parameterName
- the name of the parameter to be set
the second is 2, ...inputStream
- An object that contains the data to set the parameter
value to.length
- the number of bytes in the parameter data.
java.sql.SQLException
- if parameterIndex does not correspond
to a parameter marker in the SQL statement, or 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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
RowSet
object's command
to the given Java boolean
value. The driver converts this to
an SQL BIT
value before sending it to the database.
setBoolean
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
boolean
value.
The driver converts this
to an SQL BIT
or BOOLEAN
value when it sends it to the database.
setBoolean
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetBoolean(int)
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
RowSet
object's command
to the given Java byte
value. The driver converts this to
an SQL TINYINT
value before sending it to the database.
setByte
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
byte
value.
The driver converts this
to an SQL TINYINT
value when it sends it to the database.
setByte
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetByte(int)
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
RowSet
object's command
to the given Java array of byte
values. Before sending it to the
database, the driver converts this to an SQL VARBINARY
or
LONGVARBINARY
value, depending on the argument's size relative
to the driver's limits on VARBINARY
values.
setBytes
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
VARBINARY
or
LONGVARBINARY
(depending on the argument's size relative
to the driver's limits on VARBINARY
values) when it sends
it to the database.
setBytes
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetBytes(int)
public void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
RowSet
object's command
to the given Reader
object.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader
object. The data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setCharacterStream
which takes a length parameter.
setCharacterStream
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...reader
- the java.io.Reader
object that contains the
Unicode data
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed PreparedStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
RowSet
object's command
to the given java.io.Reader
value.
It may be more practical to send a very large UNICODE value via a
java.io.Reader
rather than as a LONGVARCHAR
parameter. The driver will read the data from the stream
as needed until it reaches end-of-file.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setCharacterStream
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...reader
- the Reader
object that contains the UNICODE data
to be setlength
- the number of characters in the stream
java.sql.SQLException
- if a database access error occurspublic void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader
object. The data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setCharacterStream
which takes a length parameter.
setCharacterStream
in interface javax.sql.RowSet
parameterName
- the name of the parameterreader
- the java.io.Reader
object that contains the
Unicode data
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader
object. The data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setCharacterStream
in interface javax.sql.RowSet
parameterName
- the name of the parameterreader
- the java.io.Reader
object that
contains the UNICODE data used as the designated parameterlength
- the number of characters in the stream
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setCharSet(java.lang.String charSet)
Set the charset to tbe used for String processing by the rowset.
Thread Safe : Yes Spawns its own Thread : No May Return NULL : N/A Notes : The charset value default is taken from the Statement used to create the rowset. Example :TLptsStatement statement = new TLptsStatement(); ... TLptsRowSet rowSet = new TLptsRowSet(statement,statement.executeQuery()); // RowSet charSet is the same with the statement charset. // now we change the charset to Greek. rowSet.setCharSet("windows-1253"); ... // This method now encodes the string object (index 5) with the Greek charset. Object stringObject = rowSet.getObjectWithCharSet(5);
charSet
- The character set to be used for the next call to getObjectWithCharSet.
Set this to TLptsCharSetLocaleUtil.NO_CHARSET_TRANSLATION to set the "Default".
The list of supported character sets can be obtained with Charset.availableCharsets();public void setClob(int i, java.sql.Clob x) throws java.sql.SQLException
RowSet
object's command
with the given Clob
value. The driver will convert this
to the CLOB
value that the Clob
object
represents before sending it to the database.
setClob
in interface javax.sql.RowSet
i
- the first parameter is 1, the second is 2, ...x
- an object representing a CLOB
java.sql.SQLException
- if a database access error occurspublic void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
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.
setClob
in interface javax.sql.RowSet
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.
java.sql.SQLException
- 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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
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
setClob
in interface javax.sql.RowSet
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.
java.sql.SQLException
- if a database access error occurs, this method is called on
a closed PreparedStatement
, if parameterIndex does not correspond to a parameter
marker in the SQL statement, or if the length specified is less than zero.
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
java.sql.Clob
object.
The driver converts this to an SQL CLOB
value when it
sends it to the database.
setClob
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- a Clob
object that maps an SQL CLOB
value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
This method differs from the setCharacterStream (int, Reader)
method
because it informs the driver that the parameter value should be sent to
the server as a CLOB
. When the setCharacterStream
method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGVARCHAR
or a CLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setClob
which takes a length parameter.
setClob
in interface javax.sql.RowSet
parameterName
- the name of the parameterreader
- An object that contains the data to set the parameter value to.
java.sql.SQLException
- if a database access error occurs or this method is called on
a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
Reader
object. The reader
must contain the number
of characters specified by length otherwise a SQLException
will be
generated when the CallableStatement
is executed.
This method differs from the setCharacterStream (int, Reader, int)
method
because it informs the driver that the parameter value should be sent to
the server as a CLOB
. When the setCharacterStream
method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGVARCHAR
or a CLOB
setClob
in interface javax.sql.RowSet
parameterName
- the name of the parameter to be setreader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
java.sql.SQLException
- if parameterIndex does not correspond to a parameter
marker in the SQL statement; if the length specified is less than zero;
a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setCommand(java.lang.String cmd) throws java.sql.SQLException
RowSet
object's command property to the given
SQL query.
This property is optional
when a rowset gets its data from a data source that does not support
commands, such as a spreadsheet.
setCommand
in interface javax.sql.RowSet
cmd
- the SQL query that will be used to get the data for this
RowSet
object; may be null
java.sql.SQLException
- if a database access error occursgetCommand()
public void setConcurrency(int concurrency) throws java.sql.SQLException
RowSet
object to the given
concurrency level. This method is used to change the concurrency level
of a rowset, which is by default ResultSet.CONCUR_READ_ONLY
setConcurrency
in interface javax.sql.RowSet
concurrency
- one of the ResultSet
constants specifying a
concurrency level: ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
java.sql.SQLException
- if a database access error occursResultSet.getConcurrency()
public void setDataSourceName(java.lang.String name) throws java.sql.SQLException
RowSet
object to the
given String
.
The value of the data source name property can be used to do a lookup of
a DataSource
object that has been registered with a naming
service. After being retrieved, the DataSource
object can be
used to create a connection to the data source that it represents.
setDataSourceName
in interface javax.sql.RowSet
name
- the logical name of the data source for this RowSet
object; may be null
java.sql.SQLException
- if a database access error occursgetDataSourceName()
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
RowSet
object's command
to the given java.sql.Date
value. The driver converts this to
an SQL DATE
value before sending it to the database, using the
default java.util.Calendar
to calculate the date.
setDate
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
RowSet
object's command
with the given java.sql.Date
value. The driver will convert this
to an SQL DATE
value, using the given java.util.Calendar
object to calculate the date.
setDate
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- the java.util.Calendar
object to use for calculating the date
java.sql.SQLException
- if a database access error occurspublic void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
java.sql.Date
value
using the default time zone of the virtual machine that is running
the application.
The driver converts this
to an SQL DATE
value when it sends it to the database.
setDate
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetDate(int)
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
java.sql.Date
value,
using the given Calendar
object. The driver uses
the Calendar
object to construct an SQL DATE
value,
which the driver then sends to the database. With a
a Calendar
object, the driver can calculate the date
taking into account a custom timezone. If no
Calendar
object is specified, the driver uses the default
timezone, which is that of the virtual machine running the application.
setDate
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter valuecal
- the Calendar
object the driver will use
to construct the date
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetDate(int)
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
RowSet
object's command
to the given Java double
value. The driver converts this to
an SQL DOUBLE
value before sending it to the database.
setDouble
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
double
value.
The driver converts this
to an SQL DOUBLE
value when it sends it to the database.
setDouble
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetDouble(int)
public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
RowSet
object on or
off. If escape scanning is on (the default), the driver will do
escape substitution before sending an SQL statement to the database.
setEscapeProcessing
in interface javax.sql.RowSet
enable
- true
to enable escape processing;
false
to disable it
java.sql.SQLException
- if a database access error occursgetEscapeProcessing()
public void setFetchDirection(int direction) throws java.sql.SQLException
ResultSet
object will be processed.
The initial value is determined by the
Statement
object
that produced this ResultSet
object.
The fetch direction may be changed at any time.
setFetchDirection
in interface java.sql.ResultSet
direction
- an int
specifying the suggested
fetch direction; one of ResultSet.FETCH_FORWARD
,
ResultSet.FETCH_REVERSE
, or
ResultSet.FETCH_UNKNOWN
java.sql.SQLException
- if a database access error occurs; this
method is called on a closed result set or
the result set type is TYPE_FORWARD_ONLY
and the fetch
direction is not FETCH_FORWARD
Statement.setFetchDirection(int)
,
getFetchDirection()
public void setFetchSize(int rows) throws java.sql.SQLException
ResultSet
object.
If the fetch size specified is zero, the JDBC driver
ignores the value and is free to make its own best guess as to what
the fetch size should be. The default value is set by the
Statement
object
that created the result set. The fetch size may be changed at any time.
setFetchSize
in interface java.sql.ResultSet
rows
- the number of rows to fetch
java.sql.SQLException
- if a database access error occurs; this method
is called on a closed result set or the
condition rows >= 0
is not satisfiedgetFetchSize()
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
RowSet
object's command
to the given Java float
value. The driver converts this to
an SQL REAL
value before sending it to the database.
setFloat
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
float
value.
The driver converts this
to an SQL FLOAT
value when it sends it to the database.
setFloat
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetFloat(int)
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
RowSet
object's command
to the given Java int
value. The driver converts this to
an SQL INTEGER
value before sending it to the database.
setInt
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
int
value.
The driver converts this
to an SQL INTEGER
value when it sends it to the database.
setInt
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetInt(int)
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
RowSet
object's command
to the given Java long
value. The driver converts this to
an SQL BIGINT
value before sending it to the database.
setLong
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
long
value.
The driver converts this
to an SQL BIGINT
value when it sends it to the database.
setLong
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetLong(int)
public void setMaxFieldSize(int max) throws java.sql.SQLException
BINARY
,
VARBINARY
, LONGVARBINARYBINARY
, CHAR
,
VARCHAR
, LONGVARCHAR
, NCHAR
and NVARCHAR
columns.
If the limit is exceeded, the excess data is silently discarded.
For maximum portability, use values greater than 256.
setMaxFieldSize
in interface javax.sql.RowSet
max
- the new max column size limit in bytes; zero means unlimited
java.sql.SQLException
- if a database access error occursgetMaxFieldSize()
public void setMaxRows(int max) throws java.sql.SQLException
RowSet
object can contain to the specified number.
If the limit is exceeded, the excess rows are silently dropped.
setMaxRows
in interface javax.sql.RowSet
max
- the new maximum number of rows; zero means unlimited
java.sql.SQLException
- if a database access error occursgetMaxRows()
public void setNCharacterStream(int parameterIndex, java.io.Reader value) throws java.sql.SQLException
RowSet
object's command
to a Reader
object. The
Reader
reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNCharacterStream
which takes a length parameter.
setNCharacterStream
in interface javax.sql.RowSet
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter value
java.sql.SQLException
- 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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNCharacterStream(int parameterIndex, java.io.Reader value, long length) throws java.sql.SQLException
Reader
object. The
Reader
reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
setNCharacterStream
in interface javax.sql.RowSet
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter valuelength
- the number of characters in the parameter data.
java.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur ; or if a database access error occurspublic void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
Reader
object. The
Reader
reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNCharacterStream
which takes a length parameter.
setNCharacterStream
in interface javax.sql.RowSet
parameterName
- the name of the parametervalue
- the parameter value
java.sql.SQLException
- 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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
Reader
object. The
Reader
reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
setNCharacterStream
in interface javax.sql.RowSet
parameterName
- the name of the column to be setvalue
- the parameter valuelength
- the number of characters in the parameter data.
java.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; or if a database access error occurspublic void setNClob(int parameterIndex, java.sql.NClob value) throws java.sql.SQLException
java.sql.NClob
object. The driver converts this to a
SQL NCLOB
value when it sends it to the database.
setNClob
in interface javax.sql.RowSet
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter value
java.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur ; or if a database access error occurspublic void setNClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
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.
setNClob
in interface javax.sql.RowSet
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.
java.sql.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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
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
setNClob
in interface javax.sql.RowSet
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.
java.sql.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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
java.sql.NClob
object. The object
implements the java.sql.NClob
interface. This NClob
object maps to a SQL NCLOB
.
setNClob
in interface javax.sql.RowSet
parameterName
- the name of the column to be setvalue
- the parameter value
java.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; or if a database access error occurspublic void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
This method differs from the setCharacterStream (int, Reader)
method
because it informs the driver that the parameter value should be sent to
the server as a NCLOB
. When the setCharacterStream
method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGNVARCHAR
or a NCLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNClob
which takes a length parameter.
setNClob
in interface javax.sql.RowSet
parameterName
- the name of the parameterreader
- An object that contains the data to set the parameter value to.
java.sql.SQLException
- 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
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
Reader
object. The reader
must contain the number
of characters specified by length otherwise a SQLException
will be
generated when the CallableStatement
is executed.
This method differs from the setCharacterStream (int, Reader, int)
method
because it informs the driver that the parameter value should be sent to
the server as a NCLOB
. When the setCharacterStream
method is used, the
driver may have to do extra work to determine whether the parameter
data should be send to the server as a LONGNVARCHAR
or a NCLOB
setNClob
in interface javax.sql.RowSet
parameterName
- the name of the parameter to be setreader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
java.sql.SQLException
- 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 CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setNString(int parameterIndex, java.lang.String value) throws java.sql.SQLException
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.
setNString
in interface javax.sql.RowSet
parameterIndex
- of the first parameter is 1, the second is 2, ...value
- the parameter value
java.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur ; or if a database access error occurspublic void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
String
object.
The driver converts this to a SQL NCHAR
or
NVARCHAR
or LONGNVARCHAR
setNString
in interface javax.sql.RowSet
parameterName
- the name of the column to be setvalue
- the parameter value
java.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; or if a database access error occurspublic void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
RowSet
object's SQL
command to SQL NULL
.
Note: You must specify the parameter's SQL type.
setNull
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...sqlType
- a SQL type code defined by java.sql.types
java.sql.SQLException
- if a database access error occurspublic void setNull(int paramIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
RowSet
object's SQL
command to SQL NULL
. This version of the method setNull
should be used for SQL user-defined types (UDTs) and REF
type
parameters. Examples of UDTs include: STRUCT
, DISTINCT
,
JAVA_OBJECT
, and named array types.
Note: To be portable, applications must give the
SQL type code and the fully qualified SQL type name when specifying
a NULL UDT or REF
parameter. In the case of a UDT,
the name is the type name of the parameter itself. For a REF
parameter, the name is the type name of the referenced type. If
a JDBC driver does not need the type code or type name information,
it may ignore it.
REF
parameters,
this method may be used to set a null parameter of any JDBC type.
If the parameter does not have a user-defined or REF
type,
the typeName parameter is ignored.
setNull
in interface javax.sql.RowSet
paramIndex
- the first parameter is 1, the second is 2, ...sqlType
- a value from java.sql.types
typeName
- the fully qualified name of an SQL UDT or the type
name of the SQL structured type being referenced by a REF
type; ignored if the parameter is not a UDT or REF
type
java.sql.SQLException
- if a database access error occurspublic void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
NULL
.
Note: You must specify the parameter's SQL type.
setNull
in interface javax.sql.RowSet
parameterName
- the name of the parametersqlType
- the SQL type code defined in java.sql.types
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
NULL
.
This version of the method setNull
should
be used for user-defined types and REF type parameters. Examples
of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it.
Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
setNull
in interface javax.sql.RowSet
parameterName
- the name of the parametersqlType
- a value from java.sql.types
typeName
- the fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or
SQL REF
value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
RowSet
object's command
with a Java Object
. For integral values, the
java.lang
equivalent objects should be used.
The JDBC specification provides a standard mapping from Java Object types to SQL types. The driver will convert the given Java object to its standard SQL mapping before sending it to the database.
Note that this method may be used to pass datatabase-specific abstract data types by using a driver-specific Java type.
If the object is of a class implementingSQLData
,
the rowset should call the method SQLData.writeSQL
to write the object to an SQLOutput
data stream.
If, on the other hand, the object is of a class implementing
Ref
, Blob
, Clob
, NClob
,
Struct
, java.net.URL
,
or Array
, the driver should pass it to the database as a
value of the corresponding SQL type.
An exception is thrown if there is an ambiguity, for example, if the
object is of a class implementing more than one of these interfaces.
setObject
in interface javax.sql.RowSet
parameterIndex
- The first parameter is 1, the second is 2, ...x
- The object containing the input parameter value
java.sql.SQLException
- if a database access error occurspublic void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
RowSet
object's command
with a Java Object
. For integral values, the
java.lang
equivalent objects should be used.
This method is like setObject
above, but the scale used is the scale
of the second parameter. Scalar values have a scale of zero. Literal
values have the scale present in the literal.
Even though it is supported, it is not recommended that this method
be called with floating point input values.
setObject
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.types
)
to be sent to the database
java.sql.SQLException
- if a database access error occurspublic void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scaleOrLength) throws java.sql.SQLException
RowSet
object's command
with the given Java Object
. For integral values, the
java.lang
equivalent objects should be used (for example,
an instance of the class Integer
for an int
).
If the second argument is an InputStream
then the stream must contain
the number of bytes specified by scaleOrLength. If the second argument is a
Reader
then the reader must contain the number of characters specified * by scaleOrLength. If these conditions are not true the driver will generate a
SQLException
when the prepared statement is executed.
The given Java object will be converted to the targetSqlType before being sent to the database.
If the object is of a class implementingSQLData
,
the rowset should call the method SQLData.writeSQL
to write the object to an SQLOutput
data stream.
If, on the other hand, the object is of a class implementing
Ref
, Blob
, Clob
, NClob
,
Struct
, java.net.URL
,
or Array
, the driver should pass it to the database as a
value of the corresponding SQL type.
Note that this method may be used to pass datatabase-specific abstract data types.
setObject
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.types
)
to be sent to the database. The scale argument may further qualify this
type.scaleOrLength
- for java.sql.types.DECIMAL
or java.sql.types.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.
java.sql.SQLException
- if a database access error occursTypes
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
Object
; therefore, the
java.lang
equivalent objects should be used for built-in types.
The JDBC specification specifies a standard mapping from
Java Object
types to SQL types. The given argument
will be converted to the corresponding SQL type before being
sent to the database.
Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type.
If the object is of a class implementing the interfaceSQLData
,
the JDBC driver should call the method SQLData.writeSQL
to write it to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref
, Blob
, Clob
, NClob
,
Struct
, java.net.URL
,
or Array
, the driver should pass it to the database as a
value of the corresponding SQL type.
This method throws an exception if there is an ambiguity, for example, if the
object is of a class implementing more than one of the interfaces named above.
setObject
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the object containing the input parameter value
java.sql.SQLException
- if a database access error occurs,
this method is called on a closed CallableStatement
or if the given
Object
parameter is ambiguous
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetObject(int)
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
above, except that it assumes a scale of zero.
setObject
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.types) to be
sent to the database
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if targetSqlType
is
a ARRAY
, BLOB
, CLOB
,
DATALINK
, JAVA_OBJECT
, NCHAR
,
NCLOB
, NVARCHAR
, LONGNVARCHAR
,
REF
, ROWID
, SQLXML
or STRUCT
data type and the JDBC driver does not support
this data typegetObject(int)
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
java.lang
equivalent objects should be used.
The given Java object will be converted to the given targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing the interfaceSQLData
),
the JDBC driver should call the method SQLData.writeSQL
to write it
to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref
, Blob
, Clob
, NClob
,
Struct
, java.net.URL
,
or Array
, the driver should pass it to the database as a
value of the corresponding SQL type.
Note that this method may be used to pass datatabase-
specific abstract data types.
setObject
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.types) to be
sent to the database. The scale argument may further qualify this type.scale
- for java.sql.types.DECIMAL or java.sql.types.NUMERIC types,
this is the number of digits after the decimal point. For all other
types, this value will be ignored.
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if targetSqlType
is
a ARRAY
, BLOB
, CLOB
,
DATALINK
, JAVA_OBJECT
, NCHAR
,
NCLOB
, NVARCHAR
, LONGNVARCHAR
,
REF
, ROWID
, SQLXML
or STRUCT
data type and the JDBC driver does not support
this data typeTypes
,
getObject(int)
public void setPassword(java.lang.String password) throws java.sql.SQLException
RowSet
object to
the given String
.
setPassword
in interface javax.sql.RowSet
password
- the password string
java.sql.SQLException
- if a database access error occursgetPassword()
public void setQueryTimeout(int seconds) throws java.sql.SQLException
SQLException
is thrown.
setQueryTimeout
in interface javax.sql.RowSet
seconds
- the new query timeout limit in seconds; zero means
that there is no limit
java.sql.SQLException
- if a database access error occursgetQueryTimeout()
public void setReadOnly(boolean value) throws java.sql.SQLException
RowSet
object is read-only to the
given boolean
.
setReadOnly
in interface javax.sql.RowSet
value
- true
if read-only; false
if
updatable
java.sql.SQLException
- if a database access error occursisReadOnly()
public void setRef(int i, java.sql.Ref x) throws java.sql.SQLException
RowSet
object's command
with the given Ref
value. The driver will convert this
to the appropriate REF(<structured-type>)
value.
setRef
in interface javax.sql.RowSet
i
- the first parameter is 1, the second is 2, ...x
- an object representing data of an SQL REF
type
java.sql.SQLException
- if a database access error occurspublic void setRowId(int parameterIndex, java.sql.RowId x) throws java.sql.SQLException
java.sql.RowId
object. The
driver converts this to a SQL ROWID
value when it sends it
to the database
setRowId
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
java.sql.RowId
object. The
driver converts this to a SQL ROWID
when it sends it to the
database.
setRowId
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setShort(int parameterIndex, short x) throws java.sql.SQLException
RowSet
object's command
to the given Java short
value. The driver converts this to
an SQL SMALLINT
value before sending it to the database.
setShort
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
short
value.
The driver converts this
to an SQL SMALLINT
value when it sends it to the database.
setShort
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetShort(int)
public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
java.sql.SQLXML
object. The driver converts this to an
SQL XML
value when it sends it to the database.
setSQLXML
in interface javax.sql.RowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ...xmlObject
- a SQLXML
object that maps an SQL XML
value
java.sql.SQLException
- if a database access error occurs, this method
is called on a closed result set,
the java.xml.transform.Result
,
Writer
or OutputStream
has not been closed
for the SQLXML
object or
if there is an error processing the XML value. The getCause
method
of the exception may provide a more detailed exception, for example, if the
stream does not contain valid XML.public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
java.sql.SQLXML
object. The driver converts this to an
SQL XML
value when it sends it to the database.
setSQLXML
in interface javax.sql.RowSet
parameterName
- the name of the parameterxmlObject
- a SQLXML
object that maps an SQL XML
value
java.sql.SQLException
- if a database access error occurs, this method
is called on a closed result set,
the java.xml.transform.Result
,
Writer
or OutputStream
has not been closed
for the SQLXML
object or
if there is an error processing the XML value. The getCause
method
of the exception may provide a more detailed exception, for example, if the
stream does not contain valid XML.public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
RowSet
object's command
to the given Java String
value. Before sending it to the
database, the driver converts this to an SQL VARCHAR
or
LONGVARCHAR
value, depending on the argument's size relative
to the driver's limits on VARCHAR
values.
setString
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
String
value.
The driver converts this
to an SQL VARCHAR
or LONGVARCHAR
value
(depending on the argument's
size relative to the driver's limits on VARCHAR
values)
when it sends it to the database.
setString
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetString(int)
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
RowSet
object's command
to the given java.sql.Time
value. The driver converts this to
an SQL TIME
value before sending it to the database, using the
default java.util.Calendar
to calculate it.
setTime
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
RowSet
object's command
with the given java.sql.Time
value. The driver will convert this
to an SQL TIME
value, using the given java.util.Calendar
object to calculate it, before sending it to the database.
setTime
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- the java.util.Calendar
object to use for calculating the time
java.sql.SQLException
- if a database access error occurspublic void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
java.sql.Time
value.
The driver converts this
to an SQL TIME
value when it sends it to the database.
setTime
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetTime(int)
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
java.sql.Time
value,
using the given Calendar
object. The driver uses
the Calendar
object to construct an SQL TIME
value,
which the driver then sends to the database. With a
a Calendar
object, the driver can calculate the time
taking into account a custom timezone. If no
Calendar
object is specified, the driver uses the default
timezone, which is that of the virtual machine running the application.
setTime
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter valuecal
- the Calendar
object the driver will use
to construct the time
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetTime(int)
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
RowSet
object's command
to the given java.sql.Timestamp
value. The driver converts this to
an SQL TIMESTAMP
value before sending it to the database, using the
default java.util.Calendar
to calculate it.
setTimestamp
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value
java.sql.SQLException
- if a database access error occurspublic void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
RowSet
object's command
with the given java.sql.Timestamp
value. The driver will
convert this to an SQL TIMESTAMP
value, using the given
java.util.Calendar
object to calculate it, before sending it to the
database.
setTimestamp
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- the java.util.Calendar
object to use for calculating the
timestamp
java.sql.SQLException
- if a database access error occurspublic void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
java.sql.Timestamp
value.
The driver
converts this to an SQL TIMESTAMP
value when it sends it to the
database.
setTimestamp
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter value
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetTimestamp(int)
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
java.sql.Timestamp
value,
using the given Calendar
object. The driver uses
the Calendar
object to construct an SQL TIMESTAMP
value,
which the driver then sends to the database. With a
a Calendar
object, the driver can calculate the timestamp
taking into account a custom timezone. If no
Calendar
object is specified, the driver uses the default
timezone, which is that of the virtual machine running the application.
setTimestamp
in interface javax.sql.RowSet
parameterName
- the name of the parameterx
- the parameter valuecal
- the Calendar
object the driver will use
to construct the timestamp
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed CallableStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodgetTimestamp(int)
public void setTransactionIsolation(int level) throws java.sql.SQLException
RowSet
obejct.
setTransactionIsolation
in interface javax.sql.RowSet
level
- the transaction isolation level; one of
Connection.TRANSACTION_READ_UNCOMMITTED
,
Connection.TRANSACTION_READ_COMMITTED
,
Connection.TRANSACTION_REPEATABLE_READ
, or
Connection.TRANSACTION_SERIALIZABLE
java.sql.SQLException
- if a database access error occursgetTransactionIsolation()
public void setType(int type) throws java.sql.SQLException
RowSet
object to the given type.
This method is used to change the type of a rowset, which is by
default read-only and non-scrollable.
setType
in interface javax.sql.RowSet
type
- one of the ResultSet
constants specifying a type:
ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or
ResultSet.TYPE_SCROLL_SENSITIVE
java.sql.SQLException
- if a database access error occursResultSet.getType()
public void setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
java.util.Map
object as the default
type map for this RowSet
object. This type map will be
used unless another type map is supplied as a method parameter.
setTypeMap
in interface javax.sql.RowSet
map
- a java.util.Map
object containing the names of
SQL user-defined types and the Java classes to which they are
to be mapped
java.sql.SQLException
- if a database access error occursgetTypeMap()
public void setURL(int parameterIndex, java.net.URL x) throws java.sql.SQLException
java.net.URL
value.
The driver converts this to an SQL DATALINK
value
when it sends it to the database.
setURL
in interface javax.sql.RowSet
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java.net.URL
object to be set
java.sql.SQLException
- if a database access error occurs or
this method is called on a closed PreparedStatement
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic void setUrl(java.lang.String url) throws java.sql.SQLException
RowSet
object will use when it uses the
DriverManager
to create a connection.
Setting this property is optional. If a URL is used, a JDBC driver
that accepts the URL must be loaded before the
rowset is used to connect to a database. The rowset will use the URL
internally to create a database connection when reading or writing
data. Either a URL or a data source name is used to create a
connection, whichever was set to non null value most recently.
setUrl
in interface javax.sql.RowSet
url
- a string value; may be null
java.sql.SQLException
- if a database access error occursgetUrl()
public void setUsername(java.lang.String name) throws java.sql.SQLException
RowSet
object to the
given String
.
setUsername
in interface javax.sql.RowSet
name
- a user name
java.sql.SQLException
- if a database access error occursgetUsername()
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
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.
unwrap
in interface java.sql.Wrapper
iface
- A Class defining an interface that the result must implement.
java.sql.SQLException
- If no object found that implements the interfacepublic void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
java.sql.Array
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateArray
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateArray(java.lang.String columnLabel, java.sql.Array x) throws java.sql.SQLException
java.sql.Array
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateArray
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateAsciiStream
which takes a length parameter.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateAsciiStream
which takes a length parameter.
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
java.math.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBigDecimal(java.lang.String columnLabel, java.math.BigDecimal x) throws java.sql.SQLException
java.sql.BigDecimal
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBigDecimal
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(int columnIndex, java.io.InputStream x) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBinaryStream
which takes a length parameter.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBinaryStream
which takes a length parameter.
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, int length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
java.sql.Blob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBlob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(int columnIndex, java.io.InputStream inputStream) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBlob
which takes a length parameter.
updateBlob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...inputStream
- An object that contains the data to set the parameter
value to.
java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateBlob
in interface java.sql.ResultSet
columnIndex
- the first column 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.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(java.lang.String columnLabel, java.sql.Blob x) throws java.sql.SQLException
java.sql.Blob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBlob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBlob
which takes a length parameter.
updateBlob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columninputStream
- An object that contains the data to set the parameter
value to.
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateBlob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columninputStream
- An object that contains the data to set the parameter
value to.length
- the number of bytes in the parameter data.
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
boolean
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBoolean
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBoolean(java.lang.String columnLabel, boolean x) throws java.sql.SQLException
boolean
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBoolean
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateByte(int columnIndex, byte x) throws java.sql.SQLException
byte
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateByte
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateByte(java.lang.String columnLabel, byte x) throws java.sql.SQLException
byte
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateByte
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
byte
array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBytes
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateBytes(java.lang.String columnLabel, byte[] x) throws java.sql.SQLException
updateRow
or insertRow
methods are called to update the database.
updateBytes
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateCharacterStream
which takes a length parameter.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateCharacterStream
which takes a length parameter.
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- the java.io.Reader
object containing
the new column value
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, int length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- the java.io.Reader
object containing
the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
updateRow
or
insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- the java.io.Reader
object containing
the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
java.sql.Clob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateClob
which takes a length parameter.
updateClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...reader
- An object that contains the data to set the parameter value to.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
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 JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateClob
in interface java.sql.ResultSet
columnIndex
- the first column 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.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(java.lang.String columnLabel, java.sql.Clob x) throws java.sql.SQLException
java.sql.Clob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateClob
which takes a length parameter.
updateClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- An object that contains the data to set the parameter value to.
java.sql.SQLException
- if the columnLabel is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
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 JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
java.sql.Date
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateDate(java.lang.String columnLabel, java.sql.Date x) throws java.sql.SQLException
java.sql.Date
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDate
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateDouble(int columnIndex, double x) throws java.sql.SQLException
double
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDouble
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateDouble(java.lang.String columnLabel, double x) throws java.sql.SQLException
double
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDouble
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateFloat(int columnIndex, float x) throws java.sql.SQLException
float
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateFloat
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateFloat(java.lang.String columnLabel, float x) throws java.sql.SQLException
float
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateFloat
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateInt(int columnIndex, int x) throws java.sql.SQLException
int
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateInt
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateInt(java.lang.String columnLabel, int x) throws java.sql.SQLException
int
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateInt
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateLong(int columnIndex, long x) throws java.sql.SQLException
long
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateLong
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateLong(java.lang.String columnLabel, long x) throws java.sql.SQLException
long
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateLong
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNCharacterStream(int columnIndex, java.io.Reader x) throws java.sql.SQLException
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNCharacterStream
which takes a length parameter.
updateNCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws java.sql.SQLException
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNCharacterStream
which takes a length parameter.
updateNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- the java.io.Reader
object containing
the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNCharacterStream
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- the java.io.Reader
object containing
the new column valuelength
- the length of the stream
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNClob(int columnIndex, java.sql.NClob nClob) throws java.sql.SQLException
java.sql.NClob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...nClob
- the value for the column to be updated
java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNClob(int columnIndex, java.io.Reader reader) throws java.sql.SQLException
Reader
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNClob
which takes a length parameter.
updateNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...reader
- An object that contains the data to set the parameter value to.
java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNClob(int columnIndex, java.io.Reader reader, long length) throws java.sql.SQLException
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 JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...reader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNClob(java.lang.String columnLabel, java.sql.NClob nClob) throws java.sql.SQLException
java.sql.NClob
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnnClob
- the value for the column to be updated
java.sql.SQLException
- if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws java.sql.SQLException
Reader
object.
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNClob
which takes a length parameter.
updateNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- An object that contains the data to set the parameter value to.
java.sql.SQLException
- if the columnLabel is not valid; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws java.sql.SQLException
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 JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNClob
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader
- An object that contains the data to set the parameter value to.length
- the number of characters in the parameter data.
java.sql.SQLException
- if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNString(int columnIndex, java.lang.String nString) throws java.sql.SQLException
String
value.
It is intended for use when updating NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...nString
- the value for the column to be updated
java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
the result set concurrency is CONCUR_READ_ONLY
or if a database access error occurs
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNString(java.lang.String columnLabel, java.lang.String nString) throws java.sql.SQLException
String
value.
It is intended for use when updating NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNString
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnnString
- the value for the column to be updated
java.sql.SQLException
- if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
the result set concurrency is CONCUR_READ_ONLY
or if a database access error occurs
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNull(int columnIndex) throws java.sql.SQLException
null
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNull
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateNull(java.lang.String columnLabel) throws java.sql.SQLException
null
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNull
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateObject(int columnIndex, java.lang.Object x, int scaleOrLength) throws java.sql.SQLException
Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
If the second argument is an InputStream
then the stream must contain
the number of bytes specified by scaleOrLength. If the second argument is a
Reader
then the reader must contain the number of characters specified
by scaleOrLength. If these conditions are not true the driver will generate a
SQLException
when the statement is executed.
updateObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuescaleOrLength
- for an object of java.math.BigDecimal
,
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.
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateObject(java.lang.String columnLabel, java.lang.Object x) throws java.sql.SQLException
Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateObject
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateObject(java.lang.String columnLabel, java.lang.Object x, int scaleOrLength) throws java.sql.SQLException
Object
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
If the second argument is an InputStream
then the stream must contain
the number of bytes specified by scaleOrLength. If the second argument is a
Reader
then the reader must contain the number of characters specified
by scaleOrLength. If these conditions are not true the driver will generate a
SQLException
when the statement is executed.
updateObject
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column valuescaleOrLength
- for an object of java.math.BigDecimal
,
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.
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
java.sql.Ref
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateRef
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateRef(java.lang.String columnLabel, java.sql.Ref x) throws java.sql.SQLException
java.sql.Ref
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateRef
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateRow() throws java.sql.SQLException
ResultSet
object.
This method cannot be called when the cursor is on the insert row.
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
;
this method is called on a closed result set or
if this method is called when the cursor is on the insert row
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateRowId(int columnIndex, java.sql.RowId x) throws java.sql.SQLException
RowId
value. The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called
to update the database.
updateRowId
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...x
- the column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateRowId(java.lang.String columnLabel, java.sql.RowId x) throws java.sql.SQLException
RowId
value. The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called
to update the database.
updateRowId
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateShort(int columnIndex, short x) throws java.sql.SQLException
short
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateShort
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateShort(java.lang.String columnLabel, short x) throws java.sql.SQLException
short
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateShort
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateSQLXML(int columnIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
java.sql.SQLXML
value.
The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called
to update the database.
updateSQLXML
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second 2, ...xmlObject
- the value for the column to be updated
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs; this method
is called on a closed result set;
the java.xml.transform.Result
,
Writer
or OutputStream
has not been closed
for the SQLXML
object;
if there is an error processing the XML value or
the result set concurrency is CONCUR_READ_ONLY
. The getCause
method
of the exception may provide a more detailed exception, for example, if the
stream does not contain valid XML.
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject) throws java.sql.SQLException
java.sql.SQLXML
value.
The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow
or insertRow
methods are called
to update the database.
updateSQLXML
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnxmlObject
- the column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs; this method
is called on a closed result set;
the java.xml.transform.Result
,
Writer
or OutputStream
has not been closed
for the SQLXML
object;
if there is an error processing the XML value or
the result set concurrency is CONCUR_READ_ONLY
. The getCause
method
of the exception may provide a more detailed exception, for example, if the
stream does not contain valid XML.
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
String
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateString(java.lang.String columnLabel, java.lang.String x) throws java.sql.SQLException
String
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateString
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
java.sql.Time
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateTime(java.lang.String columnLabel, java.sql.Time x) throws java.sql.SQLException
java.sql.Time
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTime
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic void updateTimestamp(java.lang.String columnLabel, java.sql.Timestamp x) throws java.sql.SQLException
java.sql.Timestamp
value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTimestamp
in interface java.sql.ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx
- the new column value
java.sql.SQLException
- if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set
java.sql.SQLFeatureNotSupportedException
- if the JDBC driver does not support
this methodpublic boolean wasNull() throws java.sql.SQLException
NULL
.
Note that you must first call one of the getter methods
on a column to try to read its value and then call
the method wasNull
to see if the value read was
SQL NULL
.
wasNull
in interface java.sql.ResultSet
true
if the last column value read was SQL
NULL
and false
otherwise
java.sql.SQLException
- if a database access error occurs or this method is
called on a closed result set
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |