java.sql(JDBC)

A savepoint is a point within a database transaction to which the transaction can be partially rolled back. JDBC provides the Savepoint interface and the Connection methods setSavepoint() and rollback(Savepoint) for working with savepoints. Unlike rollback(), which normally cancels the entire transaction, rolling back to a savepoint cancels only the operations performed after that savepoint. […]

Disconnected data refers to database data that is retrieved and stored locally so that the application can work with the data without maintaining a continuous connection to the database. In JDBC, CachedRowSet is commonly used to work with disconnected data. A CachedRowSet retrieves records while a database connection is available and stores those records in

JdbcRowSet is a connected RowSet implementation that maintains an active connection to the database. It provides a convenient wrapper around a ResultSet and supports both forward and backward navigation depending on its configuration. Key Features Maintains an active database connection. Supports navigation through rows. Supports updating database records. Provides JavaBeans-style properties and events. Suitable when

FilteredRowSet is a disconnected RowSet implementation used to display only the rows that satisfy a particular filtering condition. It extends WebRowSet and allows filtering without requiring a separate SQL query for every filtering operation. For example, if the RowSet contains all employees, a filter can be used to display only employees from the IT department.

JoinRowSet is a disconnected RowSet implementation that allows multiple RowSet objects to be combined using join conditions. It provides functionality similar to SQL joins while working with RowSet objects. Key Features Combines multiple RowSet objects. Supports join operations. Works without requiring a continuous database connection. Can combine data from different RowSet sources. Useful when related

WebRowSet is a disconnected RowSet implementation that extends the functionality of CachedRowSet. It can represent RowSet data as XML, making it useful for transferring database data between different applications or systems. Key Features Extends CachedRowSet. Supports disconnected operation. Can read and write RowSet data as XML. Useful for data exchange between applications. Can preserve information

CachedRowSet is a disconnected RowSet implementation. It retrieves data from the database, stores the data in memory, and can then be used after the database connection has been closed. Key Features Does not require a continuous database connection. Stores rows in memory. Can be serialized and transferred between applications. Supports scrolling and updating. Can reconnect

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

RowSet is an interface in JDBC that provides a convenient and flexible way to work with tabular database data. It extends the ResultSet interface and supports both connected and disconnected ways of processing database records. Unlike a traditional ResultSet, some RowSet implementations can operate without keeping a continuous connection to the database. RowSet also follows

ResultSetMetaData is a JDBC interface used to retrieve information about the columns returned by a SQL query. It can provide details such as the number of columns, column names, data types, table names, and column display sizes. A ResultSetMetaData object is obtained from a ResultSet using the getMetaData() method. It is useful when the structure