Opentelemetry undefined result

[monwolf]

We are trying to setup observability with OTEL @opentelemetry/auto-instrumentations-node": "^0.64.1" using the driver "oracledb": "^6.7.0" on Oracle 19. When we enable otel on our service, we can see the error:

2025-09-22T13:23:57.679Z [info] jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxx.cd22u62e42mh.eu-west-1.rds.amazonaws.com)(PORT=2702))(CONNECT_DATA=(SID=xxxxxx))) connecting...
TypeError: Cannot set properties of undefined (setting 'result')
    at traceExitFn (/home/bernat/il-office-rest/node_modules/oracledb/lib/util.js:202:40)
    at createPool (/home/bernat/il-office-rest/node_modules/oracledb/lib/util.js:310:21)
    at createPool (/home/bernat/il-office-rest/node_modules/oracledb/lib/util.js:246:19)
    at Object.init (/home/bernat/il-office-rest/dist/database/office.oracle.datasource.js:17:44)
    at init (/home/bernat/il-office-rest/dist/app.js:18:24)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async start (/home/bernat/il-office-rest/dist/server.js:27:9)

[sharadraju]

Hi @monwolf Can you provide us a reproducible test case?

Are you using a jdbc connect string? That will not work with node-oracledb and otel.

[monwolf]

Hi @sharadraju ,

We've been able to reproduce it with minimal TS code:

import { NodeSDK } from '@opentelemetry/sdk-node';
import { getNodeAutoInstrumentations } from '@opentelemetry/auto-instrumentations-node';
process.env.OTEL_TRACES_EXPORTER="otlp"
process.env.OTEL_METRICS_EXPORTER="otlp"
process.env.OTEL_RESOURCE_ATTRIBUTES="service.name=xxxxx,deployment.environment.name=xxxxx,service.version=0.0.0-LOCAL"
process.env.OTEL_EXPORTER_OTLP_ENDPOINT="http://xxxxxxx:4318"
process.env.OTEL_NODE_RESOURCE_DETECTORS="env,host,os"

process.env.OTEL_LOG_LEVEL="DEBUG"

  const sdk = new NodeSDK({
    instrumentations: [getNodeAutoInstrumentations()],

  });
  
 sdk.start();

import { getConnection } from "oracledb";
const init = async (connectionData: any) => {
  console.log(
    `jdbc:oracle:thin:@${connectionData.connectionString} connecting...`,
  );

  let conn = await getConnection(connectionData);
  const result = await conn.execute('SELECT * FROM DUAL');
  conn.close();
  console.log("Oracle Connected Successfully"); 
};

init({
    user: "xxxx",
    connectionString: "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=2702))(CONNECT_DATA=(SID=xxxx)))",
    password: 'xxx',
})

This is our package.json

{
  "name": "xxxx",
  "version": "2.12.0",
  "description": "xxxx",
  "main": "./dist/server.js",
  "engines": {
    "node": ">=22"
  },
  "config": {
    "archetypeVersion": "3.1.3"
  },
  "scripts": {
    "start": "node ./dist/index",
    "tsc:b": "tsc --build"
  },
  "keywords": [],
  "license": "UNLICENCED",
  "dependencies": {
    "@opentelemetry/api": "^1.9.0",
    "@opentelemetry/auto-instrumentations-node": "^0.64.1",
    "@opentelemetry/sdk-node": "^0.205.0",

    "oracledb": "^6.7.0"
  },
  "devDependencies": {
    "@types/node": "^22.7.5",
    "@types/oracledb": "^5.2.3",
    "globals": "^16.0.0",
    "typescript": "^5.9.2"
  }
}

And our tsconfig.json:

{
  "compilerOptions": {
    "baseUrl": "./",
    "module": "CommonJS",
    "moduleResolution": "node",
    "outDir": "./dist",
    "rootDir": "src",
    "target": "ESNext",
    "strict": true,
    "allowSyntheticDefaultImports": true
  },
  "include": ["src/**/*"],
  "exclude": ["test"]
}

If we try the same code directly in JS it works:

var otel = require('@opentelemetry/sdk-node');
var au = require('@opentelemetry/auto-instrumentations-node');
var otelora = require('@opentelemetry/instrumentation-oracledb')
process.env.OTEL_TRACES_EXPORTER="otlp"
process.env.OTEL_METRICS_EXPORTER="otlp"
process.env.OTEL_RESOURCE_ATTRIBUTES="service.name=xxxxx,deployment.environment.name=xxxxx,service.version=0.0.0-LOCAL"
process.env.OTEL_EXPORTER_OTLP_ENDPOINT="http://xxxxx:4318"
process.env.OTEL_NODE_RESOURCE_DETECTORS="env,host,os"
process.env.OTEL_LOG_LEVEL="DEBUG"


const sdk = new otel.NodeSDK({
instrumentations: [au.getNodeAutoInstrumentations(), new otelora.OracleInstrumentation()],
});

 sdk.start();

var oracledb = require("oracledb");
const init = async (connectionData) => {
  console.log(
    `jdbc:oracle:thin:@${connectionData.connectionString} connecting...`,
  );

  let conn = await oracledb.getConnection(connectionData);
  const result = await conn.execute('SELECT * FROM DUAL');
  conn.close();
  console.log("Oracle Connected Successfully"); 
};

init({
    user: "xxxx",
    connectionString: "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=2702))(CONNECT_DATA=(SID=xxxx)))",
    password: 'xxxx',
})

[sudarshan12s]

Thanks @monwolf for sharing the detailed program.
Can you modify your typescript program to import as below and see if it works:

import * as oracledb from "oracledb";

and calling getConnection as
let conn = await oracledb.getConnection(connectionData);

I will update on shorter version of it import { getConnection } . It might need some fix to handle this specific import style..

[monwolf]

It worked, thanks 👍