PQ69364: INDEXOUTOFBOUNDSEXCEPTION IN COM.IBM.WS.RSADAPTER.JADBC. WDJDBCPREPAREDSTATEMENT.COUNTPARAMETEE | |||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||
![]() 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=0Problem 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
Publications Referenced
|
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
(C) Copyright IBM Corporation 2000, 2008. All Rights Reserved.