Exception passing parameters to Db2 query in IBM Cloud Functions using Node.js

Question

I wrote a Node.js-based action in IBM Cloud Functions / OpenWhisk. The action retrieves data from Db2. The query works when I don't have parameter markers. When I use a parameter as shown below and pass in {"confname" : "IDUGEMEA2018" } then it runs into an error and the exception is raised.

Why? What needs to be changed?

var ibmdb = require('ibm_db');

function queryConferences(dsn, confname) { 
 try {    
    var conn=ibmdb.openSync(dsn);
    var data=conn.querySync("select shortname, location, begindate, enddate, uri from conference where shortname=?", confname);
    conn.closeSync();
    return {result : data};
 } catch (e) {
     return { dberror : e }
 }
}

function main({confname, __bx_creds: {dashDB:{dsn}}}) {
    return queryConferences(dsn,confname);
}

data_henrik · Accepted Answer · 2018-01-24 12:49:33Z

1

It fails because the bindingParameters is expecting an array. I got it to work passing in the following:

{"confname" : ["IDUGEMEA2018"] }

In the CLI I tested it with the following:

bx wsk action invoke myAction -p confname "[\"IDUGEMEA2018\"]" -r

answered Jan 24, 2018 at 12:49

data_henrik

17.3k2 gold badges33 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exception passing parameters to Db2 query in IBM Cloud Functions using Node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related