Copying and Collecting a JDBC File

The iWay Technology Adapter for RDBMS requires JDBC drivers when connecting to certain databases. The appropriate driver can be acquired from a respective website of a vendor or from the installation directory of the DBMS.

To enable these adapters:

  1. Use the following table to determine the JDBC driver files required for your database.
  2. Copy the required JDBC files into the iWay7\lib directory.

    The default location for this directory on Windows is:

    C:\Program Files\iWay7\lib

    On other platforms, use the corresponding location.

    The following table lists the iWay adapters and the required libraries or drivers.

    iWay Adapter for...

    Required Libraries or Drivers

    CACHE

    cachedb.jar,

    This file is typically located in

    C:\CacheSys\DEV\JAVA\lib

    CICS

    None

    DB2 Net Driver

    DB2 App Driver

    JCC Driver

    JDBC driver for DB2 (db2java.zip) for connection to DB2 version 7 and DB2 version 8.

    Installed as part of the DB2 server. The default location on Windows is one of the following:

    C:\SQLLIB\java\db2java.zip
    C:\Program Files\SQLLIB\java\db2java.zip
    For JCC driver (connection to DB2 version 9), two files are needed: db2jcc.jar and db2jcc_license.jar. These are typically located in:
    C:\Program Files\SQLLIB\java\

    IMS

    None

    Informix

    JDBC driver for Informix (ifxjdbc.jar).

    Download the driver from the Informix website.

    For Informix 7:

    ifxjdbc.jar

    For Informix 9:

    ifxjdbc.zip 

    Oracle E-Business Suite

    Oracle JDBC drivers (OJDBC14.jar).

    All calls to Oracle E-Business Suite occur through these drivers. If you do not have the appropriate JDBC driver, Oracle Technology Network (OTN) provides a download site at:

    http://otn.oracle.com/software/tech/java/sqlj_jdbc
    /content.html

    Note: To download the drivers, you require a logon ID.

    If you are using OCI drivers, you must install and configure Oracle Client on the machine with the iWay Adapter for Oracle E-Business Suite.

    To use iWay Concurrent Program request functionality, you must install and configure Oracle Client on the Oracle database that supports Oracle E-Business Suite.

    Oracle

    Oracle JDBC driver (OJDBC14.jar for support with Oracle 9i and higher).

    You can download this driver from the Oracle website:

    http://otn.oracle.com/software/tech/java/sqlj_jdbc
    /content.html

    Note: To download the drivers, you require a logon ID.

    For more information on Oracle JDBC issues, see the Oracle JDBC FAQ:

    http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs
    /jdbc_faq.htm

    SQL Server

    SQL Server 2000 JDBC driver.

    The JDBC driver includes the following three files:

    msbase.jar
    mssqlserver.jar
    msutil.jar

    SQL Server 2005 JDBC driver version 1.1.

    SQL Server 2008 JDBC driver version 2.0.

    You can download the driver free of charge from:

    http://microsoft.com

    Sybase

    JDBC driver for Sybase servers (jConnect for JDBC) (jconn2.jar).

    You can download the driver from the Sybase downloads website:

    http://www.sybase.com/downloads

    Select jConnect for JDBC and review information on the jConnect for JDBC website.

    To extract the JDBC driver, obtain the jConnect.zip that corresponds to your version of Sybase and follow the steps described on the jConnect download page.