Databases Reference
In-Depth Information
MSDASQL allows clients utilizing OLE DB to access third party (non-Microsoft
SQL server) data sources using ODBC driver but does not guarantee full
functionality of OLE DB driver.
JDBC driver
Java is one of the most popular choices for application solutions. Write once, run
everywhere is the theme of JAVA, which reduces development time and has
made this technology an ideal choice for many.
The data source access is achieved through the JDBC programming interface in
Java. JDBC driver specification defines four types of driver architectures:
Ty p e 1
Drivers that implement the JDBC API as a mapping to another data access
API, such as Open Database Connectivity (ODBC). Drivers of this type are
generally dependent on a native library, which limits their portability. DB2
does not provide type 1 driver.
Ty p e 2
Drivers that are written partly in the Java programming language and partly in
native code. The drivers use a native client library specific to the data source
to which they connect. Because of the native code, their portability is limited.
Ty p e 3
Drivers that use a pure Java client and communicate with a server using a
database-independent protocol. The server then communicates the client's
requests to the data source. DB2 no longer includes a type 3 driver.
Ty p e 4
Drivers that are pure Java and implement the network protocol for a specific
data source. The client connects directly to the data source.
DB2 V8 provides type 2 (APP driver and JCC type 2), type 3 (NET driver), and
type 4 (JCC type 4) drivers with APP and NET drivers being deprecated from V8
GA but still shipped (for V8).
DB2 9 provides type 2 (APP driver and JCC type 2) and type 4 (JCC type 4)
drivers. The JDBC type 3 driver (NET) has been discontinued and is not shipped
with V9. The DB2 JDBC type 2 (APP) driver was deprecated in DB2 V8 and will
remain deprecated in V9. Support for DB2 JDBC type 2 (APP) will be removed in
a future release.
Note that there have been no functional enhancements on deprecated DB2
JDBC type 2 (APP) and DB2 JDBC type 3 (NET) drivers since DB2 V7.
Search WWH ::
Custom Search