PH40302: ECLIPSELINK BEHAVIOR CHANGE FOR BOOLEAN VALUES IN CASE SELECT EXPRESSIONS

APAR status

• Closed as program error.

Error description

• Starting in WebSphere release 9.0.5.7, EclipseLink changed
  behavior for CASE select expressions. EclipseLink now returns
  boolean type values instead of integer type values for CASE
  select expressions.
  
  This causes existing applications to fail at runtime with an
  unexpected query return type if they are coded to expect
  Integer types.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server - Java Persistence API - JPA 2.1 &   *
  *                  EclipseLink                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: JPA CASE expressions return type        *
  *                      change in behavior.                     *
  *                      This is a regression fix for PH30837.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  APAR PH30837 delivered a change in behavior for CASE
  expressions in EclipseLink. With APAR PH30837, EclipseLink
  started converting query return types of INTEGER to BOOLEAN if
  the JPQL expected BOOLEAN. However, that change in behavior
  was supposed to be guarded by a persistence property
  "eclipselink.allow-result-type-conversion" for JPA Container
  managed persistence. This APAR now correctly applies
  this persistence property in order to preserve original
  behavior.
  

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=567891
  
  This fix is currently targeted for WebSphere Application
  Server 9.0.5.10.  For more information, see 'Recommended
  Updates for WebSphere Application Server':
  https://www.ibm.com/support/pages/node/715553
  

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

  WEBSPHERE APP S

• Fixed component ID

  5724J0800

Applicable component levels