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:
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. |
iWay Software |