Cannot capture SQL execution spans when monitoring OceanBase Oracle tenant with SkyWalking (OAP 10.4.0, Java Agent 9.6.0)

[zylpsrs]

I have a Spring Boot application connecting to an OceanBase database using the Oracle tenant mode. I'm using SkyWalking for monitoring with the following versions:

• OAP version: 10.4.0
• Java Agent version: 9.6.0

  datasource:
    dynamic:
      datasource:
        master:
          driver-class-name: com.oceanbase.jdbc.Driver
          url: jdbc:oceanbase://obproxy1::2883,obproxy2::2883,obproxy3:2883/dbtest?serverTimezone=Asia/Shanghai&characterEncoding=utf-8&useUnicode=true&useOraclePrepareExecute=true
          username: xxx
          password: xxx

Problem:

In the generated trace spans, I can see HikariCP/Connection/getConnection and HikariCP/Connection/close, but there is no /execute span – the SQL execution information is not captured.

What I've tried:

I have tried adding the Oracle JDBC plugin (apm-oracle-jdbc-plugin) from the optional-plugins directory, but it still does not capture the /execute spans.

Questions:

1. Does the current version (agent 9.6.0, OAP 10.4.0) support capturing SQL execution information for OceanBase Oracle tenants?
2. Is there any additional or optional plugin (similar to the Oracle plugin) that I need to enable?

Thank you for your help.

[wu-sheng]

We are targeting client(jdbc driver), not your server. I am not familiar with OB, so, pick plugin according to this.

[zylpsrs]

SkyWalking's Oracle JDBC plugin works fine when my app connects to an Oracle database. However, after switching to an OceanBase Oracle tenant (which is protocol-compatible with Oracle) and using the 'com.oceanbase.jdbc.Driver', the '/execute' span disappeared, although HikariCP spans are still present. It seems the OceanBase JDBC driver isn't being intercepted. Does SkyWalking have a dedicated plugin for OceanBase, or is there a way to force-enhance this specific driver class?

[wu-sheng]

We never had contributor from OB company or community. So, it is not supported. You may try to contribute one, or ask helps from them?
I am busy these days recently, so, don't have time to investigate this.