ResultSet
- Last Updated: June 27, 2025
- DataDirect Connectors
- JDBC
- Aha! 6.0
- Amazon Redshift 6.0
- Apache Cassandra 6.0
- Apache Hive 6.0
- Apache Spark SQL 6.0
- Atlassian Jira 6.0
- Autonomous REST Connector 6.0
- Cloudera Impala 5.1
- + 24
| 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 | |
| InputStream getBinaryStream(String) | 1.0 | Yes | |
| Blob getBlob(int) | 2.0 Core | Yes |
Drivers support using with data types that map to the JDBC LONGVARBINARY data type. |
| Blob getBlob(String) | 2.0 Core | Yes |
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 | |
| byte [] getBytes(String) | 1.0 | Yes | |
| 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 |
Drivers support using with data types that map to the JDBC LONGVARBINARY data type. |
| void updateBlob(int, InputStream) | 4.0 | Yes |
Drivers support using with data types that map to the JDBC LONGVARBINARY data type. |
| void updateBlob(int, InputStream, long) | 4.0 | Yes |
Drivers support using with data types that map to the JDBC LONGVARBINARY data type. |
| void updateBlob(String, Blob) | 3.0 | Yes |
Drivers support using with data types that map to the JDBC LONGVARBINARY data type. |
| void updateBlob(String, InputStream) | 4.0 | Yes | All other drivers support using with data types that map to the JDBC LONGVARBINARY data type. |
| void updateBlob(String, InputStream, long) | 4.0 | Yes |
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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP S/4HANA, SharePoint, and TeamCity, 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 GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, 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 Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, 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 |