
Chapter 1 | Section 1.1 |
Introducing the JDBC/ODBC eWay | About Java Database Connectivity (JDBC) |
database and middleware vendors. The various driver types are described in the following sections:
“Type I:
“Type II: Partial Java driver” on page 9
“Pure Java driver for database middleware” on page 10
“Type Four Driver:
Type I: JDBC-ODBC Bridge
This combination provides JDBC access via ODBC drivers. ODBC binary
Type one drivers provide JDBC access via one or more Open Database Connectivity (ODBC) drivers. ODBC, which predates JDBC, is widely used by developers to connect to databases in a
Pros: A good approach for learning JDBC. May be useful for companies that already have ODBC drivers installed on each client machine — typically the case for Windows- based machines running productivity applications. May be the only way to gain access to some
Cons: Not for
Type One Driver
A JDBC/ODBC bridge provides JDBC API access through 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.
Figure 1 Typical Type 1 Driver Configuration
JDBC/ODBC eWay Adapter User’s Guide | 8 | Sun Microsystems, Inc. |