Font size:

java.sql.ResultSet

Table 16. JDBC 2.0 ResultSet Methods Supported

Returns	Signature	Implementation Notes
void	afterLast()
void	beforeFirst()
void	beforeFirst()
boolan	first()
Blob	getBlob(int columnIndex)	See java.sql.Blob and java.sql.Clob
Blob	getBlob(String column-Name)
Clob	getClob(int columnIndex)
Clob	getClob(String column-Name)
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, this method automatically closes the ResultSet if it is called and there are no more rows. afterLast() does not close the ResultSet, for example.