APAR status
Closed as program error.
Error description
When attempting to use Parameters within CriteriaBuilder ´having´ clause, EclipseLink throws an exception: ´´´ org.eclipse.persistence.exceptions.QueryException Exception Description: The parameter name [null] in the query's selection criteria does not match any parameter name defined in the query. ´´´
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server - Java Persistence API - JPA 2.1 & * * EclipseLink * **************************************************************** * PROBLEM DESCRIPTION: Add support for parameters within * * EclipseLink CriteriaBuilder HAVING * * clause * **************************************************************** * RECOMMENDATION: * **************************************************************** ExclipseLink throws an exception when parameters are used within CriteriaBuilder HAVING clause. Exception: ´´´ org.eclipse.persistence.exceptions.QueryException Exception Description: The parameter name [ ] in the query's selection criteria does not match any parameter name defined in the query ´´´
Problem conclusion
The fix for this APAR changes the EclipseLink implementation and involves an update to the third-party source. See https://bugs.eclipse.org/bugs/show_bug.cgi?id=417259 This fix is currently targeted for WebSphere Application Server 9.0.5.9. For more information, see 'Recommended Updates for WebSphere Application Server': https://www.ibm.com/support/pages/node/715553
Temporary fix
Comments
APAR Information
APAR number
PH37837
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-06-03
Closed date
2021-07-12
Last modified date
2021-07-12
APAR is sysrouted FROM one or more of the following:
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
R900 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
02 November 2021