Additional Java SE Packages

JDBC (Java Database Connectivity) is a Java API used to connect a Java application with an Oracle Database and execute SQL statements. In the non-Maven approach, we manually download the Oracle JDBC driver JAR and include it in the classpath while compiling and running the Java program. Oracle recommends choosing the JDBC driver that matches […]

Oracle Database is a powerful Relational Database Management System (RDBMS) developed by Oracle Corporation.It is widely used to store, organize, retrieve, manipulate, and secure large volumes of structured data.Oracle supports SQL (Structured Query Language) for working with data and PL/SQL (Procedural Language/SQL) for developing database-side programs. Oracle is commonly used in enterprise applications because it

SQLException is a checked exception in JDBC that occurs when a database access or SQL operation fails. It can occur while establishing a connection, executing SQL statements, retrieving results, or managing transactions. JDBC provides different subclasses of SQLException to represent specific types of database errors. Understanding these exceptions helps developers identify the cause of a

Rolling back to a savepoint allows a JDBC transaction to undo only the changes made after a particular savepoint. The Savepoint interface is used to mark a specific point within an active transaction. The Connection.rollback(Savepoint) method rolls the transaction back to that point without canceling the operations performed before the savepoint. This is useful when

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