APAR status
Closed as program error.
Error description
Using javax.persistence.criteria.Expression.in(), while passing the Collection.class type, EclipseLink generates incorrect SQL. SQL: SELECT ID FROM USER WHERE (FIRSTNAME IN ((?, ?))) Exception: java.sql.SQLException: Unexpected token: ) in statement
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server - Java Persistence API - JPA 2.1 & * * EclipseLink * **************************************************************** * PROBLEM DESCRIPTION: Using JPA criteria.Expression.in(), * * while passing the Collection.class * * type, EclipseLink generates incorrect * * SQL. * **************************************************************** * RECOMMENDATION: * **************************************************************** EclipseLink generates incorrect SQL for Collection.class parameters used in IN expressions. EclipseLink is using the wrong number of parentheses, causing the SQL to be invalid. Exception: java.sql.SQLException: Unexpected token: ) in statement
Problem conclusion
The fix for this APAR changes the EclipseLink implementation and involves an update to the thirdparty source. See https://bugs.eclipse.org/bugs/show_bug.cgi?id=349477 This fix is currently targeted for WebSphere Application Server 9.0.5.7 and WebSphere Liberty 20.0.0.12. 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
PH29786
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
2020-09-23
Closed date
2020-11-17
Last modified date
2020-11-17
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:
01 November 2021