JDBC provides several standard implementations of the RowSet interface. They are mainly divided based on whether they maintain an active database connection or work in a disconnected manner.
RowSet Types
| RowSet Implementation | Type | Main Purpose |
|---|---|---|
JdbcRowSet |
Connected | Works like an enhanced ResultSet while maintaining an active database connection. |
CachedRowSet |
Disconnected | Stores database rows in memory and can work after the database connection is closed. |
WebRowSet |
Disconnected | Extends CachedRowSet and represents row-set data in XML format. |
FilteredRowSet |
Disconnected | Allows rows to be filtered according to a specified condition. |
JoinRowSet |
Disconnected | Combines data from multiple RowSet objects using join conditions. |