Investigate capturing DB instance info when using Oracle REST Data Services (ORDS) #2580
Description
It appears that the Java agent is not able to capture DB info when using Oracle REST Data Services. This results in DB instance with unknown names (e.g. Datastore/instance/JDBC/unknown/unknown)
Our existing OracleDB instrumentation is dependent on a specific database query (i.e. "select sys_context('userenv','instance_name') from dual") and if that query returns nothing, we return the instance as unknown.
When using ORDS is appears that we are unable to retrieve the instance info.
The following info was provided to help reproduce this issue:
Tomcat hosts the ORDS webapp (ords.war), which listens for HTTP requests and forwards them to the database’s APEX engine via JDBC.
ORDS: REST Data Services | Oracle Nederland > version: 25.2.2.
Tomcat: Apache Tomcat® - Apache Tomcat 9 Software Downloads > version: apache-tomcat-9.0.100
Application is an Oracle APEX app (Low code) -> Oracle APEX
We should explore the feasibility of capturing the required instance info from ORDS.