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.4 |
CR 73915 |
Code missing from LR FixPAk code line after merge from LR IF code
line. |
During merge of code from LR Interim Fix Code line to LR fixPak code
line, a small block of code got deleted from JDBC DBManager. This has now
been fixed. |
|
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 67621
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
Remove references to data direct drivers in JDBC start scripts
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.
The data direct driver jars in the ClassPath have been removed from
the start scripts of JDBC and OracleApps. Users should configure the same as needed i.e. add any
dependency jars, as per the user guide. 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.4 |
WIN & UNIX WIN & UNIX |
Replace the file Replace the file 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.3 |
WIN & UNIX WIN & UNIX |
Replace the file Replace the file 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.