PH29809: ECLIPSELINK IGNORES LOWERCASE ATTRIBUTEOVERRIDE VALUES ON ELEMENTCOLLECTIONS

APAR status

• Closed as program error.

Error description

• EclipseLink ignores @AttributeOverride values on
  @ElementCollections if the @Column value is lowercase. This
  effects both JPQL and schema generation where the SQL doesn't
  match the expected attribute overrides.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: EclipseLink SQL and DDL generation      *
  *                      ignores @AttributeOverride values       *
  *                      when the overridden columns are lower   *
  *                      case                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  EclipseLink's SQL and DDL generation will ignore
  @AttributeOverride values and generate statements that are
  unexpected.
  Example:
  ´´´
  @Entity
  public class WealthyPerson {
  @Id
  protected String ssn;
  @ElementCollection
  @CollectionTable(name = "HOMES") // use default join
  column name
  @AttributeOverrides({
  @AttributeOverride(name = "street", column =
  @Column(name = "home_street"))
  })
  protected Set<Address> vacationHomes;
  }
  @Embeddable
  public class Address {
  @Column(name="du_street")
  protected String street;
  }
  &#180;&#180;&#180;
  With this mapping, EclipseLink is generating DDL and JPQL that
  include the column name &#180;du_street&#180; instead of the column
  override &#180;home_street&#180;.
  

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