Patch Notes for
Version  2.4.2 of the WBI Adapter

 for JDBC/i2ADW/OracleApps/MCS

(for WebSphere Interchange Server versions 4.x) 

The patch note contains the following sections:

CONNECTOR REVISIONS

UPGRADE INSTRUCTIONS

CONNECTOR REVISIONS

This patch contains the following revisions since the last maintenance release:

Available as of Version

APAR/CR Number

Feature

Description

2.4.2

JR 19645

CR 33394/

CR 33565

Column EVENT_ID is hardcoded when using dynamic query for polling.

 

Problem with setting foreign keys on a parent BO

 

When determining the type of the event_id field, the EVENT_ID column was hardcoded, and caused failure for dynamic queries. This has been fixed.

 

When setting foreign keys on a parent BO, if one of the single cardinality child BOs was missing, the foreign keys for all preceeding single cardinality child BOs, were being overwritten by CxIgnore. This has been fixed to populate the forign keys appropriately.

2.4.1

JR 19459

CR 32620

CR33052

Failure updating a child BO with integer key value, that has leading zero.

 

FAIL is not returned on delete if an integrity constraint existed.

When the retrieved BO and BO to be updated are compared, the string values of all key attributes were being compared, so leading zeros resulted in a failure of the comparison. Now the string value is converted to the appropriate type and then compared, so that the problem is resolved.

 

The status flag was not reset to fail after a retrieve is done before delete. The status has been reset to fail before delete operation.

2.3.6

JR 19369

CR 31301

When retrieving a result set returned by a stored procedure, adapter flags the following error: Attribute RS not found

The output attribute name was being retrieved after the check for attribute name to be RS. Now it has been fixed to be retrieved before the check, so that OP=RS is handled appropriately

2.3.5

JR 19263/
CR 30523/CR 29985/CR30598

1.Fix to handle cxignore on spparams.
2.Output Params from SP were using getString method to get all types to check for null.
3.Error message for deltaupdate on invalid verb was missing.

If one inp param for a SP was cxignore , the adapter was not setting values for the rest. The same has been fixed.
2. GetString method after a SP execution,creates problem in some driver (db2) . So fixed to use the appropriate data type method call.
3. Fixed the error message for deltaupdate on invalid verb.

 

UPGRADE INSTRUCTIONS

1.      If the connector version is 2.2.0 or above, please check the following:

 

  1. Apply the changes prescribed in each table below, beginning with the entries at the bottom of each table and working up to the most recent patch.

Add, replace, or remove the following files and directories as indicated (Note that these are rolled up in the patch you downloaded):  

%APP% is one of:  JDBC, i2ADW,  OracleApps or MCS.

For Connector Version

Platform 

Add / Replace / Remove

File (Starting from %CROSSWORLDS%/$CROSSWORLDS)

2.4.2

WIN & UNIX

Replace the file

%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR

2.4.1

WIN & UNIX

Replace the file

%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR

Configure the following for the patch to work:

Connector 
Version

Platform

Add / Remove

Property/Legal values (Case-Sensitive)

   -

   -

  -

  -

 

10 February 2004

© 2004 IBM Corporation. Proprietary and Confidential. All Rights Reserved.