cancel
Showing results for 
Search instead for 
Did you mean: 

getMetaData is not a function problem

Former Member
0 Kudos

Hi everybody,

When a call getMetaData() in a xsjs file i receive the following error: getMetaData is not a function.

           var rs=cstmt.execute();

          var metadata = rs.getMetaData();

Anyone knows how to fix it?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member194780
Active Participant
0 Kudos

Hi Alin,

Looks like your query is not prepared correctly and while executing it fails to store data in resultset (rs).. i.e the cstmt.execute() statement is failing..

I tried an example and it worked for me..

var id = $.request.parameters.get("id");

var emp_id,name;

var dConn = $.db.getConnection();

try{

var sql = "SELECT * FROM \"AVIR11\".\"EMPLOYEE\""

   +" WHERE ID = ? ";

var pstms = dConn.prepareStatement(sql);

pstms.setInteger(1,parseInt(id));

var rs = pstms.executeQuery();

var metadata = rs.getMetaData();

while ( rs.next())

{

  emp_id = rs.getInteger(1);

  name = rs.getString(2);

}

var output = {

  "id":emp_id,

  "name":name,

  "metadata":metadata

};

dConn.close();

$.response.setBody(JSON.stringify(output));

}

catch(e)

{

    $.response.setBody(e.message);

}

-Avinash