1 Reply Latest reply on Nov 24, 2017 9:58 AM by carlesc RSS
    pbadiger Newbie

    how to call a query service from javascript service passing json object

    Hi Team,

     

    I have a requirement where in I am calling a javascript service from a mashup, this service will inturn call a sql query service passing the json parameter. Once the sql service is executed, result of the query execution is retrieved in the javascript service.

    Below are my services

     

    Javascript service

     

    var params = {

    username: username /* STRING */,

    password: password /* STRING */

    };

    logger.warn("username in params = " +params.username);

    logger.warn("password in params = " +params.password);

    var queryparams = {};

    queryparams['name'] = params.username;

    queryparams['password'] = params.password;

    // result: INFOTABLE dataShape: "undefined"

    var result = me.queryUser(queryparams);

     

     

    SQL Query service

     

    select * from DPD_USERS where NAME=[[params.name]] and password=[[params.password]] //where params is the json parameter sent in from JS service

     

    When I execute the JS service its gets data properly and tries to execute the query service. However, in query service execution, I get the following error

     

    Wrapped org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT * FROM <MY_TABLE> WHERE NAME=[[*][PARAMS['name']]] AND PASSWORD=[[PARAMS['password']]] "; expected "ALL, ANY, SOME, SELECT, FROM, WITH"; SQL statement: select * from <MY_TABLE> where NAME=[[params['name']]] and password=[[params['password']]] [42001-192] Cause: Syntax error in SQL statement "SELECT * FROM <MY_TABLE> WHERE NAME=[[*][PARAMS['name']]] AND PASSWORD=[[PARAMS['password']]] "; expected "ALL, ANY, SOME, SELECT, FROM, WITH"; SQL statement: select * from <MY_TABLE> where NAME=[[params['name']]] and password=[[params['password']]] [42001-192]

     

     

    I believe I am making a mistake in extracting parameters from json object. I could not get find any post which could lead me to correct syntax. Please help.

     

    Thanks,

    Pawan