on 09-16-2015 11:59 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.