1 of 6

ADVANCED JAVA PROGRAMMING

JDBC Type-1 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-1 driver.

3 of 6

Type-1 Driver

4 of 6

Type-1 Driver

supplied as a part of JDK.

  • Internally this driver takes the help of ODBC driver to communicate with the database.
  • The Type-1 driver converts all JDBC calls into ODBC calls and sends them to ODBC driver.
  • The ODBC driver converts all ODBC calls into database specific calls.
  • The Type-1 driver acts as bridge between JDBC and ODBC hence the name came into picture.
  • Type-1 driver is also known as JDBC-ODBC bridge driver.
  • It is developed by sun

microsystems and

5 of 6

Type-1 Driver

Advantages:

  • Type-1 driver is very easy to use and maintain.
  • Using Type-1 driver we can access any database.
  • It is available as part of JDK and hence, we are not required to install it separately.

Disadvantages:

  • The performance is very less. Because, first it

converts JDBC calls into ODBC calls and ODBC driver converts ODBC calls into database specific calls.

  • Type-1 driver may not be suitable for large scale applications.

6 of 6

THANK YOU