SQL Oracle Java JSP JDBC MORE

Type 2 (Native-API driver) JDBC Driver with Example


It is very similar to type-1 Driver but a small difference between them.But here the ODBC driver replaced with Native-API driver.

Functionality:

Here the type 2 driver used to convert Java application call for Native-API call and database directly understand the call of Native-API Driver call.

Advantages:

  1. For type 1 Driver 2 conversion required but for type 1 conversion required.
  2. No need of ODBC Driver.
  3. Type 2 Driver work with windows, linux and any other system.
  4. Faster that type 1 driver.

Disadvantages:

  1. Type 2 driver is database dependent driver.If you have change your database to oracle to sql you have to change the driver.