* GREY=local LOCAL HTML version of Foils prepared 13 March 1997

Foil 13 Types of JDBC drivers

From Overview of Java Database Connection Basic Information Technology Course CPS616 -- Spring Semester 1997. by Udayan Parvate, Tom Pulikal (Geoffrey C. Fox) *
JDBC drivers fit into one of four categories:
1.The JDBC-ODBC bridge provides JDBC access via mostly ODBC drivers.
2.A native-API partly-Java driver converts JDBC calls into calls to the client API for Oracle, Sybase, Informix, DB2, or other DBMS.
( E.g. WebLogic Oracle driver)
3.A net-protocol all-Java driver translates JDBC 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 its Java clients to many different databases.
4.A native-protocol all-Java driver converts JDBC calls into the network protcol used by DBMSs directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access. (also WebLogic)

Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jul 22 1997