Fix (APAR):  PQ93077

Status:  Fix

Release:  5.1.1

Operating System:  All

Supersedes Fixes:  

CMVC Defect:  PQ93077

Byte size of APAR:  245723

Date: 2004-11-29

Abstract:  Oracle Thin JDBC Driver might not store LOB values in the database.

Description/symptom of problem:  1) Symptom:


   --------


   


   If you are using an Oracle database for WebSphere Business Process Choreographer and the Thin JDBC driver 


   to access the database you might see an exception like:





   java.lang.IllegalArgumentException: org.apache.wsif.WSIFException: Cannot get Object part 'partName'. No parts are set on the message.


      


   


2) Problem:


   --------


   


   The exception indicates that the part of the WSIF message is null even though it is expected to be not null. If you've set the 


   message part correctly to a values not null the exception is most likely caused by a bug in the Oracle Thin JDBC driver. 


   This bug limits the size of LOB data that can be written to the database via JDBC to some KBytes. If the LOB is greater 


   than this limit the data is not stored in the database but 'null' instead. 





      


3) Solution:


   ---------


   


   Either use the Oracle 9i OCI JDBC driver which does not have the LOB handling error or


   apply this interim fix which introduces a workaround for LOBs greater than some KBytes.








Directions to apply fix:  





NOTE:  YOU MUST FIRST DOWNLOAD THE FIX INSTALLER TOOL IN ORDER TO INSTALL AN FIX.


       The Fix Installer can be downloaded from the following link:


       http://www-3.ibm.com/software/webservers/appserv/support/index.html

Directions to apply fix:  NOTE:  YOU MUST FIRST DOWNLOAD THE UPDATE INSTALLER TOOL IN ORDER TO INSTALL A FIX.
       The Fix Installer can be downloaded from the following link:
       http://www-3.ibm.com/software/webservers/appserv/support/index.html

1) Create temporary "fix" directory to store the jar file:
             UNIX: /tmp/WebSphere/fix
          Windows: c:\temp\WebSphere\fix

2) Copy jar file to the directory

3) Shutdown WebSphere

4) Follow the Fix installation instructions that are packaged with the Fix Installer on how to install the Fix.

5) Restart WebSphere

6) The temp directory may be removed.

Directions to remove fix:  NOTE:  FIXES MUST BE REMOVED IN THE ORDER 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, fix2 removed, and fix3 re-applied.


1) Shutdown WebSphere

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

3) Restart WebSphere

Directions to re-apply fix:  1) Shutdown WebSphere

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

3) Restart WebSphere

Additional Information: