PM74489: UPDATE BY QUERY FAILS ON ENTITIES USING TIMESTAMPED VERSION FIELD

7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server

APAR status

• Closed as program error.

Error description

• Update by query fails when an entity is using Timestamped
  version field
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server V7.0.0 who make use of a Java        *
  *                  Persistence API (JPA) version field of      *
  *                  Timestamp type.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: An update query of a JPA Version        *
  *                      field of type Timestamp may fail.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Take the following JPA Entity definition:
  @Entity
  public class TimestampedEntity {
  @Id
  @GeneratedValue
  private long id;
  private String name;
  @Version
  private Timestamp version;
  As can be seen a version (@Version) field is defined with a
  type of Timestamp.  When this entity is updated, the update
  may fail.  For example, the following update query will fail:
  String jpql = "UPDATE TimestampedEntity t SET t.name=:newname
  WHERE t.name=:oldname";
  em.createQuery(jpql).setParameter("newname", "Updated")
  .setParameter("oldname", "Original").executeUpdate();
  

Problem conclusion

• With this fix, code has been added to OpenJPA to ensure that a
  Timestamp version field is properly handled when an attempt is
  made to update the corresponding entity.
  
  The fix for this APAR is currently targeted for
  inclusion in Service Level (Fix Pack) 7.0.0.27 of WebSphere
  Application Server version 7.0.0.
  
  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:

  PM73302

• 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

• R700 PSY

     UP