JDBC Reference
Page 19 of 31

java.sql.ResultSet

Table 6-7 JDBC 2.0 ResultSet Methods Supported

Returns

Signature

Implementation Notes

boolean

absolute(int row)


void

afterLast()


void

beforeFirst()


void

beforeFirst()


boolan

first()


Blob

getBlob(int columnIndex)

See java.sql.Blob and java.sql.Clob

Blob

getBlob(String columnName)

Clob

getClob(int columnIndex)

Clob

getClob(String columnName)

int

getConcurrency()

Always returns ResultSet.CONCUR_READ_ONLY. (Updatable ResultSets are not supported.)

int

getFetchDirection()


int

getFetchSize()

Always returns 1.

int

getRow()


boolean

isAfterLast()


boolean

isBeforeFirst


boolean

isFirst()


boolean

isLast()


boolean

last()


boolean

previous()


boolean

relative(int rows)


void

setFetchDirection(int direction)


void

setFetchSize(int rows)

A fetch size of 1 is the only size supported.

NOTE: When working with scrolling insensitive ResultSets when auto-commit mode is turned on, the only positioning method that can close the ResultSet automatically is the next() method. When auto-commit mode is on, his method automatically closes the ResultSet if it is called and there are no more rows. afterLast() does not close the ResultSet, for example.