Further, these drivers can be downloaded dynamically. The different types of jdbc drivers are: Views Read Edit View history. As a result, you need some knowledge of the application server’s configuration in order to effectively use this driver type. It would be more accurate

Uploader: Shakabei
Date Added: 3 November 2017
File Size: 35.57 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 97694
Price: Free* [*Free Regsitration Required]

What Are the Types of JDBC Drivers?

Type 2 drivers are useful in thpe1, where a type 3 or type 4 driver is not available yet for your database. They are the slowest of all driver types.

This is the highest performance driver available for the database and is usually provided by the vendor itself. Some distinctive characteristic of type 2 jdbc drivers are shown below.

Fiagram OCI driver is a type 2 driver. Different way for DB Connection. This differs from the jrbc 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier.

Traversing the recordset may take longer, since the data comes through the backend server. Mostly obsolete now 5. This page was last edited on 25 Septemberat The drivers listed in jdbc. It tests the drivers by calling the method Driver.


Types of JDBC Drivers

It would be more accurate Learn how and when to remove these template messages. Also, making use of the middleware provides additional advantages of security and firewall access. Please help improve this article if you can. Type 1 drivers also don’t support the complete Java command set and are limited by the functionality of the ODBC driver.

The vendor-specific driver must be installed on each client machine. Third party vendors implements the java. The same client-side JDBC driver may be used for multiple databases. This technology isn’t suitable for a high-transaction environment. Also, use of this tyoe1 leads to other installation dependencies; for example, ODBC must be installed on the tpe1 having the driver and the database must support an ODBC driver.

Share your valuable comment. An extra layer added may result in a time-bottleneck.

JDBC Driver Types

This driver is very flexible allows access to multiple databases using one driver. In a Type 3 jdbcc, a three-tier approach is used to access databases. The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the underlying operating system the JVM is running upon. This kind of driver is extremely flexible, you don’t need to install special software on the client or server.


The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform. If a driver has been written so that loading it causes an instance to be created and also calls DriverManager. First the DriverManager tries to use each driver in the order it was registered. Like type 4 drivers, the type 3 driver is written entirely in Java. Because of the proprietary nature of their network protocols, database vendors usually supply type 4 drivers.

This provides better performance than the type 1 and type 2 drivers as it does not have the overhead of conversion of calls into ODBC or database API calls. The net protocol can be designed to make the client JDBC driver very small and fast to load. Please help improve this article by adding citations to reliable sources.