UNDERSTANDING THE JDBC Driver

UNDERSTANDING THE JDBC Driver:

·         As said the JDBC Driver is responsible to communicate with database server.

·         To do this JDBC Driver follows any of the 4 approaches, based on which we categorize JDBC Driver into the following 4 types:

3.       Type 3 Driver

4.      Type -4 Driver

Type -1 driver

JDBC TYPE -2 Driver

Note:

At present we have 300+ registered JDBC drivers from different vendor accessing different databases. These 300+ are categorized into 4 types.

JDBC is an abstraction, and java application uses this JDBC.

Type	Type-1	Type -2	Type -3	Type -4
Converts to	DB Independent API CALLS	DB Native API calls	DB Independent network call	DB Native Network call
DB Independent	Yes	No	Yes	No
Pure java	No	No	Yes	Yes
Advantages	·         DB independent ·         Early access ·         Allow accessing DB server that does not directly support java/jdbc	·         Speed of operation	·         Better resource management ·         Secure ·         Improves scalability ·         DB Independent ·         Convenient to work with distributed transaction	·         Light weight ·         portable