|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.as400.access.AS400JDBCRowSet
The AS400JDBCRowSet class represents a connected rowset that encapsulates an JDBC result set. The database connection is maintained while in use.
Either the url or dataSourceName property must be set to specify how the database connection is established. The command property must be set to specify how to create the PreparedStatement.
This example creates an AS400JDBCRowSet object, populates it, and then updates its contents.
DriverManager.registerDriver(new AS400JDBCDriver()); AS400JDBCRowSet rowset = new AS400JDBCRowSet("jdbc:as400://mySystem","myUser", "myPassword"); // Set the command used to populate the list. rowset.setCommand("SELECT * FROM MYLIB.DATABASE"); // Populate the rowset. rowset.execute(); // Update the customer balances. while (rowset.next()) { double newBalance = rowset.getDouble("BALANCE") + july_statements.getPurchases(rowset.getString("CUSTNUM")); rowset.updateDouble("BALANCE", newBalance); rowset.updateRow(); }
This example creates an AS400JDBCRowSet object, sets the data source and command parameters and then populates it.
// Get the data source that is registered in JNDI (assumes JNDI environment is set). Context context = new InitialContext(); AS400JDBCDataSource dataSource = (AS400JDBCDataSource) context.lookup("jdbc/customer"); AS400JDBCRowSet rowset = new AS400JDBCRowSet(); rowset.setDataSourceName("jdbc/customer"); rowset.setUsername("myuser"); rowset.setPassword("myPasswd"); // Set the prepared statement and initialize the parameters. rowset.setCommand("SELECT * FROM MYLIBRARY.MYTABLE WHERE STATE = ? AND BALANCE > ?"); rowset.setString(1, "MINNESOTA"); rowset.setDouble(2, MAXIMUM_LIMIT); // Populate the rowset. rowset.execute();
AS400JDBCRowSet objects generate the following events:
Fields inherited from interface java.sql.ResultSet |
CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
AS400JDBCRowSet()
Constructs a default AS400JDBCRowSet object. |
|
AS400JDBCRowSet(java.lang.String dataSourceName)
Constructs an AS400JDBCRowset with the specified dataSourceName. |
|
AS400JDBCRowSet(java.lang.String url,
java.lang.String username,
java.lang.String password)
Constructs an AS400JDBCRowSet with the specified parameters. |
Method Summary | |
boolean |
absolute(int rowNumber)
Positions the cursor to an absolute row number. |
void |
addPropertyChangeListener(java.beans.PropertyChangeListener listener)
Adds a PropertyChangeListener. |
void |
addRowSetListener(javax.sql.RowSetListener listener)
Adds a RowSetListener to the list. |
void |
afterLast()
Positions the cursor after the last row. |
void |
beforeFirst()
Positions the cursor before the first row. |
void |
cancelRowUpdates()
Cancels all pending updates that have been made since the last call to updateRow(). |
void |
clearParameters()
Clears the columns for the current row and releases all associated resources. |
void |
clearWarnings()
Clears all warnings that have been reported for the result set. |
void |
close()
Releases the rowset resources immediately instead of waiting for them to be automatically released. |
void |
deleteRow()
Deletes the current row from the result set and the database. |
void |
execute()
Executes the command and fills the rowset with data. |
protected void |
finalize()
Closes the Statement and Connection. |
int |
findColumn(java.lang.String columnName)
Returns the column index for the specified column name. |
boolean |
first()
Positions the cursor to the first row. |
java.sql.Array |
getArray(int columnIndex)
Returns the value of a column as an Array object. |
java.sql.Array |
getArray(java.lang.String columnName)
Returns the value of a column as an Array object. |
java.io.InputStream |
getAsciiStream(int columnIndex)
Returns the value of a column as a stream of ASCII characters. |
java.io.InputStream |
getAsciiStream(java.lang.String columnName)
Returns the value of a column as a stream of ASCII characters. |
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Returns the value of a column as a BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated. Use getBigDecimal(int) instead. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
Returns the value of a column as a BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated. Use getBigDecimal(String) instead. |
java.io.InputStream |
getBinaryStream(int columnIndex)
Returns the value of a column as a stream of uninterpreted bytes. |
java.io.InputStream |
getBinaryStream(java.lang.String columnName)
Returns the value of a column as a stream of uninterpreted bytes. |
java.sql.Blob |
getBlob(int columnIndex)
Returns the value of a column as a Blob object. |
java.sql.Blob |
getBlob(java.lang.String columnName)
Returns the value of a column as a Blob object. |
boolean |
getBoolean(int columnIndex)
Returns the value of a column as a Java boolean value. |
boolean |
getBoolean(java.lang.String columnName)
Returns the value of a column as a Java boolean value. |
byte |
getByte(int columnIndex)
Returns the value of a column as a Java byte value. |
byte |
getByte(java.lang.String columnName)
Returns the value of a column as a Java byte value. |
byte[] |
getBytes(int columnIndex)
Returns the value of a column as a Java byte array. |
byte[] |
getBytes(java.lang.String columnName)
Returns the value of a column as a Java byte array. |
java.io.Reader |
getCharacterStream(int columnIndex)
Returns the value of a column as a character stream. |
java.io.Reader |
getCharacterStream(java.lang.String columnName)
Returns the value of a column as a character stream. |
java.sql.Clob |
getClob(int columnIndex)
Returns the value of a column as a Clob object. |
java.sql.Clob |
getClob(java.lang.String columnName)
Returns the value of a column as a Clob object. |
java.lang.String |
getCommand()
Returns the command used by the statement the generate the rowset. |
int |
getConcurrency()
Returns the result set concurrency. |
javax.naming.Context |
getContext()
Returns the JNDI naming context which provides name-to-object bindings and methods for retrieving and updating naming and directory services. |
java.lang.String |
getCursorName()
Returns the name of the SQL cursor in use by the result set. |
java.lang.String |
getDataSourceName()
Returns the name of the iSeries data source as identified in JNDI. |
java.sql.Date |
getDate(int columnIndex)
Returns the value of a column as a java.sql.Date object using the default calendar. |
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Date object using a calendar other than the default. |
java.sql.Date |
getDate(java.lang.String columnName)
Returns the value of a column as a java.sql.Date object using the default calendar. |
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Date object using a calendar other than the default. |
double |
getDouble(int columnIndex)
Returns the value of a column as a Java double value. |
double |
getDouble(java.lang.String columnName)
Returns the value of a column as a Java double value. |
java.util.Hashtable |
getEnvironment()
Returns a hashtable of standard JNDI environment properties. |
boolean |
getEscapeProcessing()
Indicates if escape processing is enabled (default). |
int |
getFetchDirection()
Returns the fetch direction. |
int |
getFetchSize()
Returns the number of rows to be fetched from the database when more rows are needed. |
float |
getFloat(int columnIndex)
Returns the value of a column as a Java float value. |
float |
getFloat(java.lang.String columnName)
Returns the value of a column as a Java float value. |
int |
getInt(int columnIndex)
Returns the value of a column as a Java int value. |
int |
getInt(java.lang.String columnName)
Returns the value of a column as a Java int value. |
long |
getLong(int columnIndex)
Returns the value of a column as a Java long value. |
long |
getLong(java.lang.String columnName)
Returns the value of a column as a Java long value. |
int |
getMaxFieldSize()
Returns the maximum column size. |
int |
getMaxRows()
Returns the maximum number of rows for the rowset. |
java.sql.ResultSetMetaData |
getMetaData()
Returns the ResultSetMetaData object that describes the result set's columns. |
java.lang.Object |
getObject(int columnIndex)
Returns the value of a column as a Java Object. |
java.lang.Object |
getObject(int columnIndex,
java.util.Map typeMap)
Returns the value of a column as a Java Object. |
java.lang.Object |
getObject(java.lang.String columnName)
Returns the value of a column as a Java Object. |
java.lang.Object |
getObject(java.lang.String columnName,
java.util.Map typeMap)
Returns the value of a column as a Java Object. |
java.lang.String |
getPassword()
Returns the password used to create the connection. |
int |
getQueryTimeout()
Returns the maximum wait time in seconds for a statement to execute. |
java.sql.Ref |
getRef(int columnIndex)
Returns the value of a column as a Ref object. |
java.sql.Ref |
getRef(java.lang.String columnName)
Returns the value of a column as a Ref object. |
int |
getRow()
Returns the current row number. |
short |
getShort(int columnIndex)
Returns the value of a column as a Java short value. |
short |
getShort(java.lang.String columnName)
Returns the value of a column as a Java short value. |
java.sql.Statement |
getStatement()
Returns the statement for this result set. |
java.lang.String |
getString(int columnIndex)
Returns the value of a column as a String object. |
java.lang.String |
getString(java.lang.String columnName)
Returns the value of a column as a String object. |
java.sql.Time |
getTime(int columnIndex)
Returns the value of a column as a java.sql.Time object using the default calendar. |
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Time object using a calendar other than the default. |
java.sql.Time |
getTime(java.lang.String columnName)
Returns the value of a column as a java.sql.Time object using the default calendar. |
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Time object using a calendar other than the default. |
java.sql.Timestamp |
getTimestamp(int columnIndex)
Returns the value of a column as a java.sql.Timestamp object using the default calendar. |
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName)
Returns the value of a column as a java.sql.Timestamp object using the default calendar. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Timestamp object using a calendar other than the default. |
int |
getTransactionIsolation()
Returns the transaction isolation level. |
int |
getType()
Returns the result set type. |
java.util.Map |
getTypeMap()
Returns the type map. |
java.io.InputStream |
getUnicodeStream(int columnIndex)
Deprecated. Use getCharacterStream(int) instead. |
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated. Use getCharacterStream(String) instead. |
java.lang.String |
getUrl()
Returns the url used in getting a connection. |
java.net.URL |
getURL(int columnIndex)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object. |
java.net.URL |
getURL(java.lang.String columnName)
Returns the value of an SQL DATALINK output parameter as a java.net.URL object. |
java.lang.String |
getUsername()
Returns the user used to create the connection. |
java.sql.SQLWarning |
getWarnings()
Returns the first warning reported for the result set. |
void |
insertRow()
Inserts the contents of the insert row into the result set and the database. |
boolean |
isAfterLast()
Indicates if the cursor is positioned after the last row. |
boolean |
isBeforeFirst()
Indicates if the cursor is positioned before the first row. |
boolean |
isFirst()
Indicates if the cursor is positioned on the first row. |
boolean |
isLast()
Indicates if the cursor is positioned on the last row. |
boolean |
isReadOnly()
Indicates if the rowset is read-only. |
boolean |
isUseDataSource()
Indicates if the data source is used to make a connection to the database. |
boolean |
last()
Positions the cursor to the last row. |
void |
moveToCurrentRow()
Positions the cursor to the current row. |
void |
moveToInsertRow()
Positions the cursor to the insert row. |
boolean |
next()
Positions the cursor to the next row. |
boolean |
previous()
Positions the cursor to the previous row. |
void |
refreshRow()
Refreshes the current row from the database and cancels all pending updates that have been made since the last call to updateRow(). |
boolean |
relative(int rowNumber)
Positions the cursor to a relative row number. |
void |
removePropertyChangeListener(java.beans.PropertyChangeListener listener)
Removes a PropertyChangeListener. |
void |
removeRowSetListener(javax.sql.RowSetListener listener)
Removes the RowSetListener from the list. |
boolean |
rowDeleted()
Indicates if the current row has been deleted. |
boolean |
rowInserted()
Indicates if the current row has been inserted. |
boolean |
rowUpdated()
Indicates if the current row has been updated. |
void |
setArray(int parameterIndex,
java.sql.Array value)
Sets the array value at the specified parameterIndex. |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream inputStream,
int length)
Sets the inputStream at the specified parameterIndex. |
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal value)
Sets the BigDecimal value at the specified parameterIndex. |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream inputStream,
int length)
Sets the binary stream value using a inputStream at the specified parameterIndex. |
void |
setBlob(int parameterIndex,
java.sql.Blob value)
Sets the Blob value at the specified parameterIndex. |
void |
setBoolean(int parameterIndex,
boolean value)
Sets the boolean value at the specified parameterIndex. |
void |
setByte(int parameterIndex,
byte value)
Sets the byte value at the specified parameterIndex. |
void |
setBytes(int parameterIndex,
byte[] value)
Sets the byte array value at the specified parameterIndex. |
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
Sets a column in the current row using a Reader value. |
void |
setClob(int parameterIndex,
java.sql.Clob value)
Sets the Clob value at the specified parameterIndex. |
void |
setCommand(java.lang.String command)
Sets the command used by the execute statement to populate the rowset. |
void |
setConcurrency(int concurrency)
Sets the concurrency type for the result set. |
void |
setContext(javax.naming.Context context)
Sets the JNDI naming context which provides name-to-object bindings and methods for retrieving and updating naming and directory services. |
void |
setDataSourceName(java.lang.String dataSourceName)
Sets the name of the iSeries data source. |
void |
setDate(int parameterIndex,
java.sql.Date value)
Sets the Date value at the specified parameterIndex. |
void |
setDate(int parameterIndex,
java.sql.Date value,
java.util.Calendar calendar)
Sets the Date value at the specified parameterIndex. |
void |
setDouble(int parameterIndex,
double value)
Sets the double value at the specified parameterIndex. |
void |
setEnvironment(java.util.Hashtable environment)
Sets the standard JNDI environment properties. |
void |
setEscapeProcessing(boolean enable)
Sets whether the escape scanning is enabled for escape substitution processing. |
void |
setFetchDirection(int fetchDirection)
Sets the direction in which the rows in a result set are processed. |
void |
setFetchSize(int fetchSize)
Sets the number of rows to be fetched from the database when more rows are needed. |
void |
setFloat(int parameterIndex,
float value)
Sets the float value at the specified parameterIndex. |
void |
setInt(int parameterIndex,
int value)
Sets the integer value at the specified parameterIndex. |
void |
setLong(int parameterIndex,
long value)
Sets the long value at the specified parameterIndex. |
void |
setMaxFieldSize(int maxFieldSize)
Sets the maximum column size. |
void |
setMaxRows(int maxRows)
Sets the maximum row limit for the rowset. |
void |
setNull(int parameterIndex,
int sqlType)
Sets the type at the specified parameterIndex to SQL NULL. |
void |
setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
Sets the user-named type or REF type at the specified parameterIndex to SQL NULL. |
void |
setObject(int parameterIndex,
java.lang.Object value)
Sets the object value at the specified parameterIndex. |
void |
setObject(int parameterIndex,
java.lang.Object value,
int targetSqlType)
Sets the object value at the specified parameterIndex. |
void |
setObject(int parameterIndex,
java.lang.Object value,
int targetSqlType,
int scale)
Sets the object value at the specified parameterIndex. |
void |
setPassword(java.lang.String password)
Sets the password used to make the connection. |
void |
setQueryTimeout(int timeout)
Sets the maximum wait time in seconds for a statement to execute. |
void |
setReadOnly(boolean readOnly)
Sets whether the rowset is read-only. |
void |
setRef(int parameterIndex,
java.sql.Ref value)
Sets Ref value at the specified parameterIndex. |
void |
setShort(int parameterIndex,
short value)
Sets the short value at the specified parameterIndex. |
void |
setString(int parameterIndex,
java.lang.String value)
Sets the string value at the specified parameterIndex. |
void |
setTime(int parameterIndex,
java.sql.Time value)
Sets the time value at the specified parameterIndex. |
void |
setTime(int parameterIndex,
java.sql.Time value,
java.util.Calendar calendar)
Sets the time value at the specified parameterIndex. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp value)
Sets the timestamp value at the specified parameterIndex. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp value,
java.util.Calendar calendar)
Sets the timestamp value at the specified parameterIndex. |
void |
setTransactionIsolation(int level)
Sets the transaction isolation level. |
void |
setType(int type)
Sets the result set type. |
void |
setTypeMap(java.util.Map map)
Sets the type map to be used for distinct and structured types. |
void |
setUrl(java.lang.String url)
Sets the URL used for getting a connection. |
void |
setUseDataSource(boolean useDataSource)
Sets whether the data source is used to make a connection to the database. |
void |
setUsername(java.lang.String username)
Sets the user name used to make the connection. |
java.lang.String |
toString()
Returns the name of the SQL cursor in use by the result set. |
void |
updateArray(int columnIndex,
java.sql.Array columnValue)
Updates a column in the current row using an Array value. |
void |
updateArray(java.lang.String columnName,
java.sql.Array columnValue)
Updates a column in the current row using an Array value. |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream columnValue,
int length)
Updates a column in the current row using an ASCII stream value. |
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream columnValue,
int length)
Updates a column in the current row using an ASCII stream value. |
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal columnValue)
Updates a column in the current row using a BigDecimal value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal columnValue)
Updates a column in the current row using a BigDecimal value. |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream columnValue,
int length)
Updates a column in the current row using a binary stream value. |
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream columnValue,
int length)
Updates a column in the current row using a binary stream value. |
void |
updateBlob(int columnIndex,
java.sql.Blob columnValue)
Updates a column in the current row using a Java Blob value. |
void |
updateBlob(java.lang.String columnName,
java.sql.Blob columnValue)
Updates a column in the current row using a Java Blob value. |
void |
updateBoolean(int columnIndex,
boolean columnValue)
Updates a column in the current row using a Java boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean columnValue)
Updates a column in the current row using a Java boolean value. |
void |
updateByte(int columnIndex,
byte columnValue)
Updates a column in the current row using a Java byte value. |
void |
updateByte(java.lang.String columnName,
byte columnValue)
Updates a column in the current row using a Java byte value. |
void |
updateBytes(int columnIndex,
byte[] columnValue)
Updates a column in the current row using a Java byte array value. |
void |
updateBytes(java.lang.String columnName,
byte[] columnValue)
Updates a column in the current row using a Java byte array value. |
void |
updateCharacterStream(int columnIndex,
java.io.Reader columnValue,
int length)
Updates a column in the current row using a Reader value. |
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader columnValue,
int length)
Updates a column in the current row using a Reader value. |
void |
updateClob(int columnIndex,
java.sql.Clob columnValue)
Updates a column in the current row using a Java Clob value. |
void |
updateClob(java.lang.String columnName,
java.sql.Clob columnValue)
Updates a column in the current row using a Java Clob value. |
void |
updateDate(int columnIndex,
java.sql.Date columnValue)
Updates a column in the current row using a java.sql.Date value. |
void |
updateDate(java.lang.String columnName,
java.sql.Date columnValue)
Updates a column in the current row using a java.sql.Date value. |
void |
updateDouble(int columnIndex,
double columnValue)
Updates a column in the current row using a Java double value. |
void |
updateDouble(java.lang.String columnName,
double columnValue)
Updates a column in the current row using a Java double value. |
void |
updateFloat(int columnIndex,
float columnValue)
Updates a column in the current row using a Java float value. |
void |
updateFloat(java.lang.String columnName,
float columnValue)
Updates a column in the current row using a Java float value. |
void |
updateInt(int columnIndex,
int columnValue)
Updates a column in the current row using a Java int value. |
void |
updateInt(java.lang.String columnName,
int columnValue)
Updates a column in the current row using a Java int value. |
void |
updateLong(int columnIndex,
long columnValue)
Updates a column in the current row using a Java long value. |
void |
updateLong(java.lang.String columnName,
long columnValue)
Updates a column in the current row using a Java long value. |
void |
updateNull(int columnIndex)
Updates a column in the current row using SQL NULL. |
void |
updateNull(java.lang.String columnName)
Updates a column in the current row using SQL NULL. |
void |
updateObject(int columnIndex,
java.lang.Object columnValue)
Updates a column in the current row using an Object value. |
void |
updateObject(int columnIndex,
java.lang.Object columnValue,
int scale)
Updates a column in the current row using an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object columnValue)
Updates a column in the current row using an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object columnValue,
int scale)
Updates a column in the current row using an Object value. |
void |
updateRef(int columnIndex,
java.sql.Ref columnValue)
Updates a column in the current row using an Ref value. |
void |
updateRef(java.lang.String columnName,
java.sql.Ref columnValue)
Updates a column in the current row using an Ref value. |
void |
updateRow()
Updates the database with the new contents of the current row. |
void |
updateShort(int columnIndex,
short columnValue)
Updates a column in the current row using a Java short value. |
void |
updateShort(java.lang.String columnName,
short columnValue)
Updates a column in the current row using a Java short value. |
void |
updateString(int columnIndex,
java.lang.String columnValue)
Updates a column in the current row using a String value. |
void |
updateString(java.lang.String columnName,
java.lang.String columnValue)
Updates a column in the current row using a String value. |
void |
updateTime(int columnIndex,
java.sql.Time columnValue)
Updates a column in the current row using a java.sql.Time value. |
void |
updateTime(java.lang.String columnName,
java.sql.Time columnValue)
Updates a column in the current row using a java.sql.Time value. |
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp columnValue)
Updates a column in the current row using a java.sql.Timestamp value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp columnValue)
Updates a column in the current row using a java.sql.Timestamp value. |
boolean |
wasNull()
Indicates if the last column read has the value of SQL NULL. |
Methods inherited from class java.lang.Object |
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
public AS400JDBCRowSet()
public AS400JDBCRowSet(java.lang.String dataSourceName)
dataSourceName
- The name of the data source used to make the connection.public AS400JDBCRowSet(java.lang.String url, java.lang.String username, java.lang.String password)
url
- The url used to make the connection.username
- The user name.password
- The password.Method Detail |
public boolean absolute(int rowNumber) throws java.sql.SQLException
Attempting to move beyond the first row positions the cursor before the first row. Attempting to move beyond the last row positions the cursor after the last row.
If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
absolute
in interface java.sql.ResultSet
rowNumber
- The absolute row number (1-based). If the absolute row
number is positive, this positions the cursor
with respect to the beginning of the result set.
If the absolute row number is negative, this
positions the cursor with respect to the end
of result set.java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
the row number is 0,
or an error occurs.public void addPropertyChangeListener(java.beans.PropertyChangeListener listener)
listener
- The PropertyChangeListener.removePropertyChangeListener(java.beans.PropertyChangeListener)
public void addRowSetListener(javax.sql.RowSetListener listener)
addRowSetListener
in interface javax.sql.RowSet
listener
- The RowSetListener object.public void afterLast() throws java.sql.SQLException
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.public void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.public void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open
or the result set is not updatable.public void clearParameters() throws java.sql.SQLException
clearParameters
in interface javax.sql.RowSet
java.sql.SQLException
- If a database error occurs.public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the cursor is positioned on the insert row,
or an error occurs.public void execute() throws java.sql.SQLException
execute
in interface javax.sql.RowSet
java.sql.SQLException
- If a database error occurs.protected void finalize() throws java.sql.SQLException
finalize
in class java.lang.Object
java.sql.SQLException
- If a database error occurs.public int findColumn(java.lang.String columnName) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open
or the column name is not found.public boolean first() throws java.sql.SQLException
first
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open, the result set is not scrollable, or an error occurs.public java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support arrays.public java.sql.Array getArray(java.lang.String columnName) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support arrays.public java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found,
or the requested conversion is not valid.public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).scale
- The number of digits after the decimal.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the scale is not valid, or the
requested conversion is not valid.getBigDecimal(int)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnName
- The column name.scale
- The number of digits after the decimal.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found,
the scale is not valid, or the
requested conversion is not valid.getBigDecimal(String)
public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.sql.Blob getBlob(java.lang.String columnName) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public boolean getBoolean(int columnIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public byte getByte(int columnIndex) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public byte getByte(java.lang.String columnName) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public byte[] getBytes(int columnIndex) throws java.sql.SQLException
This can also be used to get values from columns with other types. The values are returned in their native OS/400 format. This is not supported for result sets returned by a DatabaseMetaData object.
getBytes
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
This can also be used to get values from columns with other types. The values are returned in their native OS/400 format. This is not supported for result sets returned by a DatabaseMetaData object.
getBytes
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not valid, or the
requested conversion is not valid.public java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.sql.Clob getClob(java.lang.String columnName) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.lang.String getCommand()
getCommand
in interface javax.sql.RowSet
public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public javax.naming.Context getContext()
public java.lang.String getCursorName() throws java.sql.SQLException
getCursorName
in interface java.sql.ResultSet
java.sql.SQLException
- If the result is not open.public java.lang.String getDataSourceName()
getDataSourceName
in interface javax.sql.RowSet
public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.sql.Date getDate(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).calendar
- The calendar.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar calendar) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnName
- The column name.calendar
- The calendar.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found,
the calendar is null, or the
requested conversion is not valid.public double getDouble(int columnIndex) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public double getDouble(java.lang.String columnName) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.util.Hashtable getEnvironment()
public boolean getEscapeProcessing()
getEscapeProcessing
in interface javax.sql.RowSet
public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
- If the result is not open.public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
- If the result is not open.public float getFloat(int columnIndex) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public float getFloat(java.lang.String columnName) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public int getInt(int columnIndex) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public int getInt(java.lang.String columnName) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public long getLong(int columnIndex) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public long getLong(java.lang.String columnName) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public int getMaxFieldSize() throws java.sql.SQLException
getMaxFieldSize
in interface javax.sql.RowSet
java.sql.SQLException
- If a database error occurs.public int getMaxRows() throws java.sql.SQLException
getMaxRows
in interface javax.sql.RowSet
java.sql.SQLException
- If a database error occurs.public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.lang.Object getObject(int columnIndex, java.util.Map typeMap) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).typeMap
- The type map. This is not used.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the type map is null, or the
requested conversion is not valid.public java.lang.Object getObject(java.lang.String columnName, java.util.Map typeMap) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnName
- The column name.typeMap
- The type map. This is not used.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found,
the type map is null, or the
requested conversion is not valid.public java.lang.String getPassword()
getPassword
in interface javax.sql.RowSet
public int getQueryTimeout() throws java.sql.SQLException
getQueryTimeout
in interface javax.sql.RowSet
java.sql.SQLException
- If a database error occurs.public java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support structured types.public java.sql.Ref getRef(java.lang.String columnName) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support structured types.public int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public short getShort(int columnIndex) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public short getShort(java.lang.String columnName) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.sql.Time getTime(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).calendar
- The calendar.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar calendar) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnName
- The column name.calendar
- The calendar.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found,
the calendar is null, or the
requested conversion is not valid.public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar calendar) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).calendar
- The calendar.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid,
the calendar is null, or the
requested conversion is not valid.public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar calendar) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnName
- The column name.calendar
- The calendar.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found,
the calendar is null, or the
requested conversion is not valid.public int getTransactionIsolation()
getTransactionIsolation
in interface javax.sql.RowSet
public int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public java.util.Map getTypeMap() throws java.sql.SQLException
getTypeMap
in interface javax.sql.RowSet
java.sql.SQLException
- If a database error occurs.public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.getCharacterStream(int)
public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.getCharacterStream(String)
public java.lang.String getUrl()
getUrl
in interface javax.sql.RowSet
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
columnIndex
- The column index (1-based).java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed or
the requested conversion is not valid.public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
columnName
- The column name.java.sql.SQLException
- If the statement is not open,
the index is not valid, the parameter name is
not registered as an output parameter,
the statement was not executed or
the requested conversion is not valid.public java.lang.String getUsername()
getUsername
in interface javax.sql.RowSet
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on the insert row,
a column that is not nullable was not specified,
or an error occurs.public boolean isAfterLast() throws java.sql.SQLException
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public boolean isBeforeFirst() throws java.sql.SQLException
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public boolean isFirst() throws java.sql.SQLException
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public boolean isLast() throws java.sql.SQLException
isLast
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public boolean isReadOnly()
isReadOnly
in interface javax.sql.RowSet
public boolean isUseDataSource()
public boolean last() throws java.sql.SQLException
last
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
or an error occurs.public void moveToCurrentRow() throws java.sql.SQLException
If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
or an error occurs.public void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
the result set is not updatable,
or an error occurs.public boolean next() throws java.sql.SQLException
next
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
or an error occurs.public boolean previous() throws java.sql.SQLException
previous
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
or an error occurs.public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
the cursor is not positioned on a row,
the cursor is positioned on the
insert row or an error occurs.public boolean relative(int rowNumber) throws java.sql.SQLException
Attempting to move beyond the first row positions the cursor before the first row. Attempting to move beyond the last row positions the cursor after the last row.
If an InputStream from the current row is open, it is implicitly closed. In addition, all warnings and pending updates are cleared.
relative
in interface java.sql.ResultSet
rowNumber
- The relative row number. If the relative row
number is positive, this positions the cursor
after the current position. If the relative
row number is negative, this positions the
cursor before the current position. If the
relative row number is 0, then the cursor
position does not change.java.sql.SQLException
- If the result set is not open,
the result set is not scrollable,
the cursor is not positioned on a valid row,
or an error occurs.public void removePropertyChangeListener(java.beans.PropertyChangeListener listener)
listener
- The PropertyChangeListener.addPropertyChangeListener(java.beans.PropertyChangeListener)
public void removeRowSetListener(javax.sql.RowSetListener listener)
removeRowSetListener
in interface javax.sql.RowSet
listener
- The RowSetListener object.public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public void setArray(int parameterIndex, java.sql.Array value) throws java.sql.SQLException
setArray
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Array object.java.sql.SQLException
- If a database error occurs.public void setAsciiStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException
setAsciiStream
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).inputStream
- The input stream or null to update the value to SQL NULL.length
- The number of bytes in the stream.java.sql.SQLException
- If the result set is not open, the result set is not updatable,
the cursor is not positioned on a row, the column index is not valid, or the requested
conversion is not valid, the length is not valid, or an error happens while reading the
input stream.public void setBigDecimal(int parameterIndex, java.math.BigDecimal value) throws java.sql.SQLException
setBigDecimal
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The BigDecimal object.java.sql.SQLException
- If a database error occurs.public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException
setBinaryStream
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).inputStream
- The input stream or null to update the value to SQL NULL.length
- The number of bytes in the stream.java.sql.SQLException
- If the result set is not open, the result set is not updatable,
the cursor is not positioned on a row, the column index is not valid, or the requested
conversion is not valid, the length is not valid, or an error happens while reading the
input stream.public void setBlob(int parameterIndex, java.sql.Blob value) throws java.sql.SQLException
setBlob
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Blob object.java.sql.SQLException
- If a database error occurs.public void setBoolean(int parameterIndex, boolean value) throws java.sql.SQLException
setBoolean
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The boolean value.java.sql.SQLException
- If a database error occurs.public void setByte(int parameterIndex, byte value) throws java.sql.SQLException
setByte
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The byte value.java.sql.SQLException
- If a database error occurs.public void setBytes(int parameterIndex, byte[] value) throws java.sql.SQLException
setBytes
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The byte array.java.sql.SQLException
- If a database error occurs.public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
setCharacterStream
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).reader
- The reader or null to update the value to SQL NULL.length
- The number of characters in the stream.java.sql.SQLException
- If the result set is not open, the result set is not updatable,
the cursor is not positioned on a row, the column index is not valid,
or the requested conversion is not valid, the length is not valid, or
an error happens while reading the input stream.public void setClob(int parameterIndex, java.sql.Clob value) throws java.sql.SQLException
setClob
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Clob object.java.sql.SQLException
- If a database error occurs.public void setCommand(java.lang.String command) throws java.sql.SQLException
setCommand
in interface javax.sql.RowSet
command
- The command.java.sql.SQLException
- If a database error occurs.public void setConcurrency(int concurrency)
setConcurrency
in interface javax.sql.RowSet
concurrency
- The concurrency type.public void setContext(javax.naming.Context context)
context
- A JNDI naming context.public void setDataSourceName(java.lang.String dataSourceName)
setDataSourceName
in interface javax.sql.RowSet
dataSourceName
- The iSeries data source name.public void setDate(int parameterIndex, java.sql.Date value) throws java.sql.SQLException
setDate
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Date object.java.sql.SQLException
- If a database error occurs.public void setDate(int parameterIndex, java.sql.Date value, java.util.Calendar calendar) throws java.sql.SQLException
setDate
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Date object.calendar
- The Calendar object.java.sql.SQLException
- If a database error occurs.public void setDouble(int parameterIndex, double value) throws java.sql.SQLException
setDouble
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The double value.java.sql.SQLException
- If a database error occurs.public void setEnvironment(java.util.Hashtable environment)
environment
- A Hashtable of JNDI environment properties.public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
setEscapeProcessing
in interface javax.sql.RowSet
enable
- true if enabled; false otherwise. The default value is true.java.sql.SQLException
- If a database error occurs.public void setFetchDirection(int fetchDirection) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
fetchDirection
- The fetch direction for processing rows.
Valid values are:
java.sql.SQLException
- If the result set is not open, the result set is scrollable
and the input value is not ResultSet.FETCH_FORWARD,
or the input value is not valid.public void setFetchSize(int fetchSize) throws java.sql.SQLException
This setting only affects statements that meet the criteria specified in the "block criteria" property. The fetch size is only used if the "block size" property is set to "0".
setFetchSize
in interface java.sql.ResultSet
fetchSize
- The number of rows. This must be greater than
or equal to 0 and less than or equal to the
maximum rows limit. The default is the
statement's fetch size.java.sql.SQLException
- If the result set is not open
or the input value is not valid.public void setFloat(int parameterIndex, float value) throws java.sql.SQLException
setFloat
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The float value.java.sql.SQLException
- If a database error occurs.public void setInt(int parameterIndex, int value) throws java.sql.SQLException
setInt
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The integer value.java.sql.SQLException
- If a database error occurs.public void setLong(int parameterIndex, long value) throws java.sql.SQLException
setLong
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The long value.java.sql.SQLException
- If a database error occurs.public void setMaxFieldSize(int maxFieldSize) throws java.sql.SQLException
setMaxFieldSize
in interface javax.sql.RowSet
maxFieldSize
- The maximum column size.java.sql.SQLException
- If a database error occurs.public void setMaxRows(int maxRows) throws java.sql.SQLException
setMaxRows
in interface javax.sql.RowSet
maxRows
- The maximum number of rows.java.sql.SQLException
- If a database error occurs.public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
setNull
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).sqlType
- The SQL type.java.sql.SQLException
- If a database error occurs.public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).sqlType
- The SQL type.typeName
- The fully qualified name of an SQL user-named type. This parameter is not used if the type is REF.java.sql.SQLException
- If a database error occurs.public void setObject(int parameterIndex, java.lang.Object value) throws java.sql.SQLException
setObject
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Object value.java.sql.SQLException
- If a database error occurs.public void setObject(int parameterIndex, java.lang.Object value, int targetSqlType) throws java.sql.SQLException
setObject
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Object value.targetSqlType
- The SQL type.java.sql.SQLException
- If a database error occurs.public void setObject(int parameterIndex, java.lang.Object value, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Object value.targetSqlType
- The SQL type.scale
- The number of digits after the decimal point. This parameter is used only for SQL types Decimal or Numeric.java.sql.SQLException
- If a database error occurs.public void setPassword(java.lang.String password)
setPassword
in interface javax.sql.RowSet
password
- The password.public void setQueryTimeout(int timeout) throws java.sql.SQLException
setQueryTimeout
in interface javax.sql.RowSet
timeout
- The timeout value in seconds. The default value is zero indicating no maximum value.java.sql.SQLException
- If a database error occurs.public void setReadOnly(boolean readOnly) throws java.sql.SQLException
setReadOnly
in interface javax.sql.RowSet
readOnly
- true if read-only; false otherwise.java.sql.SQLException
- If a database error occurs.public void setRef(int parameterIndex, java.sql.Ref value) throws java.sql.SQLException
setRef
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Ref object.java.sql.SQLException
- If a database error occurs.public void setShort(int parameterIndex, short value) throws java.sql.SQLException
setShort
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The short value.java.sql.SQLException
- If a database error occurs.public void setString(int parameterIndex, java.lang.String value) throws java.sql.SQLException
setString
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The String object.java.sql.SQLException
- If a database error occurs.public void setTime(int parameterIndex, java.sql.Time value) throws java.sql.SQLException
setTime
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Time object.java.sql.SQLException
- If a database error occurs.public void setTime(int parameterIndex, java.sql.Time value, java.util.Calendar calendar) throws java.sql.SQLException
setTime
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Time object.calendar
- The Calendar object.java.sql.SQLException
- If a database error occurs.public void setTimestamp(int parameterIndex, java.sql.Timestamp value) throws java.sql.SQLException
setTimestamp
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Timestamp object.java.sql.SQLException
- If a database error occurs.public void setTimestamp(int parameterIndex, java.sql.Timestamp value, java.util.Calendar calendar) throws java.sql.SQLException
setTimestamp
in interface javax.sql.RowSet
parameterIndex
- The parameter index (1-based).value
- The Timestamp object.calendar
- The Calendar object.java.sql.SQLException
- If a database error occurs.public void setTransactionIsolation(int level) throws java.sql.SQLException
setTransactionIsolation
in interface javax.sql.RowSet
level
- The transaction isolation level.
Possible values are:
java.sql.SQLException
- If a database error occurs.public void setType(int type) throws java.sql.SQLException
setType
in interface javax.sql.RowSet
type
- The type.java.sql.SQLException
- If a database error occurs.public void setTypeMap(java.util.Map map) throws java.sql.SQLException
setTypeMap
in interface javax.sql.RowSet
map
- The type map.java.sql.SQLException
- If a database error occurs.public void setUrl(java.lang.String url)
setUrl
in interface javax.sql.RowSet
The
- URL.setUseDataSource(boolean)
public void setUseDataSource(boolean useDataSource)
useDataSource
- true if the data source is used; false if the URL is used.
The default value is true.public void setUsername(java.lang.String username)
setUsername
in interface javax.sql.RowSet
username
- The user name.public java.lang.String toString()
toString
in class java.lang.Object
public void updateArray(int columnIndex, java.sql.Array columnValue) throws java.sql.SQLException
columnIndex
- The column index (1-based).java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support arrays.public void updateArray(java.lang.String columnName, java.sql.Array columnValue) throws java.sql.SQLException
columnIndex
- The column name.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support arrays.public void updateAsciiStream(int columnIndex, java.io.InputStream columnValue, int length) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.length
- The length.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, the
requested conversion is not valid,
the length is not
valid, the input stream does not contain
ASCII characters, or an error happens
while reading the input stream.public void updateAsciiStream(java.lang.String columnName, java.io.InputStream columnValue, int length) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.length
- The length.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, the
requested conversion is not valid,
the length is not valid,
the input stream does not contain
ASCII characters, or an error happens
while reading the input stream.public void updateBigDecimal(int columnIndex, java.math.BigDecimal columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBigDecimal
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateBinaryStream(int columnIndex, java.io.InputStream columnValue, int length) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update the value to SQL NULL.length
- The length.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid,
the length is not valid, or an error
happens while reading the input stream.public void updateBinaryStream(java.lang.String columnName, java.io.InputStream columnValue, int length) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.length
- The length.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid,
the length is not valid, or an error
happens while reading the input stream.public void updateBlob(int columnIndex, java.sql.Blob columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateBlob(java.lang.String columnName, java.sql.Blob columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateBoolean(int columnIndex, boolean columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBoolean
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateBoolean(java.lang.String columnName, boolean columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBoolean
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateByte(int columnIndex, byte columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateByte
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateByte(java.lang.String columnName, byte columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateByte
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateBytes(int columnIndex, byte[] columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBytes
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateBytes(java.lang.String columnName, byte[] columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateBytes
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateCharacterStream(int columnIndex, java.io.Reader columnValue, int length) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.length
- The length.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid,
the length is not valid, or an error
happens while reading the input stream.public void updateCharacterStream(java.lang.String columnName, java.io.Reader columnValue, int length) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.length
- The length.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid,
the length is not valid, or an error
happens while reading the input stream.public void updateClob(int columnIndex, java.sql.Clob columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateClob(java.lang.String columnName, java.sql.Clob columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateDate(int columnIndex, java.sql.Date columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateDate
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateDate(java.lang.String columnName, java.sql.Date columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateDate
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateDouble(int columnIndex, double columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateDouble
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateDouble(java.lang.String columnName, double columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateDouble
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateFloat(int columnIndex, float columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateFloat
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateFloat(java.lang.String columnName, float columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateFloat
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateInt(int columnIndex, int columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateInt
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateInt(java.lang.String columnName, int columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateInt
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateLong(int columnIndex, long columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateLong
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateLong(java.lang.String columnName, long columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateLong
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateNull(int columnIndex) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateNull
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateNull(java.lang.String columnName) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateNull
in interface java.sql.ResultSet
columnName
- The column name.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateObject(int columnIndex, java.lang.Object columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateObject
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.public void updateObject(java.lang.String columnName, java.lang.Object columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateObject
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found,
or the requested conversion is not valid.public void updateObject(int columnIndex, java.lang.Object columnValue, int scale) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateObject
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.scale
- The number of digits after the decimal
if SQL type is DECIMAL or NUMERIC.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
the scale is not valid, or the
requested conversion is not valid.public void updateObject(java.lang.String columnName, java.lang.Object columnValue, int scale) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateObject
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.scale
- The number of digits after the decimal
if SQL type is DECIMAL or NUMERIC.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found,
the scale is not valid, or the
requested conversion is not valid.public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the cursor is positioned on the insert row,
or an error occurs.public void updateRef(int columnIndex, java.sql.Ref columnValue) throws java.sql.SQLException
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support REFs.public void updateRef(java.lang.String columnName, java.sql.Ref columnValue) throws java.sql.SQLException
columnIndex
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- Always thrown because DB2
UDB for iSeries does not support REFs.public void updateShort(int columnIndex, short columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateShort
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateShort(java.lang.String columnName, short columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateShort
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateString(int columnIndex, java.lang.String columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateString
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid,
or the requested conversion is not valid.public void updateString(java.lang.String columnName, java.lang.String columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateString
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateTime(int columnIndex, java.sql.Time columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateTime
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateTime(java.lang.String columnName, java.sql.Time columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateTime
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public void updateTimestamp(int columnIndex, java.sql.Timestamp columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- The column index (1-based).columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column index is not valid, or the
requested conversion is not valid.public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp columnValue) throws java.sql.SQLException
This does not update the database directly. Instead, it updates a copy of the data in memory. Call updateRow() or insertRow() to update the database.
updateTimestamp
in interface java.sql.ResultSet
columnName
- The column name.columnValue
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If the result set is not open,
the result set is not updatable,
the cursor is not positioned on a row,
the column name is not found, or the
requested conversion is not valid.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |