This repository has been archived by the owner on Jul 31, 2023. It is now read-only.
In this release, we've added an option to allow spans to be annotated with the SQL statement that they are running with.
This option is called Observability.OPTION_ANNOTATE_TRACES_WITH_SQL
Exhibit
Before
package io.opencensus.tutorial.ocjdbc;
import io.opencensus.ocjdbc.Connection;
import io.opencensus.ocjdbc.Observability;
public static void main(String ...args) {
java.sql.Connection originalConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/repro?user=root&useSSL=false&serverTimezone=UTC");
// Then create/wrap it with the instrumented Connection from "io.opencensus.ocjdbc".
java.sql.Connection conn = new Connection(originalConn);
}
After
package io.opencensus.tutorial.ocjdbc;
import io.opencensus.ocjdbc.Connection;
import io.opencensus.ocjdbc.Observability;
public static void main(String ...args) {
java.sql.Connection originalConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/repro?user=root&useSSL=false&serverTimezone=UTC");
// Then create/wrap it with the instrumented Connection from "io.opencensus.ocjdbc".
java.sql.Connection conn = new Connection(originalConn,
// And passing this option to allow the spans
// to be annotated with the SQL queries.
// Please note that this could be a security concern
// since it could reveal personally identifying information.
Observability.OPTION_ANNOTATE_TRACES_WITH_SQL);
}