What is Type_FORWARD_ONLY ResultSet in JDBC?

A ResultSet interface in JDBC represents the tabular data generated by SQL queries. It has a cursor which points to the current row. Initially, this cursor is positioned before the first row.

You can retrieve the column value at the current row using the getter methods getInt(), getString(), getDate() etc…

To move the cursor and to navigate/iterate through the ResultSet the java.sql.ResultSet interface provides various methods such as next(), Previous(), first(), last(), relative(), absolute(), beforeFirst(), afterLast() etc...

Type_FORWARD_ONLY Only ResultSet

In forward only ResultSet you can move the cursor only in forward direction. By default, a ResultSet is of type forward only.