Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Developer's Guide

- Previous: Sun Java System JDBC Driver for Sybase Databases
- Next: JConnect Type 4 Driver for Sybase ASE 12.5 Databases

## IBM DB2 8.1 Type 2 Driver

The JAR files for the DB2 driver are `db2jcc.jar`, `db2jcc_license_cu.jar`, and `db2java.zip`. Set environment variables as follows:

    LD_LIBRARY_PATH=/usr/db2user/sqllib/lib:${j2ee.home}/lib
    DB2DIR=/opt/IBM/db2/V8.1
    DB2INSTANCE=db2user
    INSTHOME=/usr/db2user
    VWSPATH=/usr/db2user/sqllib
    THREADS_FLAG=native

Configure the connection pool using the following settings:

- Name: Use this name when you configure the JDBC resource later.

- Resource Type: Specify the appropriate value.

- Database Vendor: `DB2`

- DataSource Classname: `com.ibm.db2.jcc.DB2SimpleDataSource`

- Properties:

  - `user` - Set as appropriate.

  - `password` - Set as appropriate.

  - `databaseName` - Set as appropriate.

  - `driverType` - Set to `2`.

  - `deferPrepares` - Set to `false`.

- Previous: Sun Java System JDBC Driver for Sybase Databases
- Next: JConnect Type 4 Driver for Sybase ASE 12.5 Databases

- © 2010, Oracle Corporation and/or its affiliates