java.sql.ResultSet methods supported
A ResultSet object is a table of data that represents a database result set, which is usually generated by executing a statement that queries the database.
The following table describes the ResultSet field constants that are supported by the IMS Universal JDBC driver and the IMS Universal JCA/JDBC driver.
| Field constant | IMS Universal JDBC driver and IMS Universal JCA/JDBC driver support |
|---|---|
| ResultSet.CLOSE_CURSORS_AT_COMMIT | Yes1 |
| ResultSet.CONCUR_READ_ONLY | Yes |
| ResultSet.CONCUR_UPDATABLE | Yes |
| ResultSet.FETCH_FORWARD | Yes2 |
| ResultSet.FETCH_REVERSE | Yes2 |
| ResultSet.FETCH_UNKNOWN | Yes2 |
| ResultSet.HOLD_CURSORS_OVER_COMMIT | No 3 |
| ResultSet.TYPE_FORWARD_ONLY | Yes |
| ResultSet.TYPE_SCROLL_INSENSITIVE | Yes |
| ResultSet.TYPE_SCROLL_SENSITIVE | No3 |
Note:
- This is the processing model that is used by IMS DB.
- This is a hint to the JDBC driver. No special processing is performed by IMS DB.
- Not supported by IMS DB.
The following methods are supported by the IMS JDBC drivers for the ResultSet interface.
| JDBC method | IMS Universal JDBC driver and IMS Universal JCA/JDBC driver support |
|---|---|
| absolute(int row) | Yes |
| afterLast() | Yes |
| beforeFirst() | Yes |
| cancelRowUpdates() | Yes |
| clearWarnings() | Yes |
| close() | Yes |
| deleteRow() | Yes |
| findColumn(String columnName) | Yes |
| first() | Yes |
| getArray(int i) | Yes |
| getArray(String colName) | Yes |
| getAsciiStream(int columnIndex) | No |
| getAsciiStream(String columnName) | No |
| getBigDecimal(int columnIndex) | Yes |
| getBigDecimal(int columnIndex, int scale) | Yes |
| getBigDecimal(String columnName) | Yes |
| getBigDecimal(String columnName, int scale) | Yes |
| getBinaryStream(int columnIndex) | No |
| getBinaryStream(String columnName) | No |
| getBlob(int i) | No |
| getBlob(String colName) | No |
| getBoolean(int columnIndex) | Yes |
| getBoolean(String columnName) | Yes |
| getByte(int columnIndex) | Yes |
| getByte(String columnName) | Yes |
| getBytes(int columnIndex) | Yes |
| getBytes(String columnName) | Yes |
| getCharacterStream(int columnIndex) | No |
| getCharacterStream(String columnName) | No |
| getClob(int i) | Yes (for retrieval of XML only) |
| getClob(String colName) | Yes (for retrieval of XML only) |
| getConcurrency() | Yes |
| getCursorName() | No |
| getDate(int columnIndex) | Yes |
| getDate(int columnIndex, Calendar cal) | Yes |
| getDate(String columnName) | Yes |
| getDate(String columnName, Calendar cal) | Yes |
| getDouble(int columnIndex) | Yes |
| getDouble(String columnName) | Yes |
| getFetchDirection() | Yes |
| getFetchSize() | Yes |
| getFloat(int columnIndex) | Yes |
| getFloat(String columnName) | Yes |
| getInt(int columnIndex) | Yes |
| getInt(String columnName) | Yes |
| getLong(int columnIndex) | Yes |
| getLong(String columnName) | Yes |
| getMetaData() | Yes |
| getObject(int columnIndex) | Yes |
| getObject(String columnName) | Yes |
| getObject(int i, Map<String,Class<?>> map) | No |
| getRef(int i) | No |
| getRef(String colName) | No |
| getRow() | Yes |
| getShort(int columnIndex) | Yes |
| getShort(String columnName) | Yes |
| getStatement() | Yes |
| getString(int columnIndex) | Yes |
| getString(String columnName) | Yes |
| getTime(int columnIndex) | Yes |
| getTime(String columnName) | Yes |
| getTime(String columnName, Calendar cal) | Yes |
| getTime(int columnIndex, Calendar cal) | Yes |
| getTimestamp(int columnIndex) | Yes |
| getTimestamp(int columnIndex, Calendar cal) | Yes |
| getTimestamp(String columnName) | Yes |
| getTimestamp(String columnName, Calendar cal) | Yes |
| getType() | Yes |
| getUnicodeStream(int columnIndex) | No |
| getUnicodeStream(String columnName) | No |
| getURL(int columnIndex) | No |
| getURL(String columnName) | No |
| getWarnings() | Yes |
| insertRow() | No |
| isAfterLast() | Yes |
| isBeforeFirst() | Yes |
| isFirst() | Yes |
| isLast() | Yes |
| last() | Yes |
| moveToCurrentRow() | No |
| moveToInsertRow() | No |
| next() | Yes |
| previous() | Yes |
| refreshRow() | No |
| relative(int rows) | Yes |
| rowDeleted() | No |
| rowInserted() | No |
| rowUpdated() | No |
| setFetchDirection(int direction) | Yes |
| setFetchSize(int rows) | Yes |
| updateArray(int columnIndex, Array x) | Yes |
| updateArray(String columnName, Array x) | Yes |
| updateAsciiStream(int columnIndex, InputStream x, int length) | No |
| updateAsciiStream(String columnName, InputStream x, int length) | No |
| updateBigDecimal(int columnIndex, BigDecimal x) | Yes |
| updateBigDecimal(String columnName, BigDecimal x) | Yes |
| updateBinaryStream(int columnIndex, InputStream x, int length) | No |
| updateBinaryStream(String columnName, InputStream x, int length) | No |
| updateBlob(int columnIndex, Blob x) | No |
| updateBlob(String columnName, Blob x) | No |
| updateBoolean(int columnIndex, boolean x) | Yes |
| updateBoolean(String columnName, boolean x) | Yes |
| updateByte(int columnIndex, byte x) | Yes |
| updateByte(String columnName, byte x) | Yes |
| updateBytes(int columnIndex, byte[] x) | Yes |
| updateBytes(String columnName, byte[] x) | Yes |
| updateCharacterStream(int columnIndex, Reader x, int length) | No |
| updateCharacterStream(String columnName, Reader reader, int length) | No |
| updateClob(int columnIndex, Clob x) | No |
| updateClob(String columnName, Clob x) | No |
| updateDate(int columnIndex, Date x) | Yes |
| updateDate(String columnName, Date x) | Yes |
| updateDouble(int columnIndex, double x) | Yes |
| updateDouble(String columnName, double x) | Yes |
| updateFloat(int columnIndex, float x) | Yes |
| updateFloat(String columnName, float x) | Yes |
| updateInt(int columnIndex, int x) | Yes |
| updateInt(String columnName, int x) | Yes |
| updateLong(int columnIndex, long x) | Yes |
| updateLong(String columnName, long x) | Yes |
| updateNull(String columnName) | No |
| updateObject(int columnIndex, Object x) | Yes |
| updateObject(int columnIndex, Object x, int scale) | No |
| updateObject(String columnName, Object x) | Yes |
| updateObject(String columnName, Object x, int scale) | No |
| updateRef(int columnIndex, Ref x) | No |
| updateRef(String columnName, Ref x) | No |
| updateRow() | Yes |
| updateShort(int columnIndex, short x) | Yes |
| updateShort(String columnName, short x) | Yes |
| updateString(int columnIndex, String x) | Yes |
| updateString(String columnName, String x) | Yes |
| updateTime(int columnIndex, Time x) | Yes |
| updateTime(String columnName, Time x) | Yes |
| updateTimestamp(int columnIndex, Timestamp x) | Yes |
| updateTimestamp(String columnName, Timestamp x) | Yes |
| wasNull() | Yes |