PH14747: ECLIPSELINK BINDS UNTYPED PARAMETERS ON DB2

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 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