Known Problems and Incompatibilities

Known Problems and Incompatibilities

1. IBM Lotus Domino Driver for JDBC 1.5

The IBM Lotus Domino Driver for JDBC is a JDBC 1.0 driver. Consequently, it is not compatible with the SAP XI JDBC Adapter, which is designed to interact with JDBC drivers that implement version 2.0 or higher of the JDBC specification.
The driver is also known to cause various problems during runtime, such as that the SAP WebAS J2EE Engine regularly freezes and any attempt to diagnose the problem by creating a Java thread dump is silently ignored by the Java Virtual Machine.

2. Oracle JDBC OCI & Thin Driver 8.1.x

3. Oracle JDBC OCI & Thin Driver 9.0.x

The driver does not support JDK 1. 4, which is used by the SAP WebAS J2EE runtime. If connecting to Oracle 8i 8.1.7 or higher, use the JDK 1.4 version of the Oracle Database 10g 10.2.x driver instead. Connections to older Oracle database releases are not supported. For details, refer to Oracle MetaLink note # 203849.1.

4. Oracle JDBC OCI & Thin Driver 9.2.x

5. Oracle Database 10g 10.1.x JDBC Driver

The JDK 1.1.x, 1.2 and 1.3 versions (classes111. zip, classes12.zip, classes12.jar) of the driver are not compatible with the SAP XI JDBC Adapter. Use the JDK 1.4 driver (ojdbc14.jar) instead. For details, refer to Oracle MetaLink note # 203849.1.

Invoking Oracle stored procedures from within a JDBC sender channel is not supported as Oracle does not return a ResultSet in response to the query.

6. Oracle Database 10g 10.2.x JDBC Driver

The JDK 1.1.x, 1.2 and 1.3 versions (classes111. zip, classes12.zip, classes12.jar) of the driver are not compatible with the SAP XI JDBC Adapter. Use the JDK 1.4 driver (ojdbc14.jar) instead. For details, refer to Oracle MetaLink note # 203849.1.

Invoking Oracle stored procedures from within a JDBC sender channel is only possible for Oracle DBMS versions >= 10.2.x using so-called table functions:

Example:

---------- pkg1 ----------
CREATE PACKAGE pkg1 AS
TYPE numset_t IS TABLE OF NUMBER;
FUNCTION f1(x NUMBER) RETURN numset_t PIPELINED;
END pkg1;
/

CREATE PACKAGE BODY pkg1 AS
-- FUNCTION f1 returns a collection of elements (1,2,3,... x)
FUNCTION f1(x NUMBER) RETURN numset_t PIPELINED IS
BEGIN
FOR i IN 1..x LOOP
PIPE ROW(i);
END LOOP;
RETURN;
END;
END pkg1;