|
ResultSet Methods
|
Version Introduced
|
Supported
|
Comments
|
|
boolean absolute(int)
|
2.0 Core
|
Yes
|
|
|
void afterLast()
|
2.0 Core
|
Yes
|
|
|
void beforeFirst()
|
2.0 Core
|
Yes
|
|
|
void cancelRowUpdates()
|
2.0 Core
|
Yes
|
|
|
void clearWarnings()
|
1.0
|
Yes
|
|
|
void close()
|
1.0
|
Yes
|
|
|
void deleteRow()
|
2.0 Core
|
Yes
|
|
|
int findColumn(String)
|
1.0
|
Yes
|
|
|
boolean first()
|
2.0 Core
|
Yes
|
|
|
Array getArray(int)
|
2.0 Core
|
Yes
|
|
|
Array getArray(String)
|
2.0 Core
|
Yes
|
|
|
InputStream getAsciiStream(int)
|
1.0
|
Yes
|
|
|
InputStream getAsciiStream(String)
|
1.0
|
Yes
|
|
|
BigDecimal getBigDecimal(int)
|
2.0 Core
|
Yes
|
|
|
BigDecimal getBigDecimal(int, int)
|
1.0
|
Yes
|
|
|
BigDecimal getBigDecimal(String)
|
2.0 Core
|
Yes
|
|
|
BigDecimal getBigDecimal(String, int)
|
1.0
|
Yes
|
|
|
InputStream getBinaryStream(int)
|
1.0
|
Yes
|
The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i when retrieving Blob data.
|
|
InputStream getBinaryStream(String)
|
1.0
|
Yes
|
The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i when retrieving Blob data.
|
|
Blob getBlob(int)
|
2.0 Core
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
Blob getBlob(String)
|
2.0 Core
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
boolean getBoolean(int)
|
1.0
|
Yes
|
|
|
boolean getBoolean(String)
|
1.0
|
Yes
|
|
|
byte getByte(int)
|
1.0
|
Yes
|
|
|
byte getByte(String)
|
1.0
|
Yes
|
|
|
byte [] getBytes(int)
|
1.0
|
Yes
|
The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i when retrieving Blob data.
|
|
byte [] getBytes(String)
|
1.0
|
Yes
|
The DB2 driver supports for all DB2 versions when retrieving BINARY, VARBINARY, and LONGVARBINARY data. The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i when retrieving Blob data.
|
|
Reader getCharacterStream(int)
|
2.0 Core
|
Yes
|
|
|
Reader getCharacterStream(String)
|
2.0 Core
|
Yes
|
|
|
Clob getClob(int)
|
2.0 Core
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
Clob getClob(String)
|
2.0 Core
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
int getConcurrency()
|
2.0 Core
|
Yes
|
|
|
String getCursorName()
|
1.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
Date getDate(int)
|
1.0
|
Yes
|
|
|
Date getDate(int, Calendar)
|
2.0 Core
|
Yes
|
|
|
Date getDate(String)
|
1.0
|
Yes
|
|
|
Date getDate(String, Calendar)
|
2.0 Core
|
Yes
|
|
|
double getDouble(int)
|
1.0
|
Yes
|
|
|
double getDouble(String)
|
1.0
|
Yes
|
|
|
int getFetchDirection()
|
2.0 Core
|
Yes
|
|
|
int getFetchSize()
|
2.0 Core
|
Yes
|
|
|
float getFloat(int)
|
1.0
|
Yes
|
|
|
float getFloat(String)
|
1.0
|
Yes
|
|
|
int getHoldability()
|
4.0
|
Yes
|
|
|
int getInt(int)
|
1.0
|
Yes
|
|
|
int getInt(String)
|
1.0
|
Yes
|
|
|
long getLong(int)
|
1.0
|
Yes
|
|
|
long getLong(String)
|
1.0
|
Yes
|
|
|
ResultSetMetaData getMetaData()
|
1.0
|
Yes
|
|
|
Reader getNCharacterStream(int)
|
4.0
|
Yes
|
|
|
Reader getNCharacterStream(String)
|
4.0
|
Yes
|
|
|
NClob getNClob(int)
|
4.0
|
Yes
|
|
|
NClob getNClob(String)
|
4.0
|
Yes
|
|
|
String getNString(int)
|
4.0
|
Yes
|
|
|
String getNString(String)
|
4.0
|
Yes
|
|
|
Object getObject(int)
|
1.0
|
Yes
|
The DB2 driver returns a Long object when called on Bigint columns.
|
|
Object getObject(int, Map)
|
2.0 Core
|
Yes
|
The Oracle and Sybase drivers support the Map argument. For all other drivers, the Map argument is ignored.
|
|
Object getObject(String)
|
1.0
|
Yes
|
|
|
Object getObject(String, Map)
|
2.0 Core
|
Yes
|
The Oracle and Sybase drivers support the Map argument. For all other drivers, the Map argument is ignored.
|
|
Ref getRef(int)
|
2.0 Core
|
No
|
All drivers throw "unsupported method" exception.
|
|
Ref getRef(String)
|
2.0 Core
|
No
|
All drivers throw "unsupported method" exception.
|
|
int getRow()
|
2.0 Core
|
Yes
|
|
|
short getShort(int)
|
1.0
|
Yes
|
|
|
short getShort(String)
|
1.0
|
Yes
|
|
|
SQLXML getSQLXML(int)
|
4.0
|
Yes
|
|
|
SQLXML getSQLXML(String)
|
4.0
|
Yes
|
|
|
Statement getStatement()
|
2.0 Core
|
Yes
|
|
|
String getString(int)
|
1.0
|
Yes
|
|
|
String getString(String)
|
1.0
|
Yes
|
|
|
Time getTime(int)
|
1.0
|
Yes
|
|
|
Time getTime(int, Calendar)
|
2.0 Core
|
Yes
|
|
|
Time getTime(String)
|
1.0
|
Yes
|
|
|
Time getTime(String, Calendar)
|
2.0 Core
|
Yes
|
|
|
Timestamp getTimestamp(int)
|
1.0
|
Yes
|
|
|
Timestamp getTimestamp(int, Calendar)
|
2.0 Core
|
Yes
|
|
|
Timestamp getTimestamp(String)
|
1.0
|
Yes
|
|
|
Timestamp getTimestamp(String, Calendar)
|
2.0 Core
|
Yes
|
|
|
int getType()
|
2.0 Core
|
Yes
|
|
|
InputStream getUnicodeStream(int)
|
1.0
|
No
|
This method was deprecated in JDBC 2.0. All drivers throw "unsupported method" exception.
|
|
InputStream getUnicodeStream(String)
|
1.0
|
No
|
This method was deprecated in JDBC 2.0. All drivers throw "unsupported method" exception.
|
|
URL getURL(int)
|
3.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
URL getURL(String)
|
3.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
SQLWarning getWarnings()
|
1.0
|
Yes
|
|
|
void insertRow()
|
2.0 Core
|
Yes
|
|
|
boolean isAfterLast()
|
2.0 Core
|
Yes
|
|
|
boolean isBeforeFirst()
|
2.0 Core
|
Yes
|
|
|
boolean isClosed()
|
4.0
|
Yes
|
|
|
boolean isFirst()
|
2.0 Core
|
Yes
|
|
|
boolean isLast()
|
2.0 Core
|
Yes
|
|
|
boolean isWrapperFor(Class<?> iface)
|
4.0
|
Yes
|
|
|
boolean last()
|
2.0 Core
|
Yes
|
|
|
void moveToCurrentRow()
|
2.0 Core
|
Yes
|
|
|
void moveToInsertRow()
|
2.0 Core
|
Yes
|
|
|
boolean next()
|
1.0
|
Yes
|
|
|
boolean previous()
|
2.0 Core
|
Yes
|
|
|
void refreshRow()
|
2.0 Core
|
Yes
|
|
|
boolean relative(int)
|
2.0 Core
|
Yes
|
|
|
boolean rowDeleted()
|
2.0 Core
|
Yes
|
|
|
boolean rowInserted()
|
2.0 Core
|
Yes
|
|
|
boolean rowUpdated()
|
2.0 Core
|
Yes
|
|
|
void setFetchDirection(int)
|
2.0 Core
|
Yes
|
|
|
void setFetchSize(int)
|
2.0 Core
|
Yes
|
|
|
<T> T unwrap(Class<T> iface)
|
4.0
|
Yes
|
|
|
void updateArray(int, Array)
|
3.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
void updateArray(String, Array)
|
3.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
void updateAsciiStream(int, InputStream, int)
|
2.0 Core
|
Yes
|
|
|
void updateAsciiStream(int, InputStream, long)
|
4.0
|
Yes
|
|
|
void updateAsciiStream(String, InputStream)
|
4.0
|
Yes
|
|
|
void updateAsciiStream(String, InputStream, int)
|
2.0 Core
|
Yes
|
|
|
void updateAsciiStream(String, InputStream, long)
|
4.0
|
Yes
|
|
|
void updateBigDecimal(int, BigDecimal)
|
2.0 Core
|
Yes
|
|
|
void updateBigDecimal(String, BigDecimal)
|
2.0 Core
|
Yes
|
|
|
void updateBinaryStream(int, InputStream)
|
4.0
|
Yes
|
|
|
void updateBinaryStream(int, InputStream, int)
|
2.0 Core
|
Yes
|
|
|
void updateBinaryStream(int, InputStream, long)
|
4.0
|
Yes
|
|
|
void updateBinaryStream(String, InputStream)
|
4.0
|
Yes
|
|
|
void updateBinaryStream(String, InputStream, int)
|
2.0 Core
|
Yes
|
|
|
void updateBinaryStream(String, InputStream, long)
|
4.0
|
Yes
|
|
|
void updateBlob(int, Blob)
|
3.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateBlob(int, InputStream)
|
4.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateBlob(int, InputStream, long)
|
4.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateBlob(String, Blob)
|
3.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateBlob(String, InputStream)
|
4.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateBlob(String, InputStream, long)
|
4.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateBoolean(int, boolean)
|
2.0 Core
|
Yes
|
|
|
void updateBoolean(String, boolean)
|
2.0 Core
|
Yes
|
|
|
void updateByte(int, byte)
|
2.0 Core
|
Yes
|
|
|
void updateByte(String, byte)
|
2.0 Core
|
Yes
|
|
|
void updateBytes(int, byte [])
|
2.0 Core
|
Yes
|
|
|
void updateBytes(String, byte [])
|
2.0 Core
|
Yes
|
|
|
void updateCharacterStream(int, Reader)
|
4.0
|
Yes
|
|
|
void updateCharacterStream(int, Reader, int)
|
2.0 Core
|
Yes
|
|
|
void updateCharacterStream(int, Reader, long)
|
4.0
|
Yes
|
|
|
void updateCharacterStream(String, Reader)
|
4.0
|
Yes
|
|
|
void updateCharacterStream(String, Reader, int)
|
2.0 Core
|
Yes
|
|
|
void updateCharacterStream(String, Reader, long)
|
4.0
|
Yes
|
|
|
void updateClob(int, Clob)
|
3.0
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateClob(int, Reader)
|
4.0
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateClob(int, Reader, long)
|
4.0
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateClob(String, Clob)
|
3.0
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateClob(String, Reader)
|
4.0
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateClob(String, Reader, long)
|
4.0
|
Yes
|
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
|
|
void updateDate(int, Date)
|
2.0 Core
|
Yes
|
|
|
void updateDate(String, Date)
|
2.0 Core
|
Yes
|
|
|
void updateDouble(int, double)
|
2.0 Core
|
Yes
|
|
|
void updateDouble(String, double)
|
2.0 Core
|
Yes
|
|
|
void updateFloat(int, float)
|
2.0 Core
|
Yes
|
|
|
void updateFloat(String, float)
|
2.0 Core
|
Yes
|
|
|
void updateInt(int, int)
|
2.0 Core
|
Yes
|
|
|
void updateInt(String, int)
|
2.0 Core
|
Yes
|
|
|
void updateLong(int, long)
|
2.0 Core
|
Yes
|
|
|
void updateLong(String, long)
|
2.0 Core
|
Yes
|
|
|
void updateNCharacterStream(int, Reader)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNCharacterStream(int, Reader, long)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNCharacterStream(String, Reader)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNCharacterStream(String, Reader, long)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNClob(int, NClob)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNClob(int, Reader)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNClob(int, Reader, long)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNClob(String, NClob)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNClob(String, Reader)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNClob(String, Reader, long)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNString(int, String)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNString(String, String)
|
4.0
|
Yes
|
For the Autonomous REST Connector and the drivers for Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
|
|
void updateNull(int)
|
2.0 Core
|
Yes
|
|
|
void updateNull(String)
|
2.0 Core
|
Yes
|
|
|
void updateObject(int, Object)
|
2.0 Core
|
Yes
|
|
|
void updateObject(int, Object, int)
|
2.0 Core
|
Yes
|
|
|
void updateObject(String, Object)
|
2.0 Core
|
Yes
|
|
|
void updateObject(String, Object, int)
|
2.0 Core
|
Yes
|
|
|
void updateRef(int, Ref)
|
3.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
void updateRef(String, Ref)
|
3.0
|
No
|
All drivers throw "unsupported method" exception.
|
|
void updateRow()
|
2.0 Core
|
Yes
|
|
|
void updateShort(int, short)
|
2.0 Core
|
Yes
|
|
|
void updateShort(String, short)
|
2.0 Core
|
Yes
|
|
|
void updateSQLXML(int, SQLXML)
|
4.0
|
Yes
|
|
|
void updateSQLXML(String, SQLXML)
|
4.0
|
Yes
|
|
|
void updateString(int, String)
|
2.0 Core
|
Yes
|
|
|
void updateString(String, String)
|
2.0 Core
|
Yes
|
|
|
void updateTime(int, Time)
|
2.0 Core
|
Yes
|
|
|
void updateTime(String, Time)
|
2.0 Core
|
Yes
|
|
|
void updateTimestamp(int, Timestamp)
|
2.0 Core
|
Yes
|
|
|
void updateTimestamp(String, Timestamp)
|
2.0 Core
|
Yes
|
|
|
boolean wasNull()
|
1.0
|
Yes
|
|