Aravind

• Aug 28th, 2006

 

There will two types of ResultSets,one is UniDirectionalResultset and other is BidirectionalResultset.Where as UniDirectionalResultSet can get data in only one direction and BIdirectional can get the data in both directions.BiDirectional is flexible than unididrectional.

saumendra

• Sep 4th, 2006

 

there is mainly 3 type of result set

1.forword-only

2.scroll-sensitive

3.scroll-Insensitive

Supraja

• Dec 9th, 2006

 

TYPE_FORWARD_ONLY

The result set is nonscrollable; its cursor moves forward only, from top to bottom.

The view of the data in the result set depends on whether the DBMS materializes results incrementally.

TYPE_SCROLL_INSENSITIVE

The result set is scrollable: Its cursor can move forward or backward and can be moved to a particular row or to a row whose position is relative to its current position.

The result set generally does not show changes to the underlying database that are made while it is open. The membership, order, and column values of rows are typically fixed when the result set is created.

TYPE_SCROLL_SENSITIVE

The result set is scrollable; its cursor can move forward or backward and can be moved to a particular row or to a row whose position is relative to its current position.

The result set is sensitive to changes made while it is open. If the underlying column values are modified, the new values are visible, thus providing a dynamic view of the underlying data. The membership and ordering of rows in the result set may be fixed or not, depending on the implementation

Supriya Ahire

• Feb 2nd, 2007

 

Hello All, Types of Resultsets are 1)TYPE_FORWARD_ONLY 2) TYPE_SCROLL_INSENSITIVE 3)TYPE_SCROLL_SENSITIVE DEFAULT Type of resultset is TYPE_FORWARD_ONLY. Regards, Ms.Supriya Ahire