The patch note contains the following sections:
This patch contains the following revisions since the last maintenance
release:
|
Available as of
Version |
APAR/CR Number |
Feature |
Description |
|
2.2.7 |
JR18786 CR 24755/23361 |
Retrieve fails
with NullPointer Exception Cursor leak
problem with retry operations |
When adding the enhancement for supporting
populating of N cardinality BOs using ResultSets and Output Parameters from Stored Procedures,
the population of N cardinality child BOs from ResultSets that can from a simple query was failing,
because a check for the value if the Stored Procedure Information was not
being made during the processing, resulting in a NullPointer
Exception.
In a RETRY loop, if an
SQLException occurred, the prepared statement was
being closed only after the wait period for the retry interval. Closing the
prepared statement right away will resolve the cursor leak issue.
|
|
2.2.6 |
JR 18597 CR 23346 |
Support creation
of child BOs using values obtained from Resultset and Output Parameters returned from the Stored
Procedure |
When a Stored Procedure returned a ResultSet, each row in the ResultSet
was processed, creating an N-cardinality Child BO. Only the values returned
from the ResultSet were used to populate the
attributes in the child BOs. The new functionality
now allows some attributes of each child BO to be populated using the values
returned by the ResultSet and others through OUTPUT
parameters (OP) returned from the Stored Procedure. The attributes populated
from the output parameters are the same for each of the child BOs.
|
|
2.2.5 |
JR 18461 CR 22705/22534 |
Duplicate eventIds encountered during polling. Unable to start standalone
JDBC Connector on AIX 5.1 with WMQI Broker |
During a Poll call, if processing of an
event FAILS because of processing errors , the
adapter returns from that polling cycle and does not continue processing
events. Sometimes, this results in the event store cache not being cleared,
which will result in an event being processed twice. This problem has been
fixed. The connector now continues poll cycle if there are processing errors.
All other failure scenarios are handled as documented in adapter user guide.
Startup script has been updated to set appropriate load
library paths so that Adapter comes up appropriately on AIX. |
|
2.2.4 |
JR 17988 CR
16571/19953/22108/17810/ 22441 |
Generated appropriate
error when incorrect Application Specific Information is provided. Fix Null Pointer
exception thrown when the property preserveUIDSeq is set to true. Remove new line
from i2ADWODA start script. Convert column
names to uppercase to fix SP for container retrieve. Skip ignore and blank attributes while cloning objects. |
The SQLException was being caught as a general
exception resulting in getting a Database connection lost error. The
SQLException is now being caught and the error is logged correctly. Appropriate action has been taken to correct the Null
Pointer exception. I2ADWODA start script opens up a jar file when
starting. Removed new line character, in remarks statement, which causes the
problem. The column names in asi and the result set meta data
did not match due to case mis match. Added conversion to uppercase in both
places to find the corresponding attributes for the columns. Cloning throws null errors when it tries to set values
for place holder attributes. Added logic to skip the null (cxignore values)
while copying over attributes. |
|
2.2.3 |
JR17922/19955 |
Stored Procedure
support for a retrieve for update operation. Update of
attributes with null values also supported. |
The ability to specify Stored procedure for RetrieveForUpdate
is provided in this version. when an update is sent in , the connector tries to do a
retrieve using the SP specified instead of executing a retrieve query. Changes for supporting
Update of attributes with values null is also done . |
|
2.2.2 |
JR17857 /
18424 |
Update the
events to inprogress In pollfor events |
Some events are getting archived in status 0 ie.
Readyforpoll. Few places where the event status did not change have been
fixed to avoid this problem. |
|
2.2.1 |
15907 |
Unique key
generation feature added for DB2 |
Unique key
generation by the DB2 database itself using the Identity column feature is
now allowed instead of having to use the xworlds_uid table. |
1. If the connector version is 1.6.0 or above, please check the following:
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.2.7 |
WIN & UNIX |
Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR |
|
2.2.6 |
WIN & UNIX |
Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR |
|
2.2.5 |
WIN & UNIX UNIX |
Replace the file Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR %CROSSWORLDS%\connectors\%APP%\start_%APP%.sh |
|
2.2.4 |
WIN & UNIX |
Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR |
|
2.2.3 |
WIN & UNIX |
Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR |
|
2.2.2 |
WIN & UNIX |
Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR |
|
2.2.1 |
WIN & UNIX |
Replace the file |
%CROSSWORLDS%\connectors\%APP%\CW%APP%.JAR |
Configure the following for the patch to work:
|
Connector |
Platform |
Add / Remove |
Property/Legal values (Case-Sensitive) |
|
- |
- |
- |
- |
August 16, 2002 12:32 PM
© 2001 CrossWorlds Software, Inc. Proprietary and Confidential. All Rights Reserved.