PH29786: ECLIPSELINK CRITERIABUILDER IN() EXPRESSION CREATES INCORRECT SQL

APAR status

• Closed as program error.

Error description

• Using javax.persistence.criteria.Expression.in(), while passing
  the Collection.class type, EclipseLink generates incorrect SQL.
  
  SQL:
      SELECT ID FROM USER WHERE (FIRSTNAME IN ((?, ?)))
  
  Exception:
      java.sql.SQLException: Unexpected token: ) in statement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server - Java Persistence API - JPA 2.1 &   *
  *                  EclipseLink                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using JPA criteria.Expression.in(),     *
  *                      while passing the Collection.class      *
  *                      type, EclipseLink generates incorrect   *
  *                      SQL.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  EclipseLink generates incorrect SQL for Collection.class
  parameters used in IN expressions. EclipseLink is using the
  wrong number of parentheses, causing the SQL to be invalid.
  Exception:
  java.sql.SQLException: Unexpected
  token: ) in statement
  

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