06-07-2012, 11:29 AM
Java Data Base Connectivity
Java Data Base Connectivity.ppt (Size: 221 KB / Downloads: 24)
JDBC-ODBC Bridge Driver
A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers.
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.
It is appropriate when automatic installation and downloading of a Java technology application is not important.
Native-API Partly Java Driver
This driver converts JDBC calls into calls on the client API for Oracle, SQLServer, Sybase, Informix, DB2, or other DBMS.
Like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.
Net-Protocol Fully Java Driver
This driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server.
This net server middleware is able to connect all of its Java technology-based clients to many different databases.
The specific protocol used depends on the vendor. If vender changes then application will not work.
Native-Protocol Fully Java Driver
This driver converts JDBC calls into the network protocol used by DBMSs directly.
This allows a direct call from the client to the DBMS server and is a practical solution for Intranet access.
As protocols are proprietary to database vendors, they will be the primary source for this style of driver.
Several database vendors have these in progress.