PM80399: JSONSTORE SQL TEMPLATE MISCONFIGURATION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Worklight

Software version:

5.0.5

Reference #:

PM80399

Modified date:

2013-03-14

Translate my page

Machine Translation

Content navigation