Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Table of Contents

ResultSet Object

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: May 12, 2026
  • 6 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

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
TitleResults for “How to create a CRG?”Also Available inAlert