1 of 6

ADVANCED JAVA PROGRAMMING

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

3 of 6

Type-3 Driver or Net Protocol driver

4 of 6

Type-3 Driver or Net Protocol driver

  • It follows 3-tier architecture where JDBC requests are passed through the network to the middle tier server.
  • The middle tier server translates the request to the database specific library and then sends it to the database.
  • The database server executes the request and gives back the result.

5 of 6

Type-3 Driver or Net Protocol driver

Advantages:

  • This driver is server based, so no need for vendor database library to present on the client machine.

Disadvantages:

  • Type-3 drivers require database specific coding to be done in the middle tier.
  • Maintenance of the middle tier becomes costly.

6 of 6

THANK YOU