jdbc: Type 4 Driver

JDBC TYPE-4 Driver:

What is Type-4 Driver?

Ans:

A JDBC Driver that converts JDBC API calls to Database Native Network calls is known as JDBC-4 DRIVER.

Fig: Type4Driver.JPG

· It contains 3 elements, 2 tier architecture and 3 layers.

Advantages:

· This is purely implemented in java, thus it is light weight (resource consumption (ex: memory, time) is less) and portable.

· No need of DB client software to install in the client machine.

· This is platform independent thus this is the best suitable driver for the web based application.

Disadvantages:

· This type of driver is database dependent.

· This type of driver has to implement the database network protocol so is most likely expected from the database vendor.

· See the below diagram:

Fig: Type4Driver a.JPG

Note: java performance is totally depends upon JRE.

Q: WHEN TO USE Type-4 Driver?

Ans: This type of driver is suitable in the client side running applications such as desktop application access DB , and applet.

· However this can be also used in the middleware server running application but would be choice after the type-2 driver.

Example:

Fig: Type4Driver b.JPG

This type of drivers referred as pure java drivers

jdbc