Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 12)

Chapter 1 Section 1.1
Introducing the JDBC/ODBC eWay About Java Database Connectivity (JDBC)
JDBC/ODBC eWay Adapter User’s Guide 12 Sun Microsystems, Inc.
Cons: Not optimized for server operating system, so the driver can't take advantage of
operating system features. (The driver is optimized for the database and can take
advantage of the database vendor's functionality.) User needs a different driver for each
different database.
A native-protocol fully Java technology-enabled driver converts JDBC technology calls
into the network protocol used by DBMSs directly. This allows a direct call from the
client machine to the DBMS server.
Figure 4 Typical Type 4 Driver Configuration
The pros and cons for using this type of driver are as follows:
Pros
ƒ Allows access to almost any database since the databases ODBC drivers are readily
available
ƒ Offers significantly better performance than the JDBC/ODBC Bridge and Type 2
Drivers
ƒ Scalable
ƒ Caching
ƒ Advanced system administration
ƒ Superior performance
ƒ Advance Java feature set
ƒ Does not require applicable database client libraries
Cons
ƒ Each database will require a driver