Database Query

Steps

  1. Create a project database_project.
  2. Then create a JavaScript service named database_query.js.
  3. Within the service code, enter the following content:

Log Levels

1
2
3
4
5
6
7
8
9
10
11
12
var query = require('db/v3/query');
var response = require('http/v3/response');

var sql = "SELECT * FROM DIRIGIBLE_EXTENSIONS WHERE EXTENSION_EXTENSIONPOINT_NAME = ?";
var resultset = query.execute(sql, ['ide-view']);

response.println('<pre>' + JSON.stringify(resultset, null, 2) + '</pre>');

response.flush();
response.close();


For more information, see the API documentation.

Edit