IBM DB2 Introduction to application deployment package, IBM Data Server Driver for Jdbc and Sqlj

4.1 Introduction to application deployment package

The application deployment package, in the context of this book, consists of your application and a DB2 product that is required to access DB2 databases. It is used to facilitate the deployment process of your application with a DB2 product.

DB2 offers various products that can be used to create the application deployment package. Many of these products can be re-distributed with your application. We have already discussed DB2 server products (Chapter 2 on page 29) as well as the DB2 Data Server client and DB2 Data Server Runtime client (Chapter 3 on page 89). In this section, we discuss the IBM Data Server Driver for JDBC and SQLJ, IBM Data Server Driver for ODBC and CLI, and IBM Data Server Driver for ODBC, CLI, and .NET.

4.1.1 IBM Data Server Driver for JDBC and SQLJ

IBM Data Server Driver for JDBC and SQLJ is a single driver that includes JDBC Type 2 and JDBC Type 4 connection as well as SQLJ support.

We should clarify that even though IBM Data Server Driver for JDBC and SQLJ includes both Type 2 and Type 4 connection functionality, we utilize Type 4 connectivity, which is available through downloading db2jcc.jar or db2jcc4.jar as well as sqlj.zip or sqlj4.zip from the DB2 database server, or through the IBM download site mentioned in Table 1-1 on page 6. This minimize the footprint and reduces the size of the application deployment package that has to be transferred through the network.

Two versions of the JDBC drivers are available for the IBM Data Server Driver for JDBC and SQLJ. The db2jcc.jar and sqlj.zip files are JDBC 3.0 compliant, and db2jcc4.jar and sqlj4.zip files are JDBC 4.0 compliant.

Prerequisites

The prerequisites for installing IBM Data Server Driver for JDBC and SQLJ are listed here:

￿Java SDK 1.4.2 or later:

For all DB2 products except IBM Data Server Runtime Client, the installation process automatically installs Java SDK, version 4.

For JDBC 4.0 functions, you have to install Java SDK 6 or later manually.

￿Java native thread support:

Java Virtual Machine (JVM™) must include native thread support if you run Java applications that access DB2 databases.

138DB2 Deployment Guide