PQ76789: 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. 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=0Problem 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
Publications Referenced
|
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
(C) Copyright IBM Corporation 2000, 2009. All Rights Reserved.