Slow SQL traces not received in the expected section from New Relic Java agent

[devleifr]

Description

I'm experiencing an issue with the New Relic Java agent where Slow SQL traces are not shown in the New Relic dashboard. I can see these SQL-connected traces under Monitor > Transactions and they are categorized under the .other segment.

Additionally, I did not find any enable/disable option for Slow SQL traces like those available in other language agents.

Expected Behavior

Slow SQL traces should appear in the New Relic dashboard under the Monitor > Databases > Slow SQL traces section.

Troubleshooting

The Slow SQL traces section is empty:

SQL-connected traces under Monitor > Transactions:

Steps to Reproduce

Specify your license key under the NEW_RELIC_LICENSE_KEY variable in docker-compose.yml.
Then run docker compose up --build.

java_nr_sql_repro.zip

Environment Details:

• Java version: 16
• New Relic agent version: 8.12.0
• PostgreSQL driver version: 42.7.3
• PostgreSQL: 13.1

[workato-integration]

https://new-relic.atlassian.net/browse/NR-279519