Agent Can't track oracle sql requests

[ridakaddir]

trafficstars

Hi community,

I have an issue with the node js agent, when I execute a SQL request on my Oracle data base I can't see any information about the request However it works for postgresql requests

Any explication

Thanks,

[watson]

The Node.js agent currently does not support automatic instrumentation of Oracle queries. You can see a list of all supported modules here on our Compatibility page.

I can understand from your Discuss post that you're using the oracledb package. We would have to add support for that to automatically instrument your Oracle queries.

Though not as elegant, for now you can manually trace your Oracle queries by using our Custom Span API.

[ridakaddir]

thanks watson for the explanation, did you planned the oracledb support ?

[watson]

It's not on our roadmap at the moment. But I'll make sure to bring it up with the team at the next planning meeting

[watson]

For now please leave this issue open 😃

[Adizbek]

Has anyone found solution or workaround ?

[ridakaddir]

as @watson, you can manually trace your Oracle queries by using Custom Span API https://www.elastic.co/guide/en/apm/agent/nodejs/current/custom-spans.html

[FedeOmoto]

Hi,

Is it a planned feature to have automatic instrumentation of Oracle queries when using the oracledb package? If that is the case, any ETA?

Thanks!

[astorm]

@FedeOmoto We don't have any immediate plans to add automatic instrumentation of oracle queries at this time, but we'll pass on the feature request. Also (as always) we're super open to a PR from the community to add this functionality. Is there a specific npm oracle library that you're using/interested in?

In the meantime, we do have a relatively straight forward API for starting individual spans. While it's not as nice as automatic instrumentation, manual instrumentation of your queries is one solution if you're using oracle right now.

[sk8federico]

+1

[pszemesy]

+1