IBM Support

PM80399: JSONSTORE SQL TEMPLATE MISCONFIGURATION

Subscribe

You can track all active APARs for this component.

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 number

    PM80399

  • Reported component name

    WORKLIGHT ENTER

  • Reported component ID

    5725I4300

  • Reported release

    505

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-11

  • Closed date

    2013-03-14

  • Last modified date

    2013-03-14

  • 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



Document information

More support for: IBM Worklight

Software version: 505

Reference #: PM80399

Modified date: 2013-03-14