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 > Configure the module for deployment

Adding external software dependencies

The external service wizard needs a copy of certain files from the database server to be able to communicate with it. Use the external service wizard to specify the location of the JAR files that contains the JDBC driver and any native system library files that are needed.

Run the external service wizard in IBM Integration Designer to perform this task.

In addition to performing this task when you configure the module, you might also need to deploy files on IBM BPM or WebSphere Enterprise Service Bus.


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. Ensure that the JDBC driver-specific files are compatible with JRE 1.6. The following table lists the JDBC driver 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.

  2. In the Locate the Required Files and Libraries window, specify the location of the JDBC driver-specific files that are required by the project.

    1. In the JDBC driver JAR files field, click Add and select the JDBC driver files. For more information about JDBC drivers for see, Frequently asked questions about JDBC drivers.

    2. If you use a JDBC type 2 driver, click Add in System libraries field to add the native system libraries that are required to access the database server. If you use only JDBC type 4 drivers, leave this field empty.

  3. Click Next. The wizard displays the Select the Processing Direction window.


Results

The wizard has the files it needs to communicate with the database server.


What to do next

Continue working in the external service wizard. The next step is to provide the information that the wizard needs to connect to the database.

Configure the module for deployment


Previous topic: Create the project


Next topic: Setting connection properties for the external service wizard


Related concepts:

Attribute application-specific information


Related tasks:

Adding external software dependencies on the server


Related reference:

Business object attributes

Solutions to common problems