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.6.3 |
JR 21597/ CR 71314 JR 21480/ CR 71139 JR 22459/ CR 71391 JR 22444/ CR 72378 JR 22446/ CR 72988 JR 22154/ CR 67474 JR 22431/ CR 67496 JR 22463/ CR 45825 JR 21014/ CR 61153 CR 66540 JR 22378/ CR 67621 CR 70569 JR 21809/ CR 71729 JR 21999/ CR 72255 JR 22462/ CR 73153 JR 22458/ CR 73466 JR 22447/ CR 73476 |
Extra where clause and is null support. Using blank values in event keys to retrieve bos using is null
clause. Using cxblank in event keys to generate is
null clause in retrieve query while polling. Cursor leak, max cursors exceeding the set limit Using blank values in keys of BO to retrieve using is null clause. When processing output parameters returned from the execution of a
Function in the database, they are not retrieved in the correct order. When executing fetchConnection on
Connection Pool, the method does not exit, if CloseDBConnection=true. JDBC Adapter was not allowing the insertion of data of size > 32k
for input parameters of Stored Procedures There are 2 pause statements in the startup script for Windows RetrieveSP not executed for
Child BOs when UseDefaultsForPolling
set to true. JDBC Adapter logs Error when setting TimingStats
to default JDBC Adapter failed to handle CLOB with length between 4000 and 4096 Remove references to data direct drivers in JDBC start scripts JDBC ODA 2.6.2 does not work with BO Designer of AF 2.4. JDBC Connector does not retrieve rows with empty CLOB columns Retieving N cardinality BOs with Progress DB fails RetrieveSP appears to be called
but is not returning resultset. Support for long int in stored procedures
is missing |
The is null support doesnt
work when we have more than one attribute in extrawhereclause,
using retrieve verbASI. This issue has been
resolved by composing proper query using multiple attributes in verb asi. The poll of an event with some keys as null is not composing the
query with is null. Changes have been made to adapter to provide the value
CxBlank in the key value , so that the adapter
builds the is null clause correctly. The usage of cxblank
in the event object keys is fixed and the adapter now builds the is null phrase properly on poll. The fix involved closing the resultset,
when an empty resultset was returned from a stored
procedure call. When processing an incoming BO, with some keys as null is not
composing the query with is null. Changes have been made to adapter to
provide the value CxBlank in the key value , so that the adapter builds the is null clause
correctly. An incorrect index value was being used to retrieve output parameters
of type String. This has now been fixed. If the maximum number of DB connections was reached, the thread exits
fetchConnection only when a connection is released
and the thread is notified. If CloseDBConnection=false,
notify was being called. But it was not called when CloseDBConnection=true.
This has been fixed. There was no special handling done for input parameters to stored
procedures that were of type CLOB. This has now been fixed. This has been corrected. The extra one has been removed. There was a bug in the SP ASI Retriever that did not parse SP ASI if
the value of that attribute was set to CxBlank,
which happens when UseDefaultsForPolling was set to
true. This is has been corrected. The TimingStats property was missing from
template file. It has now been added. The check for size of CLOB was incorrect. That has been corrected. Required changes are done. The 2.4 framework is not BIDI enabled. The 2.6.2 JDBC ODA has BIDI
enabled features and hence fails on 2.4. Fix made to the ODA to check for the BIDI enablement in the ODK and
make calls appropriately, to ensure backward compatibility. When CLOB was null, a NullPointerException
was thrown. Proper check for null value has been introduced. The ProgressDB throws an exception if a
close is issued on an already closed resultset.
Corrected to ensure close is called only once. The AfterRetrieveSP SPs
were getting called before the output parameters for RetrieveSP
were completely processed. This has been fixed. The DriverSupportForLong property was not
being used when processing parameters of stored procedures. This has been
fixed. |
|
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 |
Execution of afterretrievebycontent stored procedure in a business
object. |
The adapter failed to execute the stored procedure associated to
AfterRetrieveByContentSP.The same has been resolved. |
|
2.5.0.1IF |
CR 35078 |
Adapter should return APPRESPONSE TIMEOUT if the SPBeforePoll Call
Fails. |
The adapter will now return appresponsetimeout if the stored
procedure call before polling fails. |
|
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. |
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
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.3 |
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 %CROSSWORLDS%\/bin/Data/\%APP%/%APP%ConnectorTemplate %CROSSWORLDS%\connectors\%APP%\start_%APP%.bat |
|
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 |
Platform |
Add / Remove |
Property/Legal values (Case-Sensitive) |
|
- |
- |
- |
- |
© 2005 IBM Corporation. Proprietary and Confidential. All Rights Reserved.