JDBC Driver

Necessary step to work with JDBC

  1. Load the JDBC driver.
  2. Get the db connection via driver.
  3. Issue SQL query via connection.
  4. Process the result return by SQL query.
  5. Close all JDBC object and Connection.

JDBC is an API(Collection of Packages) and ituses Driver to interact with databasedriver

What is Driver ?
  • Driver is additional software component require by JDBC to
    interact with database.
  • Driver are Provided by Database vendor and they are Database
  • Driver is a concrete class present in jar file
  • Driver help us to establish database connection, transfer database
    query and result between java program and database.

How to load Driver

There are two ways to load driver :
First way:

import java.sql.DriverManager;
import com.mysql.jdbc.Driver;
Driver ref=new Driver();

Second way:

another way to load driver using Class.Forname, this approach is most common approach to load driver and itautomatically register Driver class.


Types of JDBC Driver:

There are Four types of Driver

  1. Type-1 JDBC ODBC Bridge
  2. Type-2 Native API
  3. Type-3 Network protocol
  4. Type-4 Native Protocol
  • Type-1 and Type-2 require Client side installation so it is less efficient.
  • Type-3 and Type-4 Driver develop using java so it is efficient.
  • Type-3 driver support More database.
  • Type-4 Driver give high performance because it is directly connected with database
Step to Configure Driver:
1. Configure project build path

  • Download MySQL zip file and Extract it
  • Go to eclipse IDE.
  • Right click on project
  • Select build path
  • Choose option “Add External Archive” and Select mysql connector jar file.
What is Jar file ?
  • It is collection of ‘ .class ‘ + other necessary resources(text, XML etc).
  • Jar file help us to transfer the java application from one place to another place.

Leave a Reply