Node.js Tracing

There are several ways to activate Node.js tracing:

Tracing configured by hdbsqldbc_cons
Tracing environment variables
Connection-specific tracing to the console
Tracing using a callback provided by the Node.js application

Trace Using the hdbsqldbc_cons Tool

Use the hdbsqldbc_cons tool to initiate diagnostic tracing for your Node.js applications. The API category of tracing can be particularly helpful for tracing calls into the Node.js driver.

Example

hdbsqldbc_cons CONFIG TRACE FILENAME /tmp/NODEJS-%p.txt
hdbsqldbc_cons TRACE API ON LEVEL DEBUG
hdbsqldbc_cons TRACE SQL ON LEVEL INFO

See hdbsqldbc_cons Trace Options for more information.

Trace Using Environment Variables

There are two environment variables that can be used to configure tracing for Node.js applications: HDB_SQLDBC_TRACEFILE and HDB_SQLDBC_TRACEOPTS.

HDB_SQLDBC_TRACEFILE: Specifies the trace file name. A timestamp is added to the name to provide additional protection from malicious users.
HDB_SQLDBC_TRACEOPTS: Specifies the trace configuration options. The API trace category can be particularly helpful for tracing calls into the Node.js driver.

Example

set HDB_SQLDBC_TRACEFILE="/tmp/NODEJS-%p.txt"
set HDB_SQLDBC_TRACEOPTS="API=DEBUG,SQL=INFO"

See SQLDBC Trace Options for more information.

Connection-Specific Tracing to the Console

There are two connection options that can be used to configure tracing for specific Node.js connections to the console: traceFile and traceOptions.

traceFile: Specifies the trace file name. Only the stdout and stderr values are supported.
traceOptions: Specifies the trace configuration options. The API trace category can be particularly helpful for tracing calls into the Node.js driver.

Example

var connOptions = {
    serverNode: 'myserver:30015',
    uid: 'User1',
    pwd: 'Password123',
    traceFile: 'stdout',
    traceOptions: 'API=DEBUG,SQL=INFO'
};

See SQLDBC Trace Options for more information.

Trace Using a Node.js Callback Method

A Node.js trace callback method can be supplied to a connection using the onTrace method to receive trace messages.

Example

var traceCB = function (buf) {
    console.log(buf);
};
conn.onTrace("API=DEBUG,SQL=INFO,FLUSH,OutBufferSize=64k", traceCB);

See onTrace(traceOptions, callback) Method for more information.