APAR status
Closed as program error.
Error description
When using the EclipseLink persistence property 'eclipselink.jdbc.force-bind-parameters' with a value of 'true', EclipseLink can throw an exception if literal expressions are used. EclipseLink improperly binds literal expressions and constants as untyped parameters. Query Example: SELECT e FROM EntityTbl e WHERE e.itemInteger = 1; Exception: DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server - Java Persistence API - JPA 2.1 & * * EclipseLink, on DB2 * **************************************************************** * PROBLEM DESCRIPTION: EclipseLink binds all literals as * * query * * parameters. This fix disables literal * * parameter binding for DB2 * **************************************************************** * RECOMMENDATION: * **************************************************************** When enabling parameter binding for EclipseLink queries and running on DB2, EclipseLink binds literal values as parameters causing an exception to be thrown. Internal Exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker
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=542491 This fix is currently targeted for WebSphere Application Server 9.0.5.3 and WebSphere Liberty 19.0.0.11. 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
PH14747
Reported component name
LIBERTY PROF -
Reported component ID
5655W6514
Reported release
CD0
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-07-22
Closed date
2019-11-18
Last modified date
2020-02-03
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
LIBERTY PROF -
Fixed component ID
5655W6514
Applicable component levels
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"CD0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 February 2020