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

 Fixes are available

5.0.1: WebSphere Application Server Version 5.0 Fix Pack 1 (Version 5.0.1)
PQ69364, 5.0: IndexOutOfBoundsException with prepared statements
5.0.1: WebSphere Application Server Enterprise Edition Version 5.0 Fix Pack 1



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.
Local fix
A work around, with a performance penalty, would be to disable
PreparedStatement caching by setting statementCacheSize=0
Problem summary
****************************************************************
* USERS AFFECTED: Users running WebSphere Application Server   *
*                 5.0 prior to fix pack 1, who are preparing   *
*                 statements with greater than 32 parameters.  *
****************************************************************
* PROBLEM DESCRIPTION: An IndexOutOfBoundsException occurs     *
*                      in countParameters method of            *
*                      WSJDBCPreparedStatement when            *
*                      preparing a statement with more than    *
*                      32 parameters.                          *
****************************************************************
* 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.
Temporary fix Comments
APAR information
APAR number PQ69364
Reported component name WAS BASE 5.0
Reported component ID 5630A3600
Reported release 00S
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2002-12-20
Closed date 2003-01-20
Last modified date 2003-01-20

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

Publications Referenced

Fix information
Fixed component name WAS BASE 5.0
Fixed component ID 5630A3600

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00S PSY    UP
R00W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 00S
Software edition:
Reference #: PQ69364
IBM Group: Software Group
Modified date: Jan 20, 2003