public class AS400JDBCArrayResultSet
extends java.lang.Object
implements java.sql.ResultSet
Modifier and Type | Method and Description |
---|---|
boolean |
absolute(int row)
Positions the cursor to an absolute row number.
|
void |
afterLast()
Positions the cursor after the last row.
|
void |
beforeFirst()
Sets cursor position before the first row.
|
void |
cancelRowUpdates()
Cancels all pending updates that have been made since the last
call to updateRow().
|
void |
clearWarnings()
Clears all warnings that have been reported for the result set.
|
void |
close()
Closes this ResultSet
|
void |
deleteRow()
Deletes the current row from the result set and the database.
|
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 column)
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 column)
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 column)
Returns the value of a column as a BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(int column,
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(int) instead.
|
java.io.InputStream |
getBinaryStream(int column)
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 column)
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 column)
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 column)
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 column)
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 column)
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 column)
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.
|
int |
getConcurrency()
Returns the result set concurrency.
|
java.lang.String |
getCursorName()
Returns the name of the SQL cursor in use by the result set.
|
java.sql.Date |
getDate(int column)
Returns the value of a column as a java.sql.Date object using
the default calendar.
|
java.sql.Date |
getDate(int column,
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 column)
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.
|
int |
getFetchDirection()
Returns the fetch direction.
|
int |
getFetchSize()
Returns the fetch size.
|
float |
getFloat(int column)
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 |
getHoldability()
Retrieves the holdability.
|
int |
getInt(int column)
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 column)
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.
|
java.sql.ResultSetMetaData |
getMetaData()
Returns the ResultSetMetaData object that describes the
result set's columns.
|
java.io.Reader |
getNCharacterStream(int column)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
java.io.Reader |
getNCharacterStream(java.lang.String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
java.lang.String |
getNString(int column)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
java.lang.String |
getNString(java.lang.String columnName)
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
java.lang.Object |
getObject(int column)
Returns the value of a column as a Java Object.
|
java.lang.Object |
getObject(int columnIndex,
java.lang.Class type) |
java.lang.Object |
getObject(int column,
java.util.Map map)
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 columnLabel,
java.lang.Class type) |
java.lang.Object |
getObject(java.lang.String columnName,
java.util.Map map)
Returns the value of a column as a Java Object.
|
java.sql.Ref |
getRef(int column)
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()
Retrieves the current row number.
|
short |
getShort(int column)
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 column)
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 column)
Returns the value of a column as a java.sql.Time object using the
default calendar.
|
java.sql.Time |
getTime(int column,
java.util.Calendar calendar)
Returns the value of a column as a java.sql.Time object using the
default calendar.
|
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 the
default calendar.
|
java.sql.Timestamp |
getTimestamp(int column)
Returns the value of a column as a java.sql.Timestamp object
using the default calendar.
|
java.sql.Timestamp |
getTimestamp(int column,
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 |
getType()
Returns the result set type.
|
java.io.InputStream |
getUnicodeStream(int column)
Deprecated.
Use getCharacterStream(int) instead.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated.
Use getCharacterStream(String) instead.
|
java.net.URL |
getURL(int column)
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.
|
protected java.lang.String[] |
getValidWrappedList() |
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 |
isClosed()
Indicates if the result set is closed.
|
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 |
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.
|
boolean |
relative(int rows)
Positions the cursor to a relative row number.
|
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 |
setFetchDirection(int direction)
Sets the direction in which the rows in a result set are
processed.
|
void |
setFetchSize(int rows)
Sets the number of rows to be fetched from the database when more
rows are needed.
|
void |
updateArray(int column,
java.sql.Array x)
Updates the value of a column as an Array object.
|
void |
updateArray(java.lang.String columnName,
java.sql.Array x)
Updates the value of a column as an Array object.
|
void |
updateAsciiStream(int column,
java.io.InputStream x)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateAsciiStream(int column,
java.io.InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateAsciiStream(int column,
java.io.InputStream x,
long length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
long length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateBigDecimal(int column,
java.math.BigDecimal x)
Updates a column in the current row using a BigDecimal value.
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
Updates a column in the current row using a BigDecimal value.
|
void |
updateBinaryStream(int column,
java.io.InputStream x)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(int column,
java.io.InputStream x,
int length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
updateBinaryStream(int column,
java.io.InputStream x,
long length)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
long length)
Updates the designated column with a binary stream value.
|
void |
updateBlob(int column,
java.sql.Blob x)
Updates a column in the current row using a Java Blob value.
|
void |
updateBlob(int column,
java.io.InputStream x)
Updates the designated column using the given input stream.
|
void |
updateBlob(int column,
java.io.InputStream x,
long length)
Updates the designated column using the given input stream.
|
void |
updateBlob(java.lang.String columnName,
java.sql.Blob x)
Updates a column in the current row using a Java Blob value.
|
void |
updateBlob(java.lang.String columnName,
java.io.InputStream x)
Updates the designated column using the given input stream.
|
void |
updateBlob(java.lang.String columnName,
java.io.InputStream x,
long length)
Updates the designated column using the given input stream.
|
void |
updateBoolean(int column,
boolean x)
Updates a column in the current row using a Java boolean value.
|
void |
updateBoolean(java.lang.String columnName,
boolean x)
Updates a column in the current row using a Java boolean value.
|
void |
updateByte(int column,
byte x)
Updates a column in the current row using a Java byte value.
|
void |
updateByte(java.lang.String columnName,
byte x)
Updates a column in the current row using a Java byte value.
|
void |
updateBytes(int column,
byte[] x)
Updates a column in the current row using a Java byte array value.
|
void |
updateBytes(java.lang.String columnName,
byte[] x)
Updates a column in the current row using a Java byte array value.
|
void |
updateCharacterStream(int column,
java.io.Reader x)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(int column,
java.io.Reader x,
int length)
Updates a column in the current row using a Reader value.
|
void |
updateCharacterStream(int column,
java.io.Reader x,
long length)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader x)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
int length)
Updates a column in the current row using a Reader value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
long length)
Updates the designated column with a character stream value.
|
void |
updateClob(int column,
java.sql.Clob x)
Updates a column in the current row using a Java Clob value.
|
void |
updateClob(int column,
java.io.Reader x)
Updates the designated column using the given
Reader
object. |
void |
updateClob(int column,
java.io.Reader x,
long length)
Updates the designated column using the given
Reader
object. |
void |
updateClob(java.lang.String columnName,
java.sql.Clob x)
Updates a column in the current row using a Java Clob value.
|
void |
updateClob(java.lang.String columnName,
java.io.Reader x)
Updates the designated column using the given
Reader
object. |
void |
updateClob(java.lang.String columnName,
java.io.Reader x,
long length)
Updates the designated column using the given
Reader
object. |
void |
updateDate(int column,
java.sql.Date x)
Updates a column in the current row using a java.sql.Date value.
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
Updates a column in the current row using a java.sql.Date value.
|
void |
updateDouble(int column,
double x)
Updates a column in the current row using a Java double value.
|
void |
updateDouble(java.lang.String columnName,
double x)
Updates a column in the current row using a Java double value.
|
void |
updateFloat(int column,
float x)
Updates a column in the current row using a Java float value.
|
void |
updateFloat(java.lang.String columnName,
float x)
Updates a column in the current row using a Java float value.
|
void |
updateInt(int column,
int x)
Updates a column in the current row using a Java int value.
|
void |
updateInt(java.lang.String columnName,
int x)
Updates a column in the current row using a Java int value.
|
void |
updateLong(int column,
long x)
Updates a column in the current row using a Java long value.
|
void |
updateLong(java.lang.String columnName,
long x)
Updates a column in the current row using a Java long value.
|
void |
updateNCharacterStream(int column,
java.io.Reader x)
Updates the designated column with a character stream value.
|
void |
updateNCharacterStream(int column,
java.io.Reader x,
long length)
Updates the designated column with a character stream value.
|
void |
updateNCharacterStream(java.lang.String columnName,
java.io.Reader x)
Updates the designated column with a character stream value.
|
void |
updateNCharacterStream(java.lang.String columnName,
java.io.Reader x,
long length)
Updates the designated column with a character stream value.
|
void |
updateNClob(int column,
java.io.Reader x)
Updates the designated column using the given
Reader |
void |
updateNClob(int column,
java.io.Reader x,
long length)
Updates the designated column using the given
Reader |
void |
updateNClob(java.lang.String columnName,
java.io.Reader x)
Updates the designated column using the given
Reader |
void |
updateNClob(java.lang.String columnName,
java.io.Reader x,
long length)
Updates the designated column using the given
Reader |
void |
updateNString(int column,
java.lang.String x)
Updates the designated column with a
String value. |
void |
updateNString(java.lang.String columnName,
java.lang.String x)
Updates the designated column with a
String value. |
void |
updateNull(int column)
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 column,
java.lang.Object x)
Updates a column in the current row using an Object value.
|
void |
updateObject(int column,
java.lang.Object x,
int scale)
Updates a column in the current row using an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
Updates a column in the current row using an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
Updates a column in the current row using an Object value.
|
void |
updateRef(int column,
java.sql.Ref x)
Updates the value of an SQL REF output parameter as a Ref value.
|
void |
updateRef(java.lang.String columnName,
java.sql.Ref x)
Updates the value of an SQL REF output parameter as a Ref value.
|
void |
updateRow()
Cancels all pending updates that have been made since the last
call to updateRow().
|
void |
updateShort(int column,
short x)
Updates a column in the current row using a Java short value.
|
void |
updateShort(java.lang.String columnName,
short x)
Updates a column in the current row using a Java short value.
|
void |
updateString(int column,
java.lang.String x)
Updates a column in the current row using a String value.
|
void |
updateString(java.lang.String columnName,
java.lang.String x)
Updates a column in the current row using a String value.
|
void |
updateTime(int column,
java.sql.Time x)
Updates a column in the current row using a java.sql.Time value.
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
Updates a column in the current row using a java.sql.Time value.
|
void |
updateTimestamp(int column,
java.sql.Timestamp x)
Updates a column in the current row using a java.sql.Timestamp value.
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
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.
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
public void close() throws java.sql.SQLException
close
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.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 isAfterLast() throws java.sql.SQLException
isAfterLast
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 void beforeFirst() throws java.sql.SQLException
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.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 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 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 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 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 absolute(int row) throws java.sql.SQLException
absolute
in interface java.sql.ResultSet
row
- The absolute row number. 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 boolean relative(int rows) 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.
relative
in interface java.sql.ResultSet
rows
- 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 int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
- If the result is not open.public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
direction
- 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 int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
- If the result is not open.public void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
rows
- 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 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.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- If an error occurs.public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- If an 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 int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open.public boolean getBoolean(int column) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
column
- The column name.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 index is not valid, or the
requested conversion is not valid.public byte getByte(int column) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
column
- The column name.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 index is not valid, or the
requested conversion is not valid.public short getShort(int column) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public int getInt(int column) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
column
- 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(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 column) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public float getFloat(int column) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public double getDouble(int column) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
column
- 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 name is not found, 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.math.BigDecimal getBigDecimal(int column) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
column
- 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 index is not valid,
or the requested conversion is not valid.public java.math.BigDecimal getBigDecimal(int column, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
column
- 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 index is not valid,
the scale is not valid, or the
requested conversion is not valid.getBigDecimal(int)
public java.sql.Date getDate(int column) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.sql.Time getTime(int column) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.sql.Timestamp getTimestamp(int column) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.sql.Date getDate(int column, java.util.Calendar calendar) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
column
- 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 index is not valid,
the calendar is null, or the
requested conversion is not valid.public java.sql.Time getTime(int column, java.util.Calendar calendar) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
column
- 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, 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 index is not valid, or the
requested conversion is not valid.public java.sql.Timestamp getTimestamp(int column, java.util.Calendar calendar) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
column
- 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 index is not valid,
the calendar is null, or the
requested conversion is not valid.public byte[] getBytes(int column) throws java.sql.SQLException
This can also be used to get values from columns with other types. The values are returned in their native IBM i format. This is not supported for result sets returned by a DatabaseMetaData object.
getBytes
in interface java.sql.ResultSet
column
- 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 IBM i 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 index is not valid, or the
requested conversion is not valid.public java.lang.String getString(int column) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.io.InputStream getBinaryStream(int column) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.io.InputStream getAsciiStream(int column) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
column
- 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 index is not valid,
or the requested conversion is not valid.public java.io.InputStream getUnicodeStream(int column) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.getCharacterStream(String)
public java.io.Reader getCharacterStream(int column) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.sql.Blob getBlob(int column) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.sql.Clob getClob(int column) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.sql.Array getArray(int column) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
column
- The column index (1-based).java.sql.SQLException
- This function is not supported.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 for IBMi does not support arrays in result sets.public java.sql.Ref getRef(int column) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
column
- The column index (1-based).java.sql.SQLException
- Always thrown because DB2 for IBM i 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 for IBM i does not support structured types.public java.net.URL getURL(int column) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
column
- 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
getURL
in interface java.sql.ResultSet
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.Object getObject(int column) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
column
- 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 index is not valid, or the
requested conversion is not valid.public java.lang.Object getObject(int column, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
column
- The column index (1-based).map
- 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 map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
columnName
- The column name.map
- 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 void updateNull(int column) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
column
- 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
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 index is not valid, or the
requested conversion is not valid.public void updateByte(int column, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnName
- The column index (1-based).x
- 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 column, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnName
- The column name.x
- 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 updateBigDecimal(int column, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnName
- The column name.x
- 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 updateBinaryStream(int column, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
column
- column indexx
- the new column valuelength
- the length of the streamjava.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnName
- column indexx
- the new column valuelength
- the length of the streamjava.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateAsciiStream(int column, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
column
- column to setx
- the new column valuelength
- the length of the streamjava.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnName
- column namex
- the new column valuelength
- the length of the streamjava.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateCharacterStream(int column, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.x
- 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 updateBlob(int column, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnName
- The column index (1-based).x
- 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(int column, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
columnName
- The column name.x
- 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 updateArray(int column, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
column
- The column index (1-based).x
- The column value or null if the value is SQL NULL.java.sql.SQLException
- If a database error occurs.public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
columnName
- The column index (1-based).x
- The column value or null if the value is SQL NULL.java.sql.SQLException
- If a database error occurs.public void updateRef(int column, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
column
- The column index (1-based).x
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If a database error occurs.public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
columnName
- The column index (1-based).x
- The column value or null to update
the value to SQL NULL.java.sql.SQLException
- If a database error occurs.public void updateObject(int column, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
column
- The column index (1-based).x
- 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 x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnName
- The column name.x
- 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(int column, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
column
- The column index.x
- The column value or null to update
the value to SQL NULL.scale
- The scale.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 x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnName
- The column name.x
- The column value or null to update
the value to SQL NULL.scale
- The scale.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 boolean rowUpdated() throws java.sql.SQLException
rowUpdated
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 rowDeleted() throws java.sql.SQLException
rowDeleted
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 void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- If the result set is not open
or the result set is not updatable.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 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 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 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 void moveToCurrentRow() throws java.sql.SQLException
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 boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.ResultSet
java.sql.SQLException
- If a database error occurs.public int getHoldability() throws java.sql.SQLException
getHoldability
in interface java.sql.ResultSet
java.sql.SQLException
- if a database error occurspublic java.io.Reader getNCharacterStream(int column) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.getNCharacterStream
in interface java.sql.ResultSet
column
- The column index (1-based).java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming language.java.sql.SQLException
- if a database access error occurspublic java.io.Reader getNCharacterStream(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.getNCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
in the Java programming language.java.sql.SQLException
- if a database access error occurspublic java.lang.String getNString(int column) throws java.sql.SQLException
ResultSet
object as
a String
in the Java programming language.
It is intended for use when
accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.getNString
in interface java.sql.ResultSet
column
- The column index (1-based).NULL
, the
value returned is null
java.sql.SQLException
- if a database access error occurspublic java.lang.String getNString(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a String
in the Java programming language.
It is intended for use when
accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.getNString
in interface java.sql.ResultSet
columnName
- The column name.NULL
, the
value returned is null
java.sql.SQLException
- if a database access error occurspublic void updateAsciiStream(int column, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuejava.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateAsciiStream(java.lang.String columnName, java.io.InputStream x) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuejava.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateAsciiStream(int column, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, long length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if a database access error occurs,
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBinaryStream(int column, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuejava.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBinaryStream(java.lang.String columnName, java.io.InputStream x) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuejava.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBinaryStream(int column, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, long length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(int column, java.io.InputStream x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- An object that contains the data to set the parameter value to.java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(java.lang.String columnName, java.io.InputStream x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnName
- The column name.x
- An object that contains the data to set the parameter value to.java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(int column, java.io.InputStream x, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- An object that contains the data to set the parameter value to.length
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(java.lang.String columnName, java.io.InputStream x, long length) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
columnName
- The column name.x
- An object that contains the data to set the parameter value to.length
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateCharacterStream(int column, java.io.Reader x) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuejava.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateCharacterStream(java.lang.String columnName, java.io.Reader x) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuejava.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateCharacterStream(int column, java.io.Reader x, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateCharacterStream(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateClob(int column, java.io.Reader x) throws java.sql.SQLException
Reader
object.updateClob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- An object that contains the data to set the parameter value to.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateClob(java.lang.String columnName, java.io.Reader x) throws java.sql.SQLException
Reader
object.updateClob
in interface java.sql.ResultSet
columnName
- The column name.x
- An object that contains the data to set the parameter value to.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateClob(int column, java.io.Reader x, long length) throws java.sql.SQLException
Reader
object.updateClob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- An object that contains the data to set the parameter value to.length
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateClob(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLException
Reader
object.updateClob
in interface java.sql.ResultSet
columnName
- The column name.x
- An object that contains the data to set the parameter value to.length
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateNCharacterStream(int column, java.io.Reader x) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuejava.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateNCharacterStream(java.lang.String columnName, java.io.Reader x) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuejava.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateNCharacterStream(int column, java.io.Reader x, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
column
- The column index (1-based).x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLException
updateNCharacterStream
in interface java.sql.ResultSet
columnName
- The column name.x
- the new column valuelength
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateNClob(int column, java.io.Reader x) throws java.sql.SQLException
Reader
updateNClob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- An object that contains the data to set the parameter value to.java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
public void updateNClob(java.lang.String columnName, java.io.Reader x) throws java.sql.SQLException
Reader
updateNClob
in interface java.sql.ResultSet
columnName
- The column name.x
- An object that contains the data to set the parameter value to.java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
public void updateNClob(int column, java.io.Reader x, long length) throws java.sql.SQLException
Reader
updateNClob
in interface java.sql.ResultSet
column
- The column index (1-based).x
- An object that contains the data to set the parameter value to.length
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
public void updateNClob(java.lang.String columnName, java.io.Reader x, long length) throws java.sql.SQLException
Reader
updateNClob
in interface java.sql.ResultSet
columnName
- The column name.x
- An object that contains the data to set the parameter value to.length
- Length of the value.java.sql.SQLException
- if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLY
public void updateNString(int column, java.lang.String x) throws java.sql.SQLException
String
value.
It is intended for use when updating NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.updateNString
in interface java.sql.ResultSet
column
- The column index (1-based).x
- The value for the column to be updatedjava.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; or if a database access error occurspublic void updateNString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
String
value.
It is intended for use when updating NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.updateNString
in interface java.sql.ResultSet
columnName
- The column name.x
- The value for the column to be updatedjava.sql.SQLException
- if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; or if a database access error occurspublic java.lang.Object getObject(int columnIndex, java.lang.Class type) throws java.sql.SQLException
java.sql.SQLException
public java.lang.Object getObject(java.lang.String columnLabel, java.lang.Class type) throws java.sql.SQLException
java.sql.SQLException
protected java.lang.String[] getValidWrappedList()