What are the types of Resultsets ?

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

1. TYPE_FORWARD_ONLY

specifies that a resultset is not scrollable, that is, rows within it can be advanced only in the forward direction.

2. TYPE_SCROLL_INSENSITIVE

specifies that a 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

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

Note : A TYPE_FORWARD_ONLY resultset is always insensitive.