skip to main content
JDBC Support : Supported Functionality : ResultSet Object
 

ResultSet Object

 
ResultSet Method 
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
No
Throws “unsupported method” exception.
Array getArray (String)
2.0 Core
No
Throws “unsupported method” exception.
InputStream getAsciiStream (int)
1.0
Yes
For the implementation of getAsciiStream (), the JDBC Client assumes that the underlying data in the database only contains 7-bit ASCII characters (represented in an ASCII or EBCDIC code-page). If the assumption is true, the JDBC Client returns bytes corresponding to ASCII characters, otherwise the results are unpredictable. In the case that getAsciiStream () is called on a binary column, the driver converts the binary data to the hexadecimal representation and returns the ASCII representation. For example, the binary value 20 is represented in hexidecimal as 14 or "1" "4". In ASCII, 1 is represented by "49" and 4 is represented by "52". This implies that the ASCII stream "4952" is returned.
InputStream getAsciiStream (String)
1.0
Yes
For the implementation of getAsciiStream (), the JDBC Client assumes that the underlying data in the database only contains 7-bit ASCII characters (represented in an ASCII or EBCDIC code-page). If the assumption is true, the JDBC Client returns bytes corresponding to ASCII characters, otherwise the results are unpredictable. In the case that getAsciiStream () is called on a binary column, the JDBC Client converts the binary data to the hexidecimal representation and returns the ASCII representation. For example, the binary value 20 is represented in hexidecimal as 14 or "1" "4". In ASCII, 1 is represented by "49" and 4 is represented by "52". This implies that the ASCII stream "4952" is returned.
BigDecimal getBigDecimal (int)
2.0 Core
Yes
BigDecimal getBigDecimal (String)
2.0 Core
Yes
BigDecimal getBigDecimal (int, int)
1.0
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
Blob getBlob (String)
2.0 Core
Yes
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
Clob getClob (String)
2.0 Core
Yes
int getConcurrency ()
2.0 Core
Yes
String getCursorName ()
1.0
No
Throws “unsupported method” exception.
Date getDate (int)
1.0
Yes
Date getDate (String)
1.0
Yes
Date getDate (int, Calendar)
2.0 Core
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
OpenAccess SDK supports this method, but will ignore this hint provided by the application.
int getFetchSize ()
2.0 Core
Yes
OpenAccess SDK supports this method, but will ignore this hint provided by the application.
float getFloat (int)
1.0
Yes
float getFloat (String)
1.0
Yes
int getHoldability()
4.0
No
 
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
Object getObject (String)
1.0
Yes
Object getObject (int, Map)
2.0 Core
Yes
Map ignored.
Object getObject (String, Map)
2.0 Core
Yes
Map ignored.
Ref getRef (int)
2.0 Core
No
Throws “unsupported method” exception.
Ref getRef (String)
2.0 Core
No
Throws “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
No
 
SQLXML getSQLXML(String)
4.0
No
 
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 (String)
1.0
Yes
Time getTime (int, Calendar)
2.0 Core
Yes
Time getTime (String, Calendar)
2.0 Core
Yes
Timestamp getTimestamp (int)
1.0
Yes
Timestamp getTimestamp (String)
1.0
Yes
Timestamp getTimestamp (int, Calendar)
2.0 Core
Yes
Timestamp getTimestamp (String, Calendar)
2.0 Core
Yes
int getType ()
2.0 Core
Yes
InputStream getUnicodeStream (int)
1.0
Yes
InputStream getUnicodeStream (String)
1.0
Yes
This method was deprecated in the JDBC 2.0 specification.
URL getURL (int)
3.0
No
Throws “unsupported method” exception.
URL getURL (String)
3.0
No
Throws “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 last ()
2.0 Core
Yes
boolean isWrapperFor(Class<?> iface)
4.0
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
Throws “unsupported method” exception.
void updateArray (String, Array)
3.0
No
Throws “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
void updateBlob(int, InputStream)
4.0
Yes
 
void updateBlob (String, Blob)
3.0
Yes
void updateBlob(int, InputStream, long)
4.0
Yes
 
void updateBlob(String, InputStream)
4.0
Yes
 
void updateBlob(String, InputStream, long)
4.0
Yes
 
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
No
void updateClob(int, Reader)
4.0
Yes
 
void updateClob(int, Reader, long)
4.0
Yes
 
void updateClob (String, Clob)
3.0
No
void updateClob(String, Reader)
4.0
Yes
 
void updateClob(String, Reader, long)
4.0
Yes
 
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
 
void updateNCharacterStream(int, Reader, long)
4.0
Yes
 
void updateNCharacterStream(String, Reader)
4.0
Yes
 
void updateNCharacterStream(String, Reader, long)
4.0
Yes
 
void updateNClob(int, NClob)
4.0
Yes
 
void updateNClob(int, Reader)
4.0
Yes
 
void updateNClob(int, Reader, long)
4.0
Yes
 
void updateNClob(String, NClob)
4.0
Yes
 
void updateNClob(String, Reader)
4.0
Yes
 
void updateNClob(String, Reader, long)
4.0
Yes
 
void updateNString(int, String)
4.0
Yes
 
void updateNString(String, String)
4.0
Yes
 
void updateNull (int)
2.0 Core
Yes
void updateNull (String)
2.0 Core
Yes
void updateObject (int, Object)
2.0 Core
Yes
void updateObject (String, Object)
2.0 Core
Yes
void updateObject (int, Object, int)
2.0 Core
Yes
void updateObject (String, Object, int)
2.0 Core
Yes
void updateRef (int, Ref)
3.0
No
Throws “unsupported method” exception.
void updateRef (String, Ref)
3.0
No
Throws “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