The middle-tier then translates the request to the database. To connect with individual databases, JDBC requires drivers for each database. A good approach for learning JDBC. The type 3 driver is platform-independent as the platform-related differences are taken care of by the middleware. Because it is written entirely in Java, this driver is platform-independent.

Uploader: Dat
Date Added: 10 September 2010
File Size: 7.34 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 82406
Price: Free* [*Free Regsitration Required]

The middle-tier application server converts JDBC calls directly or indirectly into the vendor-specific database protocol. This article has multiple issues.

JDBC driver

It is also certified for use on J2EE servers. Learn how and when to remove these template messages.

Written completely in Javatype 4 drivers are thus platform independent. The distinctive characteristic of type 2 jdbc limiattions are that Type 2 drivers convert JDBC calls into database-specific calls i.

Please help improve this article by adding citations to reliable sources. Better performance than Type 1 since no jdbc to odbc translation limitatlons needed Disadvantage: In such cases, the order in which the drivers are tested is significant because the DriverManager will use the first driver it finds that can successfully connect to the given URL. Paid and Free Tests. Mostly obsolete now 5.


JDBC driver – Wikipedia

Thus, it can be used as System Store instead of the Derby database, to boost the performance of the components relying on it. Below figure can show you the difference. The JDBC type 4 driver, also known as the native-protocol driver is a database driver implementation that converts JDBC calls directly into the vendor-specific database protocol.

This driver converts the JDBC method call into native call of database.

JDBC Driver

This driver is native code and not Java, and is closed source. If the middleware must run on different platforms, a Type 4 driver might be more effective. JDBC allows a developer to write applications that is database independent. Architecture of Type 4 Driver. The middleware provides connectivity to many different databases.

The middle-tier djbc-odbc translates the request to the database.

Driver manager section creates the connection object. Type 2 driver resides on the client along with the JAVA application. They are the slowest of all driver types. By using this site, you agree to the Terms of Use and Privacy Policy. This style of driver converts JDBC calls into a network protocol that sends the converted packets–in a proprietary format–to be used directly by DBMSs, thus allowing a direct call from the client machine to the DBMS server and providing a practical solution for intranet access.


As the database protocol is vendor specific, the JDBC client requires separate drivers, usually vendor supplied, to connect to different types of databases. In order to created the connection object we need to give the URL where the database is located with proper credentials.

The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the operating system. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database.

No need to install anything on the client. This driver was designed to enable Java applets to access DB2 data sources. The ODBC depends on native libraries of the operating system.

In addition, since this driver is a FAT client with natively compiled code. Oracle OCI driver is a type 2 driver.