PH36828: ECLIPSELINK SUPPORT FOR EMBEDDABLE FIELDS AS JOIN TARGETS

APAR status

• Closed as program error.

Error description

• EclipseLink throws an exception for JPQL and CriteriaBuilder
  queries if they attempt to JOIN on fields of Embeddable type.
  However, performing these JOINs on Embeddable fields is
  supported by the JPA specification.
  
  Exception example:
  ´´´
  org.eclipse.persistence.exceptions.JPQLException
  Exception Description: Problem compiling [SELECT e FROM
  Employee e JOIN e.contactInfo
  c JOIN c.phones p].
  [30, 43] The collection-valued path 'e.contactInfo' must
  resolve to an association field.
  ´´´
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server - Java Persistence API - JPA 2.1 &   *
  *                  EclipseLink                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: EclipseLink throws an exception for     *
  *                      JPQL and CriteriaBuilder                *
  *                      queries if they attempt to JOIN on      *
  *                      fields of Embeddable type.              *
  *                      However, performing these JOINs on      *
  *                      Embeddable fields is                    *
  *                      supported by the JPA specification.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Eclipselink doesnt support JOINs against Embeddable fields,
  but the JPA specification describes that it should be supported
  Example Query:
  ´´´
  SELECT p.vendor FROM Employee e JOIN e.contactInfo c JOIN
  c.phones p WHERE e.contactInfo.address.zipcode = '95054'
  ´´´
  Example exception:
  ´´´
  JPQLException
  Exception Description: Problem compiling [SELECT e FROM
  Employee e JOIN e.contactInfo c JOIN c.phones p].
  [30, 43] The collection-valued path 'e.contactInfo' must
  resolve to an association field.
  at
  org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildExce
  ption(HermesParser.java:155)
  at
  org.eclipse.persistence.internal.jpa.jpql.HermesParser.validate(
  HermesParser.java:347)
  at
  org.eclipse.persistence.internal.jpa.jpql.HermesParser.populateQ
  ueryImp(HermesParser.java:278)
  at
  org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildQuer
  y(HermesParser.java:163)
  ´´´
  

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