1 | |
2 | JDBC drivers fit into one of four categories: |
3 | 1.The JDBC-ODBC bridge provides JDBC access via mostly ODBC drivers. |
4 | 2.A native-API partly-Java driver converts JDBC calls into calls to the client API for Oracle, Sybase, Informix, DB2, or other DBMS. |
5 | ( E.g. WebLogic Oracle driver) |
6 | 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. |
7 | 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) |