PQ76789: INDEXOUTOFBOUNDSEXCEPTION IN COM.IBM.WS.RSADAPTER.JADBC. WDJDBCPREPAREDSTATEMENT.COUNTPARAMETEE

 A fix is available

Obtain the fix for this APAR



APAR status
Closed as program error.

Error description
IndexOutOfBounds exception prevents the re-use of
PreparedStaements when more than 32 parameters are specified and
statement caching is enabled.
This is reflected in distributed APAR 
PQ69364 defect internal
defect 154039.
Local fix
A work around, with a performance penalty, would be to disable
PreparedStatement caching by setting statementCacheSize=0
Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 V5.0 for z/OS                                *
****************************************************************
* PROBLEM DESCRIPTION: An IndexOutOfBoundsException occurs in  *
*                      the countParameters method of           *
*                      WSJDBCPreparedStatement when preparing  *
*                      a statement with more than 32           *
*                      parameters and statement caching is     *
*                      enabled.                                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
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.
Problem conclusion
Modified the code in the countParameters method to appropriately
handle parameters with indexes higher than 32.

APAR PQ76789 is associated with SERVICE LEVEL W500104 of
WebSphere Application Server V5.0 for z/OS.
Temporary fix Comments
APAR information
APAR number PQ76789
Reported component name WEBSPHERE FOR Z
Reported component ID 5655I3500
Reported release 500
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2003-07-25
Closed date 2003-08-30
Last modified date 2003-10-03

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
BBOUBINF          

Publications Referenced

Fix information
Fixed component name WEBSPHERE FOR Z
Fixed component ID 5655I3500

Applicable component levels
R500 PSY UQ79825    UP03/09/10 P F309

  Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.


Document Information


Current web document: swg1PQ76789.html
Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 500
Software edition:
Reference #: PQ76789
IBM Group: Software Group
Modified date: Oct 3, 2003