Database

Develop

  1. Create a new project and name it database_basic.
  2. Select the ScriptingServices sub-folder of the project and open the pop-up menu.
  3. Choose New -> Scripting Service.
  4. Choose Server-Side JavaScript Service from the list of available templates.
  5. Give it a meaningful name (e.g database_basic.js).
  6. Replace the generated code in database_basic.js with the following:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
	/* globals $ */
	/* eslint-env node, dirigible */

	var database = require('db/database');
	var response = require('net/http/response');

	var datasource = database.getDatasource(); // default
	//var datasource = db.getNamedDatasource("name-of-the-datasource");

	var connection = datasource.getConnection();
	try {
		var statement = connection.prepareStatement("select * from DGB_FILES where FILE_PATH like ?");
		var i = 0;
		statement.setString(++i, "%");
		var resultSet = statement.executeQuery();
		while (resultSet.next()) {
			response.println("[path]: " + resultSet.getString("FILE_PATH"));
		}
		resultSet.close();
		statement.close();
	} catch(e) {
		console.trace(e);
		response.println(e.message);
	} finally {
		connection.close();
	}

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

Discover

To discover all available services, you can go to the Registry.

  1. From the main menu, choose Window -> Show Perspective -> Registry.
  2. The Registry perspective represents a view to the enabled runtime content. From its menu, choose Discover -> JavaScript to open the currently available server-side JavaScript service endpoints.
  3. You can see the list of available endpoints, where you can find yours by naming convention: {project}/{service path}
Edit