PH21925: ECLIPSELINK DB2ZPLATFORM USES INVALID QUERY TO PING DATABASE

APAR status

• Closed as program error.

Error description

• EclipseLink uses the query "VALUES(1)" to test database
  connections for DB2 z/os. This query is invalid for this
  platform.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server - Java Persistence API - JPA 2.1,    *
  *                  EclipseLink, DB2 z/OS                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: EclipseLink runs a query "VALUES(1)"    *
  *                      to test database connectivity. This     *
  *                      query is invalid for DB2 z/OS           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  EclipseLink runs the query "VALUES(1)" to test connectivity to
  the database when a query exception occurs. This query is
  invalid for DB2 z/OS and will fail. This can cause errors to be
  logged on the database, but EclipseLink will swallow the
  failure and not change behavior.
  The correct query for DB2 is to query the SYSIBM.SYSDUMMY1
  table.
  

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=559896
  
  This fix is currently targeted for WebSphere Application
  Server 9.0.5.5 and WebSphere Liberty 20.0.0.5. 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

  WEBSPHERE FOR Z

• Fixed component ID

  5655I3500

Applicable component levels