PH16920: ECLIPSELINK: AGGREGATEOBJECTMAPPING SUPPORT FOR ECLIPSELINK.CURSOR

9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• When using an AggregateObjectMapping (like an Embeddable) and
  EclipseLink's Cursor API to get a resultSet, EclipseLink
  calculates the wrong attribute index in the query, resulting in
  an exception:
  
   java.lang.NumberFormatException: For input
  string: "fieldName"
   at org.eclipse.persistence.exceptions.Conve
  rsionException.couldNotBeConverted(ConversionException.java:93)
  
  at org.eclipse.persistence.internal.helper.ConversionManager.con
  vertObjectToInteger(ConversionManager.java:560)
   at org.eclipse.
  persistence.internal.helper.ConversionManager.convertObject(Conv
  ersionManager.java:131)
   at org.eclipse.persistence.internal.dat
  abaseaccess.DatasourcePlatform.convertObject(DatasourcePlatform.
  java:225)
   at org.eclipse.persistence.mappings.foundation.Abstra
  ctDirectMapping.getObjectValue(AbstractDirectMapping.java:625)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server - Java Persistence API - JPA 2.1 &   *
  *                  EclipseLink                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using EclipseLink's QueryHint,          *
  *                      ´eclipselink.cursor´, with an           *
  *                      Embeddable results in                   *
  *                      ConversionException thrown              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using EclipseLink's
  org.eclipse.persistence.queries.Cursor API to obtain a result
  set, EclipseLink calculates the wrong index for @Embeddable
  attributes. This causes EclipseLink to throw a
  ConversionException as the wrong index is used.
  Example:
  Query query = em.createQuery("SELECT e.mappingField1,
  e.aggregateObjectMapping FROM SimpleMappingEntity e");
  query.setHint(QueryHints.CURSOR, HintValues.TRUE);
  org.eclipse.persistence.queries.Cursor cursor =
  (org.eclipse.persistence.queries.Cursor)
  query.getSingleResult();
  

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=471144
  
  This fix is currently targeted for WebSphere Application
  Server 9.0.5.3 and WebSphere Liberty 19.0.0.11. For
  more information, see 'Recommended Updates for WebSphere
  Application Server':
  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

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels

• R900 PSY

     UP