skip to main content
JDBC support : ResultSet
  

Try DataDirect Drivers Now

ResultSet

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