PQ69364, 5.0: IndexOutOfBoundsException with prepared statements
 Downloadable files
 
Abstract
IndexOutOfBoundsException in com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.countParameter
 
Download Description

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.
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.

Note: The UpdateInstaller is needed to apply this fix.
 
Prerequisites
None
 
 
Installation Instructions
Please review the readme.txt for detailed installation instructions.
 
URL LANGUAGE SIZE(Bytes)
Readme US English 1907
 
Download package
What is DD?
Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
PQ69364 12/20/2002 US English 336085 FTP DD
 
Technical support
1-800-IBM-SERV (U.S. calls only)
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
Problems (APARS) fixed
PQ69364
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.0
Software edition:
Reference #: 4004618
IBM Group: Software Group
Modified date: Apr 18, 2003