Patch Notes for
Version  2.4.4 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.4

JR 20005/

CR

31759/35455/

35954

When collaboration is down, the error message should be emailed if email collaboration is setup.Currently email is not being sent.

 

 

For the Delete verb, if the parent BO is a Wrapper BO, multiple cardinality children of the Wrapper BO are not deleted.

 

When using Copy Attributes to propogate values down through a hierarchy of Business Objects, such values were not being propagated for N-cardinality child BOs

To enable email to be setup , the error message should be logged with severity. Change has been done to log message with severity if the severity is FATAL. Unsubscribed objects are now logged as errors of FATAL type.

 

Multiple cardinality child BOs of a Wrapper BO are now being deleted when processing the Delete verb.

 

Copy attribute values are now being propagated for N-cardinality child business objects.

2.4.3

UR 19772/

CR 34025/CR 34612

ReturnStatus Descriptor is populated with wrong message.

 

During polling multiple commits to the DB are done to update the status of events in the event and archive tables as soon as possible. This is required because some users filter events in the event table based on status. This could be a performance issue for some users.

The ReturnStatusDescriptor is populated with wrong error message on a retrieve failure. The error says that the Child Object doesnt exist in the database when the actual reason is that the Parent Object doesnot exist in the database.

 

The solution is no make the multiple commits configurable. A new connector specific property SelectiveCommitForPoll has been introduced. If its value is true, then there is only one commit - after an event has been processed. If its value is false then the behaviour is the same as before – commits to the DB will be done at each stage of event processing. The default value for the property is false.

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:

o                                Infrastructure version should be 4.0 or above.

o                                The lib directory under WBI Adapter installation should contain the WBIA.jar

 

  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.4

WIN & UNIX

Replace the file

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

2.4.3

WIN & UNIX

Replace the file

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

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)

   -

   -

  -

  -

 


5 May 2004

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