JDBC Drivers for SQL Database Tables

Which components are needed to make a JDBC connection to an Oracle Database

To make a JDBC connection to an Oracle database, you need the following components:

Oracle JDBC Driver: A software component that implements the Java Database Connectivity (JDBC) API and allows Java applications to connect to an Oracle database.
Oracle Database: The database management system where your data is stored.
Java Development Kit (JDK): The software development kit that includes the Java Virtual Machine (JVM) and the Java compiler, among other tools.
Java Application: The application that you want to use to connect to the Oracle database.
Connection URL: A string that specifies the location of the Oracle database and the format of the connection.
Java Database Connectivity (JDBC) API: A Java API that provides a standard interface for accessing databases from Java applications.

Once you have these components, you can use JDBC to establish a connection to the Oracle database and execute SQL statements to retrieve, update, and manipulate data.

To make a JDBC connection to an Oracle database, you need the following components:

DriverManager

DriverManager : this fully implemented class was introduced in the original JDBC 1.0 API. When an application first attempts to connect to a data source by specifying a URL, DriverManager will automatically load any JDBC drivers found within the CLASSPATH (any drivers that are pre-JDBC 4.0 must be explicitly loaded by the application).

Connectivity using JDBC Driver

1) JDBC DriverManager provides the application with a connection to a database via Connection object

2) JDBC Driver translates the call from the application and routes it to the database. — 2) JDBC DriverManager provides the application with a connection to the database via a Connection object.

3) JDBC Driver collects and translates the database response, routing it back to the application.