Table of Contents Previous Next


2 Advanced Server JDBC Connector Overview : 2.1 JDBC Driver Types
2.1 JDBC Driver Types
There are currently four different types of JDBC drivers, each with its own specific implementation, use and limitations. The Advanced Server JDBC Connector is a Type 4 driver.
Type 1 Driver
•
This driver type is the JDBC-ODBC bridge.
•
It is limited to running locally.
•
Must have ODBC installed on computer.
•
Must have ODBC driver for specific database installed on computer.
•
Generally can’t run inside an applet because of Native Method calls.
Type 2 Driver
•
This is the native database library driver.
•
Uses Native Database library on computer to access database.
•
Generally can’t run inside an applet because of Native Method calls.
•
Must have database library installed on client.
Type 3 Driver
•
100% Java Driver, no native methods.
•
Does not require pre-installation on client.
•
Can be downloaded and configured on-the-fly just like any Java class file.
•
Uses a proprietary protocol for talking with a middleware server.
•
Middleware server converts from proprietary calls to DBMS specific calls
Type 4 Driver
•
100% Java Driver, no native methods.
•
Does not require pre-installation on client.
•
Can be downloaded and configured on-the-fly just like any Java class file.
•
Unlike Type III driver, talks directly with the DBMS server.
•
Converts JDBC calls directly to database specific calls.
2 Advanced Server JDBC Connector Overview : 2.1 JDBC Driver Types

Table of Contents Previous Next