PQ93819: WHEN 10 OR MORE DB TABLES ARE JOINED IN QUERY, PMGR6022E RESULTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() APAR status Closed as program error. Error description Whenever more than 10 tables are accessed in a query or database SQL, The error PMGR6022E results.Local fix Problem summary **************************************************************** * USERS AFFECTED: WebSphere Application Server users of CMP, * * especially with large FunctionSets * **************************************************************** * PROBLEM DESCRIPTION: ConcurrentModificationException is * * thrown in WSRegistrationHelper when * * adding a FunctionSet to the HashMap * **************************************************************** * RECOMMENDATION: * **************************************************************** A HashMap was used to store FunctionSet information in the WSRegistrationHelper class. This was initially reported by a customer using CMP with sophisticated EJB relationships involving JOIN of more than 10 tables. The code was lacking any synchronization around the HashMap.Problem conclusion Added sychronization around puts to the HashMap. Gets from the HashMap will now copy a reference to the HashMap, and puts to the HashMap will clone the HashMap, execute the put, and swap the clone back in as the active HashMap for subsequent gets.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: 00A
Software edition:
Reference #: PQ93819
IBM Group: Software Group
Modified date: Oct 8, 2004
(C) Copyright IBM Corporation 2000, 2008. All Rights Reserved.