PI44419: SOME JSONSTORE OPERATIONS MAY FAIL WHEN SINGLE-QUOTE CHARACTERS ARE INCLUDED IN STORED DATA

IBM MobileFirst Platform Foundation Interim Fix README for 7.0
IBM MobileFirst Platform Foundation Interim Fix README for 6.3

APAR status

• Closed as program error.

Error description

• Some operations fail when there are single quotes inside the
  JSON data being stored with JSONStore.
  

Local fix

• None available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Developers using JSONStore                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If json data containing single quotes is added to a          *
  * JSONStore collection, SQLite queries will fail, causing the  *
  * data to not be added. This has not been confirmed to occur   *
  * with any special characters except other than single quotes. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * -                                                            *
  ****************************************************************
  

Problem conclusion

• Strings are now parsed to fix JSON strings containing single
  quotes, so they no longer break SQLite queries.
  

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

  MFPF/WORKLIGHT

• Fixed component ID

  5725I4301

Applicable component levels

• R630 PSY

     UP

• R700 PSY

     UP