JDBC Driver Types -
Java has four type of JDBC driver for accessing and managing the relational databases.
1.JDBC-ODBC Bridge Driver – Type 1
2.JDBC-Native API - Type 2
3.JDBC-Net-protocol driver - Type 3
4.pure Java - Type 4
JDBC ODBC Bridge Driver (Type 1) -
JDBC ODBC Bridge Driver is fully platform dependent. This driver is used for learning phase of java. For making the JDBC ODBC connection, there is need to make DSN with the database in microsoft windows. This driver makes a bridge over the java application to DSN and DSN point to the database.
JDBC-Native API / partly Java driver (Type 2) -
This driver used the Native api of other language like c/c++ for making connection with database. This driver is partly written java and C (C++) language.
This is vender specific driver, we need to install software for making connection through this driver. The Oracle Call Interface (OCI) driver is an example
JDBC-Net-protocol driver (Type 3) -
For this driver, need a middle tire server. All the request will for to middle tire server and then this server call the database according to the request.
There is no need to any other software or libraries because this driver is based on the server. This driver is totally written in java and also fully portable.
Pure Java (Type 4) -
Pure Java driver is also fully written in java. Some database provide the libraries for making the connection. This driver is directly communicate with database.
The major benefit of using a type 4 jdbc drivers are that they are completely written in Java to achieve platform independence and eliminate deployment administration issues. It is most suitable for the web.