#support

Disabling "?" in SQL Criteria for App

TLDR Sanjiv asked how to disable "?" in SQL criteria. vishal-signoz suggested checking the instrumentation library. Ankit provided a solution using OTEL_INSTRUMENTATION_COMMON_DB_STATEMENT_SANITIZER_ENABLED.

9mo

Join the chat

Mar 02, 2023 (9 months ago)

Photo of md5-914a8b39b82fd99b8ecd985427660deb

Sanjiv

08:01 PM

The demo app has the full SQL however in my app the values in the sql criteria are replaced by “?”. Is there a way to disable the ? and have the actual value?

Image 1 for The demo app has the full SQL however in my app the values in the sql criteria are replaced by “?”. Is there a way to disable the ? and have the actual value?

Mar 03, 2023 (9 months ago)

Photo of md5-f936d3e5743d23344d6c60813189716f

vishal-signoz

12:24 AM

Depends on how you have instrumented, if you have auto instrumented then check on the instrumentation library.
If you are manually instrumenting then set sql.query attribute in the span.

Photo of md5-dbe7088320fe1d922707613e02f3420d

Ankit

04:54 AM

Sanjiv you can disable OTEL_INSTRUMENTATION_COMMON_DB_STATEMENT_SANITIZER_ENABLED as in docs https://opentelemetry.io/docs/instrumentation/java/automatic/agent-config/#db-statement-sanitization

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 1023 threads (61% resolved)

Join Our Community

Similar Threads

Unable to Monitor jdbc_connections_active Metrics in SigNoz

Ragulraj is unable to monitor jdbc_connections_active metrics with SigNoz despite modifying configurations and adding dependencies. Srikanth provided troubleshooting steps and info on alternatives, but the issue remains unresolved.

8mo

Filling in Method for Traces in Go Instrumentation

Timothy asked about filling in the method for traces in Go. vishal-signoz identified a workaround by changing the spankind to Internal, and shared a PR for the fix.

10mo

Signoz and Opentel Tracing Issue in Golang Application

Himanshu is having issues with tracing graphql queries and mongoDB calls in their Golang application using Signoz and Opentel. vishal-signoz asked about the former's instrumenting process but the issue has not been resolved.

3mo