ROWSET

JDBC provides ResultSet and RowSet

ROWSET - A Rowset is an object that encapsulates a set of rows from either JDBC resultset or tabular data sources like file or spreadsheet. Rowset support component-based development models like JavaBeans, with a standard set of properties and an event notification mechanism.

What are the different types of Rowset

There are two types of Rowset. They are -

1. Connected - A connected rowset object connects to the database once and remains connected until the application terminates.

2. Disconnected - A disconnected rowset object connects to the database, executes a query to retrieve the data from the database and then closes the connection. A program may change the data in a disconnected rowset while it is disconnected. Modified data can be updated in the database after a disconnected rowset establishes the connection with the database.

Rowset

1. Connected

• JdbcRowSet

2. Disconnected

• CachedRowSet

                     - WebRowSet

Note : RowSet are available in javax.sql package