List of supported JDBC drivers

ben-kletzine-by · March 19, 2021, 9:21pm

I have a java application working with the apm agent. I have two datasources configured, one of SqlServer dialect, the other being Snowflake https://www.snowflake.com/

I see transactions reported for the sql server queries but nothing when it comes to queries for snowflake. Based on this code

github.com

elastic/apm-agent-java/blob/master/apm-agent-plugins/apm-jdbc-plugin/src/main/java/co/elastic/apm/agent/jdbc/helper/ConnectionMetaData.java

/*-
 * #%L
 * Elastic APM Java agent
 * %%
 * Copyright (C) 2018 - 2020 Elastic and contributors
 * %%
 * Licensed to Elasticsearch B.V. under one or more contributor
 * license agreements. See the NOTICE file distributed with
 * this work for additional information regarding copyright
 * ownership. Elasticsearch B.V. licenses this file to you under
 * the Apache License, Version 2.0 (the "License"); you may
 * not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the

This file has been truncated. show original

I'm guessing its just not supported/instrumented? Looking for recommendations on how to proceeed.

This is the driver I'm using for snowflake

net.snowflake.client.jdbc.SnowflakeDriver
which can be found here
https://mvnrepository.com/artifact/net.snowflake/snowflake-jdbc/3.13.1

Thanks!

Eyal_Koren · March 21, 2021, 11:15am

Hi and welcome to our forum!

Transactions are the initial span of a request-handling flow in a monitored service. I assume you mean - you can see trace data, but not the snowflake query span?

We support JDBC at the API level, so you should see such queries. Although we don't have a dedicated parser for this driver's connection strings, we should still apply the UNKNOWN parser, so I would expect you'd see related spans, only without the address details.

Please set log_level to debug and upload the log from the startup of the app (removing sensitive information).

Topic		Replies	Views
Java APM : Public API + JDBC Driver APM java	5	443	March 13, 2023
Java APM Agent does not send spans for database queries and error.* document APM	9	874	January 27, 2019
Apmsql is not tracking my sql queries APM	3	468	November 7, 2022
SQL Spans with DB2 (JDBC 4) APM java	3	780	December 16, 2019
Not receiving Transaction/span from java APM APM java	4	598	October 19, 2021

List of supported JDBC drivers

Related topics