Patch Notes for
Version  2.6.2

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

JR 21196/

CR 61712

 

 

 

 

 

 

JR 21320/

CR 45017

 

 

 

JR 21339/

CR 61625

 

 

 

JR 21317/

CR 44568

 

JR 21272/

CR 66453

JDBC memory leak with CloseDBConnections=true

 

 

 

 

Copy Attributes doesn’t propagate values to child BO.

 

 

 

 

 

The JDBC Connector agent when traversing, does not return the accurate error.

 

 

 

Date processing with Stored procedure causes a null pointer exception.

 

The table xworlds_batch_events,  created using archive_table_oracle.sql script is not used

The fix involved checking for closeDBConnection=true, and if false only we create the hash table entry of the connections, for use in prepared statement cache.

 

For a child object with an attribute having the following ASI values: PH=true:CA=..[ParentAttrName], although the appropriate value was being copied to the child attribute, the overall operation would fail. This was due to improper handling of the PH ASI attribute. The same has been fixed.

 

 

If a non-required, ownership child was not found on retrival, the connector used to throw an error message The same has been corrected.

 

 

 

 

 

 

The same has been resolved in this release.

 

 

 

 

The table creation of xworlds_batch_events was removed from script archive_table_oracle.sql.

2.6.1

JR 20679

CR 58941

 

 

CR 60212

 

 

 

 

 

 

 

 

 

CR 44732

Timing Stats not printing the method name

 

If a parent object with a key attribute having UID=AUTO in the ASI

and has a child object which has an attribute etrieve to the parent key as foreign key, the child object’s foreign key does not get populated with the new identity column value from the parent. When a CREATE operation is done.

 

JDBC ODA strips ‘_’ from BO attribute names

The method name was being passed to the utility method that traced the message, but was not being included in the trace message. This has been fixed.

 

After the identity value was generated in table in the DB, it was not being retrieved from the DB if the database type was DB2. This has been corrected.

 

 

 

 

 

The ‘_’ character, which was being stripped off earlier as a special character would now be included as part of the BO attribute.

 

 

2.5.1

JR 20440
CR 59609



CR 59112




CR 58660


CR 59817

Execution of afterretrievebycontent stored procedure in a business object.

Adapter fails to open new connection after database went down.



Usage of Stored procedure with OP=RS fails.


Return Dummy BO with OP=RS

The adapter failed to execute the stored procedure associated to AfterRetrieveByContentSP.The same has been resolved.

There was an issue with the cleaning of the connection pool when the database went down. This lead to leak of stale connections. The same has been fixed.

The tracing mechanism had a defect and has been corrected.


The Dummy BO created,when result set is null or empty in a retrieveSP for container, was not being returned .
The same has been resolved.

2.5.0.1IF

CR 35078


CR 43390


CR36188

Adapter should return APPRESPONSE TIMEOUT if the SPBeforePoll Call Fails.

Retrieve of large clob data>30k fails when used with stored procedures for Retrieve.

Connector property RetryCountAndInterval does not work for child BO data

The adapter will now return appresponsetimeout if the stored procedure call before polling fails.
The Retrieve of large clob data using stored procedure is now enabled.

The adapter has been enabled to retry etrieve on child retrieval failures.

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.

 


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

WIN & UNIX

WIN & UNIX

Replace the file

Replace the file

Replace the file

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

%CROSSWORLDS%/ODA/%APP%/%APP%ODA.jar

%CROSSWORLDS%\connectors\%APP%/dependencies/archive_table_oracle.sql

2.6.1

WIN & UNIX

WIN & UNIX

Replace the file

Replace the file

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

%CROSSWORLDS%/ODA/%APP%/%APP%ODA.jar

2.5.1

WIN & UNIX

Replace the file

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

2.4.4

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)

   -

   -

  -

  -

 


11 Nov 2004

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