Better performance than Type 1 since no jdbc to odbc translation is needed Disadvantage: Usually not thread safe. Unsourced material may be challenged and removed. If the middle-tier server can in turn use Type1, Type 2 or Type 4 drivers. The first driver that recognizes the URL makes the connection. Platform and database dependent code is moved to the server running the ODBC driver, allowing these drivers to run over the internet.

Uploader: Naran
Date Added: 8 May 2010
File Size: 65.11 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 4222
Price: Free* [*Free Regsitration Required]

This adavntages your JDBC application to transmit these requests across the network. This driver is native code and not Java, and is closed source. The middle-tier brdige translates the request to the database. From Wikipedia, the free encyclopedia. The Sun website at http: Disadvantages for using this type of driver include the following: In order to develop and test for JDBC 2 functionality you need to:.

This article may be too technical for most readers to understand.

JDBC Driver Types

Retrieved 27 June This brivge that the driver either does not provide the complete JDBC API but provides enough to drive the native database API or is not written completely in Java thus losing out in cross-platform functionality.

About Sun Adapter for Oracle.


This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier. Not good for the Web. This technology isn’t suitable for a high-transaction environment.

Further, these drivers can be downloaded dynamically. 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.

Advantages and Disadvantages of Jdbc

If the middle-tier server can in turn use Type1, Type 2 or Type 4 drivers. The JDBC standard means that applications can be written without considering what driver will be used in the final deployment, and gives system managers the freedom to change database engines without requiring a change in program logic. This allows a direct call from the client machine to the DBMS server. Almost any database for which ODBC driver is installed, jdbf be accessed.

The driver is implemented in the sun. Paid and Free Tests. Direct-to-database pure Java driver 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.

Usually not thread safe. Best use is for controlled environments, such as an intranet. This is a native-code program that services incoming requests for data and executes code in the Odbf driver. Needs some database-specific code on the middleware server. Other trademarks and registered trademarks appearing on easysoft.


Can replace database engine without changing JDBC driver. The same client-side JDBC driver may be used for multiple databases.

The middle-tier application server converts JDBC calls directly or indirectly into the vendor-specific database protocol. However the type 2 driver provides more functionality and performance than the type 1 driver as it does not have the overhead of the additional ODBC function calls. At the application end, the driver is pure Java and therefore completely portable.

JDBC driver – Wikipedia

Oracle will have oracle native api. There are many opportunities to optimize portability, performance, and scalability. It provides better performance over the type 1 and 2 drivers as it does not have the overhead of conversion of calls into ODBC or database API calls. The middleware provides connectivity to many different databases.