Jump to content

JDBC driver: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
Undid revision 741624440 by 2405:204:630B:A2B7:5846:2F5D:651C:FF66 (talk)redundant
MacTed (talk | contribs)
374 edits
some language and markup improvements, added cite
Line 23: Line 23:
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. Also, use of this driver leads to other installation dependencies; for example, ODBC must be installed on the computer having the driver and the database must support an ODBC driver. The use of this driver is discouraged if the alternative of a pure-Java driver is available. The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform. This technology isn't suitable for a high-transaction environment. Type 1 drivers also don't support the complete Java command set and are limited by the functionality of the ODBC driver.
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. Also, use of this driver leads to other installation dependencies; for example, ODBC must be installed on the computer having the driver and the database must support an ODBC driver. The use of this driver is discouraged if the alternative of a pure-Java driver is available. The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform. This technology isn't suitable for a high-transaction environment. Type 1 drivers also don't support the complete Java command set and are limited by the functionality of the ODBC driver.


Sun provided a JDBC-ODBC Bridge driver: sun.jdbc.odbc.JdbcOdbcDriver. This driver is native code and not Java, and is closed source. Oracle's JDBC-ODBC Bridge was removed in Java 8 (other vendors' are available).<ref>{{cite web|last1=Oracle|title=JDBC-ODBC Bridge|url=https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html|website=https://docs.oracle.com/|accessdate=27 June 2015}}</ref><ref>https://www.progress.com/connectors/sequelink</ref><ref>http://www.easysoft.com/blog/java-8.html</ref>
Sun (now Oracle) provided a JDBC-ODBC Bridge driver: <code>sun.jdbc.odbc.JdbcOdbcDriver</code>. This driver is native code and not Java, and is closed source. Sun's/Oracle's JDBC-ODBC Bridge was removed in Java 8 (other vendors' are available).<ref>{{cite web|last1=Oracle|title=JDBC-ODBC Bridge|url=https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html|website=https://docs.oracle.com/|accessdate=27 June 2015}}</ref><ref>{{cite news |url=https://www.openlinksw.com/weblogs/uda/?id=1840 |title= Life after sun.jdbc.odbc.JdbcOdbcDriver |work=Universal Data Access Technology Blog |publisher=OpenLink Software |date=2015-06-04 |accessdate=2016-11-18 |quote=JDBC-to-ODBC Bridge, in both Type 1 and Type 3 forms, has been available and regularly updated since its original release for JDBC 1.}}</ref><ref>https://www.progress.com/connectors/sequelink</ref><ref>http://www.easysoft.com/blog/java-8.html</ref>


If a driver has been written so that loading it causes an instance to be created and also calls DriverManager.registerDriver with that instance as the parameter (as it should do), then it is in the DriverManager's list of drivers and available for creating a connection.
If a driver has been written so that loading it causes an instance to be created and also calls <code>DriverManager.registerDriver</code> with that instance as the parameter (as it should do), then it is in the DriverManager's list of drivers and available for creating a connection.


It may sometimes be the case that more than one JDBC driver is capable of connecting to a given URL. For example, when connecting to a given remote database, it might be possible to use a JDBC-ODBC bridge driver, a JDBC-to-generic-network-protocol driver, or a driver supplied by the database vendor. 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.
It may sometimes be the case that more than one JDBC driver is capable of connecting to a given URL. For example, when connecting to a given remote database, it might be possible to use a JDBC-ODBC bridge driver, a JDBC-to-generic-network-protocol driver, or a driver supplied by the database vendor. 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.
Line 31: Line 31:
First the DriverManager tries to use each driver in the order it was registered. (The drivers listed in jdbc.drivers are always registered first.) 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.
First the DriverManager tries to use each driver in the order it was registered. (The drivers listed in jdbc.drivers are always registered first.) 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 tests the drivers by calling the method Driver.connect on each one in turn, passing them the URL that the user originally passed to the method DriverManager.getConnection. The first driver that recognizes the URL makes the connection.
It tests the drivers by calling the method Driver.connect on each one in turn, passing them the URL that the user originally passed to the method <code>DriverManager.getConnection</code>. The first driver that recognizes the URL makes the connection.


===Advantages===
===Advantages===
Line 37: Line 37:


===Disadvantages===
===Disadvantages===
* Performance overhead since the calls have to go through the JDBC bridge to the ODBC driver, then to the native db connectivity interface (thus may be slower than other types of drivers).
* Performance overhead since the calls have to go through the JDBC bridge to the ODBC driver, then to the native database connectivity interface (thus may be slower than other types of drivers).
* The ODBC driver needs to be installed on the client machine.
* The ODBC driver needs to be installed on the client machine.
* Not suitable for [[Java applet|applet]]s, because the ODBC driver needs to be installed on the client.
* Not suitable for [[Java applet|applet]]s, because the ODBC driver needs to be installed on the client.
*This driver internally depending on ODBC driver and ODBC driver is available only for windows platforms and hence portability of this driver is much less.(platform dependent driver).
* Specific ODBC drivers are not always available on all platforms; hence, portability of this driver is limited.
* No support from JDK 1.8v onwards.
* No support from JDK 1.8 (Java 8) onwards.


==Type 2 driver – Native-API driver==
==Type 2 driver – Native-API driver==
Line 49: Line 49:


===Advantages===
===Advantages===
* As there is no implementation of JDBC-ODBC bridge, its considerably faster than a type 1 driver.
* As there is no implementation of JDBC-ODBC bridge, it may be considerably faster than a Type 1 driver.


===Disadvantages===
===Disadvantages===
Line 60: Line 60:
==Type 3 driver – Network-Protocol driver (middleware driver) ==
==Type 3 driver – Network-Protocol driver (middleware driver) ==
[[Image:Network Protocol driver.png|thumb|right|300px|Schematic of the Network Protocol driver]]
[[Image:Network Protocol driver.png|thumb|right|300px|Schematic of the Network Protocol driver]]
The JDBC type 3 driver, also known as the Pure Java driver for database middleware,<ref>http://docs.oracle.com/cd/E19509-01/820-5069/ggzci/index.html</ref> is a database driver implementation which makes use of a [[middle tier]] between the calling program and the database. The middle-tier ([[application server]]) converts [[JDBC]] calls directly or indirectly into the vendor-specific [[database]] protocol.
The JDBC type 3 driver, also known as the Pure Java driver for database middleware,<ref>http://docs.oracle.com/cd/E19509-01/820-5069/ggzci/index.html</ref> is a database driver implementation which makes use of a [[middle tier]] between the calling program and the database. The middle-tier ([[application server]]) converts [[JDBC]] calls directly or indirectly into a vendor-specific [[database]] protocol.


This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier. Like type 4 drivers, the type 3 driver is written entirely in Java.
This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier. Like type 4 drivers, the type 3 driver is written entirely in Java.


The same driver can be used for multiple databases. It depends on the number of databases the middleware has been configured to support. The type 3 driver is [[platform-independent]] as the platform-related differences are taken care of by the middleware. Also, making use of the middleware provides additional advantages of security and firewall access.
The same client-side JDBC driver may be used for multiple databases. It depends on the number of databases the middleware has been configured to support. The type 3 driver is [[platform-independent]] as the platform-related differences are taken care of by the middleware. Also, making use of the middleware provides additional advantages of security and firewall access.


===Functions===
===Functions===
*Sends JDBC API calls to a middle-tier net server that translates the calls into the DBMS-specific network protocol.The translated calls are then sent to a particular DBMS.
* Sends JDBC API calls to a middle-tier net server that translates the calls into the DBMS-specific network protocol.The translated calls are then sent to a particular DBMS.
*Follows a three tier communication approach.
* Follows a three-tier communication approach.
*Can interface to multiple databases – Not vendor specific.
* Can interface to multiple databases – Not vendor specific.
*The JDBC Client driver written in java, communicates with a middleware-net-server using a database independent protocol, and then this net server translates this request into database commands for that database.
* The JDBC Client driver written in java, communicates with a middleware-net-server using a database independent protocol, and then this net server translates this request into database commands for that database.
*Thus the client driver to middleware communication is database independent.
* Thus the client driver to middleware communication is database independent.


===Advantages===
===Advantages===
Line 97: Line 97:
* The client application connects directly to the database server. No translation or [[middleware]] layers are used, improving performance.
* The client application connects directly to the database server. No translation or [[middleware]] layers are used, improving performance.
* The JVM can manage all aspects of the application-to-database connection; this can facilitate debugging.
* The JVM can manage all aspects of the application-to-database connection; this can facilitate debugging.
*


===Disadvantages===
===Disadvantages===
* Drivers are database dependent, as different database vendors use widely different (and usually proprietary) network protocols.
* Drivers are database specific, as different database vendors use widely different (and usually proprietary) network protocols.


==List of JDBC drivers==
==List of JDBC drivers==

Revision as of 16:01, 18 November 2016

A JDBC driver is a software component enabling a Java application to interact with a database.[1] JDBC drivers are analogous to ODBC drivers, ADO.NET data providers, and OLE DB providers.

To connect with individual databases, JDBC (the Java Database Connectivity API) requires drivers for each database. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database.

JDBC technology drivers fit into one of four categories.[2]

  1. JDBC-ODBC bridge
  2. Native-API driver
  3. Network-Protocol driver (Middleware driver)
  4. Database-Protocol driver (Pure Java driver) or thin driver.

Type 1 driver – JDBC-ODBC bridge

Schematic of the JDBC-ODBC bridge

The JDBC type 1 driver, also known as the JDBC-ODBC bridge, is a database driver implementation that employs the ODBC driver to connect to the database. The driver converts JDBC method calls into ODBC function calls.

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. Also, use of this driver leads to other installation dependencies; for example, ODBC must be installed on the computer having the driver and the database must support an ODBC driver. The use of this driver is discouraged if the alternative of a pure-Java driver is available. The other implication is that any application using a type 1 driver is non-portable given the binding between the driver and platform. This technology isn't suitable for a high-transaction environment. Type 1 drivers also don't support the complete Java command set and are limited by the functionality of the ODBC driver.

Sun (now Oracle) provided a JDBC-ODBC Bridge driver: sun.jdbc.odbc.JdbcOdbcDriver. This driver is native code and not Java, and is closed source. Sun's/Oracle's JDBC-ODBC Bridge was removed in Java 8 (other vendors' are available).[3][4][5][6]

If a driver has been written so that loading it causes an instance to be created and also calls DriverManager.registerDriver with that instance as the parameter (as it should do), then it is in the DriverManager's list of drivers and available for creating a connection.

It may sometimes be the case that more than one JDBC driver is capable of connecting to a given URL. For example, when connecting to a given remote database, it might be possible to use a JDBC-ODBC bridge driver, a JDBC-to-generic-network-protocol driver, or a driver supplied by the database vendor. 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.

First the DriverManager tries to use each driver in the order it was registered. (The drivers listed in jdbc.drivers are always registered first.) 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 tests the drivers by calling the method Driver.connect on each one in turn, passing them the URL that the user originally passed to the method DriverManager.getConnection. The first driver that recognizes the URL makes the connection.

Advantages

  • Almost any database for which an ODBC driver is installed can be accessed, and data can be retrieved.

Disadvantages

  • Performance overhead since the calls have to go through the JDBC bridge to the ODBC driver, then to the native database connectivity interface (thus may be slower than other types of drivers).
  • The ODBC driver needs to be installed on the client machine.
  • Not suitable for applets, because the ODBC driver needs to be installed on the client.
  • Specific ODBC drivers are not always available on all platforms; hence, portability of this driver is limited.
  • No support from JDK 1.8 (Java 8) onwards.

Type 2 driver – Native-API driver

Schematic of the Native API driver

The JDBC type 2 driver, also known as the Native-API driver, is a database driver implementation that uses the client-side libraries of the database. The driver converts JDBC method calls into native calls of the database API. For example: Oracle OCI driver is a type 2 driver.

Advantages

  • As there is no implementation of JDBC-ODBC bridge, it may be considerably faster than a Type 1 driver.

Disadvantages

  • The vendor client library needs to be installed on the client machine.
  • Not all databases have a client side library.
  • This driver is platform dependent.
  • This driver supports all java applications except applets.

Type 3 driver – Network-Protocol driver (middleware driver)

Schematic of the Network Protocol driver

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. The middle-tier (application server) converts JDBC calls directly or indirectly into a vendor-specific database protocol.

This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier. Like type 4 drivers, the type 3 driver is written entirely in Java.

The same client-side JDBC driver may be used for multiple databases. It depends on the number of databases the middleware has been configured to support. The type 3 driver is platform-independent as the platform-related differences are taken care of by the middleware. Also, making use of the middleware provides additional advantages of security and firewall access.

Functions

  • Sends JDBC API calls to a middle-tier net server that translates the calls into the DBMS-specific network protocol.The translated calls are then sent to a particular DBMS.
  • Follows a three-tier communication approach.
  • Can interface to multiple databases – Not vendor specific.
  • The JDBC Client driver written in java, communicates with a middleware-net-server using a database independent protocol, and then this net server translates this request into database commands for that database.
  • Thus the client driver to middleware communication is database independent.

Advantages

  • Since the communication between client and the middleware server is database independent, there is no need for the database vendor library on the client. The client need not be changed for a new database.
  • The middleware server (which can be a full-fledged J2EE Application server) can provide typical middleware services like caching (of connections, query results, etc.), load balancing, logging, and auditing.
  • A single driver can handle any database, provided the middleware supports it.
  • E.g.: IDA Server

Disadvantages

  • Requires database-specific coding to be done in the middle tier.
  • The middleware layer added may result in additional latency, but is typically overcome by using better middleware services.

Type 4 driver – Database-Protocol driver (Pure Java driver)

Schematic of the Native-Protocol driver

The JDBC type 4 driver, also known as the Direct to Database Pure Java Driver, is a database driver implementation that converts JDBC calls directly into a vendor-specific database protocol.

Written completely in Java, type 4 drivers are thus platform independent. They install inside the Java Virtual Machine of the client. 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. Unlike the type 3 drivers, it does not need associated software to work.

As the database protocol is vendor specific, the JDBC client requires separate drivers, usually vendor supplied, to connect to different types of databases. This type includes, for example, the widely used Oracle thin driver.

Advantages

  • Completely implemented in Java to achieve platform independence.
  • These drivers don't translate the requests into an intermediary format (such as ODBC).
  • The client application connects directly to the database server. No translation or middleware layers are used, improving performance.
  • The JVM can manage all aspects of the application-to-database connection; this can facilitate debugging.

Disadvantages

  • Drivers are database specific, as different database vendors use widely different (and usually proprietary) network protocols.

List of JDBC drivers

See also

References

  1. ^ "Java SE Technologies - Database"
  2. ^ Sun JDBC Overview
  3. ^ Oracle. "JDBC-ODBC Bridge". https://docs.oracle.com/. Retrieved 27 June 2015. {{cite web}}: External link in |website= (help)
  4. ^ "Life after sun.jdbc.odbc.JdbcOdbcDriver". Universal Data Access Technology Blog. OpenLink Software. 2015-06-04. Retrieved 2016-11-18. JDBC-to-ODBC Bridge, in both Type 1 and Type 3 forms, has been available and regularly updated since its original release for JDBC 1.
  5. ^ https://www.progress.com/connectors/sequelink
  6. ^ http://www.easysoft.com/blog/java-8.html
  7. ^ http://docs.oracle.com/cd/E19509-01/820-5069/ggzci/index.html
Retrieved from "https://en.wikipedia.org/w/index.php?title=JDBC_driver&oldid=750244432"