What are the types of Resultsets ?

The values are defined in the class java.sql.Connection and are :

1. TYPE_FORWARD_ONLY

Resultset is not scrollable.

Rows within it can be advanced only in the forward direction.

It is insensitive to changes committed by other transactions or other statements in the same transaction.

2. TYPE_SCROLL_INSENSITIVE

Resultset is scrollable in either direction but is insensitive to changes committed by other transactions or other statements in the same transaction.

3. TYPE_SCROLL_SENSITIVE

A resultset is scrollable in either direction and is affected by changes committed by other transactions or statements within the same transaction.