Fix (APAR):  JR26160

Status:  Fix

Release:  6.0.2.1,6.0.2,6.0.1.5,6.0.1.4,6.0.1.3,6.0.1.2

Operating System:  AIX,HP-UX,Linux,Solaris,Windows

Supersedes Fixes:  

CMVC Defect:  JR26160

Byte size of APAR:  57686

Date: 2007-05-01

Abstract:  If an attribute is set to null within the JDBC business graph isSet on that attribute returns false

Description/symptom of problem:  
 
JR26160 resolves the following problem:

ERROR DESCRIPTION:                                              
If an attribute is set to null (in this case within the JDBC    
adapter business graph), isSet on that attribute returns        
false.                                                          

LOCAL FIX:                                                      
N/A                                                             

PROBLEM SUMMARY

USERS AFFECTED:
WebSphere Process Server 6.0.1.x and
6.0.2.x users using JDBC adapter business
graph.

PROBLEM DESCRIPTION:
If an attribute is set to null within
the JDBC business graph isSet on that
attribute returns false

RECOMMENDATION:
None

A business object graph created by Enterprise Service Discovery
using the JDBC adapter against an Oracle 9i database contains
foreign key references to two child objects. The create
operation of the JDBC inbound interface is required to populate
child object attributes of the appropriate type. Because the
relationship is single cardinality, this is achieved by adding
application specific information to the foreign key attributes
of the parent business object.

However, if the value of the foreign key attribute is null,
the adapter will attempt to retrieve all instances of the child
business object, causing a failure.

In this case, the parent object is a (policy)member, and the
child objects are both addresses.

PROBLEM CONCLUSION:                                             
By applying JR26160 this isSet will not set to null.            

Directions to apply fix:  Before applying the iFix ensure that WebSphere Process Server 6.0.1 is installed on the system.
Also download and follow Update Installer installation instructions.  The Update Installer can be downloaded from the following link:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991

1) Copy the pak file to the directory maintenance in the UpdateInstaller directory

2) Shutdown WebSphere Process Server. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix.

3) Run the UpdateInstaller and follow the prompts.

4) Restart WebSphere

Directions to remove fix:  NOTE:  FIXES MUST BE REMOVED IN THE REVERSE ORDER IN WHICH THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS  ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be removed, fix3 must be removed first, then fix2 may be removed

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix.

2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix.

3) Restart WebSphere

Directions to re-apply fix:  1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix.

2) Run the UpdateInstaller and follow the instructions. The Update Installer can be downloaded from the following link:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991

3) Restart WebSphere Process Server

Additional Information: