PM80399: JSONSTORE SQL TEMPLATE MISCONFIGURATION

APAR status

• Closed as program error.

Error description

• An error appears when using the default SQLAdapter template for
  

Local fix

• In the -impl.js file, change this
  
  function getSQLAdapterTests() {
      var selectStatement = WL.Server.createSQLStatement("select
  COLUMN1,
  COLUMN2 from TABLE1");
  
      return WL.Server.invokeSQLStatement({
          preparedStatement : selectStatement,
          parameters : []
      });
  }
  
  To this below
  
      var mySelectStatement = WL.Server.createSQLStatement("select
  COLUMN1, COLUMN2 from TABLE1");
  
  function getSQLAdapterTests() {
      return WL.Server.invokeSQLStatement({
          preparedStatement : mySelectStatement,
          parameters : []
      });
  }
  
  In other words, put your SQL statement in global variables
  outside the functions and just reference these global
  variables from within your functions as in the example above.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Worklight and Mobile Foundation 5.0         *
  *                  developers who make use of                  *
  *                  the JSONStore and create an Offline SQL     *
  *                  Adapter and use the                         *
  *                  default auto-generated template.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: A server-side error such as             *
  *                      [2013-01-02 09:41:15]                   *
  *                      Procedure invocation finished           *
  *                      [2013-01-02 09:41:15] FWLSE0099E: An    *
  *                      error occurred                          *
  *                      while invoking procedure                *
  *                      offlinesql/updateOfflinesqlFWLSE0100E:  *
  *                      parameters:{                            *
  *                      "arr": [                                *
  *                      ]                                       *
  *                      }                                       *
  *                      Method createSQLStatement was called    *
  *                      inside a                                *
  *                      JavaScript function.                    *
  *                      FWLSE0101E: Caused by: null             *
  *                      appears in the log.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The default code generated is incorrect because it puts the
  createSQLStatement inside functions.
  

Problem conclusion

• The code was modified so that the createSQLStatement appears out
  default template.
  
  The fix for this APAR is currently targeted for inclusion in fix
  

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

  WORKLIGHT ENTER

• Fixed component ID

  5725I4300

Applicable component levels

• R505 PSY

     UP