PH51431: ECLIPSELINK DOES NOT SUPPORT NON-BREAKING SPACE CHARACTERS IN SQL/JPQL QUERY STRINGS

APAR status

• Closed as program error.

Error description

• The error from a query containing a non-breaking space
  character can be varied. However, the error will contain a
  "Syntax" error similar to:
  
  ```
  org.eclipse.persistence.exceptions.JPQLException
  Exception Description: Syntax error parsing
  ```
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server - Java Persistence API - JPA 2.1 &   *
  *                  EclipseLink                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: EclipsLink throws a syntax exception    *
  *                      for query strings containing            *
  *                      non-breaking spaces as whitespace.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  EclipseLink uses `java.lang.Character.isWhitespace(char)` which
  does not recognize non-breaking spaces ('\u005Cu00A0',
  '\u005Cu2007', '\u005Cu202F') as whitespace. For that reason,
  EclipseLink cannot process non-breaking spaces as whitespace
  and therefore cannot process string queries containing these
  non-breaking spaces.
  

Problem conclusion

• The fix for this APAR changes the EclipseLink implementation
  and involves an update to the third-party source. See
  https://github.com/eclipse-ee4j/eclipselink/issues/1755
  
  This fix is currently targeted for WebSphere Application
  Server 9.0.5.16 and WebSphere Liberty 23.0.0.4. 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