JDBC  «Prev 

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:
  1. Oracle JDBC Driver: A software component that implements the Java Database Connectivity (JDBC) API and allows Java applications to connect to an Oracle database.
  2. Oracle Database: The database management system where your data is stored.
  3. Java Development Kit (JDK): The software development kit that includes the Java Virtual Machine (JVM) and the Java compiler, among other tools.
  4. Java Application: The application that you want to use to connect to the Oracle database.
  5. Connection URL: A string that specifies the location of the Oracle database and the format of the connection.
  6. 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
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
3) JDBC Driver collects and translates the database response, routing it back to the application.