cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing HANA DB from xsjs in web IDE

sandeep_mekala
Explorer
0 Kudos

Hello Experts,

I am trying to retrieve data from HANA DB. Below is my code

$.response.contentType = "text/html";

var output = "Hello world !"<br><br>;

var conn = $.hdb.getConnection();

var query = 'select * from "NEO_xxxxxxxxxxxxxxxxxxxxxxxxxx"."STUDENT"';

var rs = conn.executeQuery(query);

if(rs.length<1){

     $.response.setBody("Failed to retrieve data");

     $.response.status = $.net.http.INTERNAL_SERVER_ERROR;

}

else{

     output +="This is the response from DB";

     $.response.setBody(output);

}

conn.close();

when I directly access my xsjs in the browser I am getting the following error.

Accepted Solutions (0)

Answers (1)

Answers (1)

sandeep_mekala
Explorer
0 Kudos

InternalError: dberror($.hdb.Connection.executeQuery):*********.Insufficient privilege: Not authorized**********

So can somebody help to fix this issue.