LutzM

JDBC Postgres connection handling

Discussion created by LutzM Champion on Jan 5, 2018
Latest reply on Jan 10, 2018 by Lynn_Williams

Hello all folks,
I try to collect some Backends, SQL metrics data for a Postgres driver (I use postgresql-42.1.4.jar with Oracle Java, build 1.8.0_45-b14). This works in general, the metrics "Average Response Time (ms)", "Concurrent Invocations", "Errors Per Interval", "Responses Per Interval" and "Stall Count" are assigned to the right Backends URL and the SQL statements are collected.
But "Average Result Processing Time (ms)" is assigned to "Unknown Driver" and not to the URL (the JDBC connection).

 

The Tech-Note TEC616386 explain how the names/SQL Statements are detected, but I can't find a hint how to fix my problem, how to assign all metrics to one URL (JDBC connection) only.

 

Any idea what's going wrong with the APM Agents (we use 10.3.0 and 10.5.1), is a postgres specific pbd-file available.

 

Thanks for any suggestion,
Lutz

 

p.s.

See Tech-Note https://support.ca.com/us/knowledge-base-articles.TEC616386.html

Outcomes