Configuring a WebSphere datasource using DB2 Universal JDBC Driver (JCC) on WebSphere Application Server Version 4
 Technote (FAQ)
 
Problem
Configuring a WebSphere® Application Server datasource for DB2® Universal JDBC™ Driver (JCC Driver) Type 4 using the administrative console.
 
Solution
On the left panel, expand Resources, and right-click JDBC Providers.

Click New in the pop-up menu to create the new JDBC Provider.

  • On the General tab:
    1. Type in any name, such as DB2 8.1 Type 4 Driver.

    2. Set the Implementation Classname to: com.ibm.db2.jcc.DB2ConnectionPoolDataSource

  • On the Nodes tab:
    1. Select Install New.

    2. Select the node to install the driver to.

    3. Click Specify Driver.

    4. Click Add Driver.

    5. Add ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar

      where ${DB2UNIVERSAL_JDBC_DRIVER_PATH} is the DB2 directory where these files are installed

    6. Click Add Driver.


    7. ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar

    8. Click Add Driver.


    9. ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar

    10. Click Set.

    11. Click Install.

    12. Click OK. The driver is created.

    13. Expand the tree for the newly created JDBC provider.

    14. Right-click Data Source.

    15. Click New to create new datasource and enter any name.

    16. In the Custom Properties for the datasource, click Add to enter each value for the following required parameters:
      1. databaseName - name of DB2 database (for example sample)

      2. driverType - 4 (take the default)

      3. serverName - hostname or IP address of the DB2 Server

      4. portNumber - connection port for the DB2 instance. The default value is 50000. If non-default value was used, the value can be obtained from the services file in the following location:

        Windows® platforms: C:\WINNT\system32\drivers\etc
        UNIX® platforms: /etc

      5. user - the login user for DB2

      6. password - the password for this user

      7. Click OK to complete the configuration.

      8. Select the data source and click Test Connection.
 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 4.0.7
Software edition:
Reference #: 1192692
IBM Group: Software Group
Modified date: Mar 31, 2006