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
|
|