Interview Questions and Tutorials. This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier. 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. The results are then sent back through the reverse process. Java platform Data access technologies. If the middleware must run on different platforms, a Type 4 driver might be more effective. The first driver that recognizes the URL makes the connection.

Uploader: Nasida
Date Added: 7 September 2018
File Size: 37.29 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 74392
Price: Free* [*Free Regsitration Required]

Number of translation layers is very less i. At client side, a separate driver is needed for each database.

User is limited by the functionality of the underlying ODBC driver. The drivers listed in jdbc. Java platform Data access technologies. Not good for the Web.

Advantages and Disadvantages of Jdbc

By deploying database drivers laced with JDBC technology, it is possible to connect to any database — even in a heterogeneous environment — and access tables, tabular data, flat files and more.

If the middle-tier server can in turn use Type1, Type 2 or Type 4 drivers.

Advantages for using this type of driver include the following: Almost any database for which ODBC driver is installed, can be accessed. Java Database Connectivity JDBC is an implementation of the Java programming language that dictates how databases communicate with each other. Direct-to-database pure Java driver Type I: The use of this driver is discouraged if the alternative of a pure-Java driver is available.


The Sun website at http: 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.

They are the slowest of all driver types. As the database protocol is jbc specific, the JDBC client requires separate drivers, usually vendor supplied, to connect to different types of databases.

Some ODBC native code and in many cases native database client code must be loaded on each client machine that uses this type of driver. Technically, this type of driver is the most efficient user of machine resources, but this advantage is far outweighed by the need to write a different JDBC driver for each DBMS and for each platform.

Type 3 JDBC drivers are client-server pairs which use a database-independent network protocol to bridge the network. Instead, the application program is linked to a driver managerwhich is responsible for asvantages the required ODBC driver at runtime and then initializing the driver with a stored set of attributes:.

JDBC Odbc Bridge Driver

Oracle OCI driver is a type 2 driver. JDBC technology drivers fit into one of four categories. It depends on the number of databases the middleware has been configured to support. Thus the performance is considerably improved.


A Java application using JOB. The JDBC standard means that applications can be written without considering what driver will be used in the final deployment, and gives system or the freedom to change database engines without requiring a change in program logic. Server-based, so no need for JDBC driver code on client machine.

When using JDBC, Java programmers have the ability to request connections to a database, send queries to the database using SQL statements, and receive results for advanced processing. The results are then sent back through the reverse process.

Easysoft JDBC-ODBC Bridge User Guide – Introduction

Please help improve this article if you can. This article may require cleanup to meet Wikipedia’s advantagds standards. Disadvantage With type 4 drivers, the user needs a different driver for each database. Interview Questions and Tutorials. This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier.

About Sun Adapter for Oracle.

Can replace database engine without changing JDBC driver.