Types of JDBC Drivers:

Types of JDBC Drivers:

logo

Introduction:


As we know Java alone cannot communicate with the database so it needs the Java Database Connectivity drivers. There are four types of JDBC Drivers, they are as follows;

a) Type 1 [JDBC-ODBC Bridge Driver]:


type 2

JDBC-ODBC Bridge Driver converts the Java calls to ODBC (Open Database Connectivity) calls and ODBC to DB (Database) Specific calls. And in the similar way the, DB (Database) Specific calls are also converted to ODBC calls and JDBC-ODBC Brigde driver converts it to Java calls. In this way JDBC-ODBC Bridge Driver is used to make the communication between the Java Application and Database. From the given figure above you can interpret in your own ways.

Advantages:
.No need to search for drivers in the internet, it is already installed.
.Works with any database.

Disadvantages:
.Works only in windows.
.Slow in communication.

b) Type 2 [Native API Driver]:

type 2

It uses the client-side libraries of the databse. It converts JDBC method calls into native calls of database API. Also in similar way, Native API Driver converts the DB specific calls to the JDBC Specific calls. It is not entirely written in Java.

Advantages:
.Faster than Type 1
.Can be used in all platform but has separate versions.

Disadvantages:
.You have to download it separately.
.Database Dependent.

c) Type 3 [Network Protocol Driver]:

type 3

Network Protocol Driver (NPD) convertes JDBC API method calls to Middleware Application Server (MAS) and Middleware Application Server (MAS) to Database (DB) specific calls. Also, the Middleware Application Server Converts the DB (Database) Specific calls to Network Protocol Driver and Network Protocol Driver to JDBC Specific calls.

Advantages:
.Purely Written in Java
.Works with any database.

Disadvantages:
.Economically not feasible.
.Slower in communication.

d) Type 4 [Native Protocol Driver]:

type 4

It directly interact with database. It does not require any native database library. It is not purely written in Java.

Advantages:
.Faster Connection.
.Works in any platform.

Disadvantages:
.Database Dependent.

**************

Post a Comment

0 Comments