Fixes are available
8.0.0.5: WebSphere Application Server V8.0 Fix Pack 5
8.0.0.6: WebSphere Application Server V8.0 Fix Pack 6
8.0.0.7: WebSphere Application Server V8.0 Fix Pack 7
8.0.0.8: WebSphere Application Server V8.0 Fix Pack 8
8.0.0.9: WebSphere Application Server V8.0 Fix Pack 9
8.0.0.10: WebSphere Application Server V8.0 Fix Pack 10
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
APAR status
Closed as program error.
Error description
Error Description: https://issues.apache.org/jira/browse/OPENJPA-1974 JPQL with multiple subquery in @OneToMany annotated collection property with eager fetch configuration, StackOverflowError is thrown. java.lang.StackOverflowError at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2166) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2160) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2168) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2160) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2168) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2160) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2168) ...
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server V8.0.0 who make use of subqueries * * involving eager @OneToMany collections. * **************************************************************** * PROBLEM DESCRIPTION: StackOverflowError when performing * * multiple subquery in collection field * * with eager fetch. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following StackOverflowError is thrown when running a JPQL query with multiple subqueries in an @OneToMany annotated collection property with eager fetch configuration: java.lang.StackOverflowError at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2166) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2160) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2168) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2160) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2168) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2160) at org.apache.openjpa.jdbc.sql.SelectImpl.aliasSize(SelectImpl.java :2168)
Problem conclusion
With this fix code has been added to OpenJPA to fix the StackOverflowError which can occur when executing a JPQL query. The fix for this APAR is currently targeted for inclusion in Service Level (Fix Pack) 8.0.0.6 of WebSphere Application Server version 8.0.0. Please refer to the recommended updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PM64825
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-16
Closed date
2012-06-05
Last modified date
2012-06-19
APAR is sysrouted FROM one or more of the following:
PM62447
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WEBSPHERE APP S
Fixed component ID
5724J0800
Applicable component levels
R800 PSY
UP
Document Information
Modified date:
28 October 2021