First the DriverManager tries to use each driver in the order it was registered. This technology isn’t suitable for a high-transaction environment. The JDBC type 3 driver, also known as the Pure Java driver for database middleware, [7] is a database driver implementation which makes use of a middle tier between the calling program and the database. You can think of the application server as a JDBC “proxy,” meaning that it makes calls for the client application. Please help improve it to make it understandable to non-experts , without removing the technical details. This kind of driver is extremely flexible, since it requires no code installed on the client and a single driver can actually provide access to multiple databases. In a Type 4 driver, a pure Java-based driver communicates directly with the vendor’s database through socket connection.

Uploader: Tobar
Date Added: 17 July 2004
File Size: 57.11 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 1295
Price: Free* [*Free Regsitration Required]

Further, these drivers can be downloaded dynamically.

jdbbc The middle-tier then translates the request to the database. Because of the proprietary nature of their network protocols, database vendors usually supply type 4 drivers. The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform.

JDBC Driver Types

Learn how and when to remove these template messages. In a Type 4 driver, a pure Java-based driver communicates directly with the vendor’s database through socket connection. The major benefit of using a type 4 jdbc drivers are that they are completely diaggam in Java to achieve platform independence and eliminate deployment administration issues.


Written completely in Javatype 4 drivers are thus thpe1 independent. Traversing the recordset may take longer, since the data comes through the backend server.

What Are the Types of JDBC Drivers?

The drivers listed in jdbc. They install inside the Java Virtual Machine of the client. If we change the Database, we have to change the native API, as it is specific to a database and they are mostly obsolete now, but you may realize some speed increase with a Type 2 driver, because it eliminates ODBC’s overhead.

In a Type 3 driver, a three-tier approach is used to access databases. If you are accessing one type of database, such as Oracle, Sybase, or IBM, the preferred driver type is 4. It requires another server application to install and maintain. The type 3 driver is platform-independent as the platform-related differences are taken care of hype1 the middleware. This article may require cleanup to meet Wikipedia’s quality standards.

In such cases, the order in which the drivers are tested is significant because the DriverManager will use the first diagraam it finds that can successfully connect to the given URL. March Duagram how and when to remove this template message.

Retrieved 27 June Further, these drivers can be downloaded dynamically. It will skip any drivers that are untrusted code unless they have been loaded from the same source as the code that is trying to open the connection. It is most tyype1 for the web.


JDBC technology drivers fit into one of four categories. Your application server might use a Type 1, idbc, or 4 driver to communicate with the database, understanding the nuances will prove helpful. Some distinctive characteristic of type 2 jdbc drivers are shown below.

JDBC – Driver Types

This driver is server-based, so there is no need for any vendor database library to be present on client machines. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database.

They are the slowest of all driver types. It would be more accurate This driver is fully written in Java and hence Portable. This technology isn’t suitable for a high-transaction environment.

If we change the Database we have to change the native api as it is specific to a database 4. Retrieved from ” https: JDBC driver implementations vary because of the jcbc variety of operating systems and hardware platforms in which Java operates.

An extra layer added may result in a time-bottleneck. Different way for DB Connection.