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.