1 of 6

ADVANCED JAVA PROGRAMMING

JDBC Type-2 Driver

M.JEEVANA SUJITHA

Assistant Professor

​

Department of Computer Science and Engineering

SRKR Engineering College, Bhimavaram, A.P. - 534204

2 of 6

OBJECTIVES

The Objective of this lecture is

  • To learn about Type-2 driver.

3 of 6

Type-2 Driver or Native-API driver

4 of 6

Type-2 Driver or Native-API driver

  • It is also known as Native-API partly java driver.
  • Type-2 driver is similar to type-1 driver except that ODBC driver is replaced with database vendor specific native library.
  • Native libraries are set of functions written in non java.
  • We have to install vendor provided native libraries on the client machine.
  • Type-2 driver converts JDBC calls into vendor specific native library calls.
  • The native library calls can be understandable directly by database.

5 of 6

Type-2 Driver or Native-API driver

Advantages:

  • It provides better performance than Type-1 driver. Because, it required only one level conversion from JDBC to native library calls.
  • No need of ODBC driver. Disadvantages:
  • It is database dependent driver, because it internally uses database native libraries.
  • It is platform dependent driver.
  • We have to install native libraries on client machine.

6 of 6

THANK YOU