IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > JDBC > Deploying the module > Deploying the module for production

Adding external software dependencies on the server

The adapter needs certain files installed on IBM BPM or WebSphere Enterprise Service Bus server to be able to communicate with the database.

You do not need to perform this task if the database is installed on the same computer system as IBM BPM or WebSphere Enterprise Service Bus. The files are already available to the adapter.

An adapter needs the JDBC driver files or native system libraries from the database server to be able to communicate with it.


Procedure

  1. Obtain the JDBC driver-specific files or native libraries for your database software and operating system from your database administrator or from the database software website. The files that you need vary by database server.

    The following table lists the files needed for common database software.

    JDBC driver files for common database software
    Database software Driver JDBC driver files Native System Libraries
    IBM DB2 Universal Database™ for Linux, UNIX, and Windows IBM DB2 Universal (Type 4)

    db2jcc.jar
    db2jcc_license_cu.jar

    None
    IBM DB2 for z/OS IBM DB2 Universal (Type 4)

    db2jcc.jar
    db2jcc_license_cisuz.jar

    None
    IBM DB2 for IBM i IBM Toolbox for Java™ remote driver (Type 4)

    jt400.jar
    db2jcc_license_cisuz.jar

    None
    IBM Toolkit for Java native driver * (Type 2) db2_classes.jar None
    IBM DB2 Universal Database for Linux, UNIX, and Windows IBM DB2 Universal (Type 2) db2java.zip None
    Oracle Thin driver ojdbc6.jar

    In addition, the following additional libraries are required to handle the XML data type in the runtime environment:

    xdb.jar
    xmlparserv2.jar

    None
    Microsoft SQL Server 2005 Microsoft SQL Server 2005 for JDBC sqljdbc.jar None
    Informix IBM Informix JDBC Driver

    ifxjdbc.jar
    ifxjdbcx.jar plus several
    support .jar files For more information see, IBM Informix JDBC Driver Programmer's Guide

    None
    * You can use the IBM Toolkit for Java native driver to connect to the database at adapter run time, but you cannot use it to connect while running the wizard. You must use either the IBM Toolbox for Java remote driver or the IBM DB2 Universal driver during the discovery process. However, you can configure the module to use the native driver at run time. Do this on the Specify the Service Generation and Deployment Properties window.

    The JRE version required by the JDBC driver must be lower than or equal to the JRE version in the runtime environment.

  2. Copy the files to the server.

    • In a testing environment in IBM Integration Designer, copy the files to the ${WAS_INSTALL_ROOT}/runtimes/bi_v7/lib/ext directory.

    • In a production environment, copy the files to the ${WAS_INSTALL_ROOT}/lib/ext directory of IBM BPM or WebSphere Enterprise Service Bus.

Deploying the module for production


Next topic: Installing the RAR file (for modules using stand-alone adapters only)