Fix (APAR):  PQ69364

Status:  Fix

Release:  5.0.0

Operating System:  All

Supersedes Fixes:  

CMVC Defect:  154039

Byte size of APAR:  10578

Date: 2003-04-15

Abstract:  IndexOutOfBounds Exception is parameter list is > 32

Description/symptom of problem:  Incorrect counting in the countParameters method of             
 WSJDBCPreparedStatement causes the IndexOutOfBoundsException    
 to occur when a user tries to set a parameter on a prepared     
 statement where the parameter index is higher than 32.  This    
 is an issue with WebSphere Prepared Statement Caching, and can  
 be worked around by setting the statementCache size for the     
 datasource to 0.

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:  Internal Defect(s) :

154039 - IndexOutOfBoundsException in com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.countParameter