How do I detect a Vertica Analytic Database?

[#1]

Symptom

JDBC calls to a Vertica database are not being seen by AppDynamics. What can be done?

Solution

Use the following node propeties and values:

jdbc-prepared-statements = com.vertica.jdbc.SPreparedStatement,com.vertica.jdbc.VerticaPreparedStatement

jdbc-callable-statements= com.vertica.jdbc.SCallableStatement

jdbc-statements = com.vertica.jdbc.SStatement,com.vertica.jdbc.VerticaStatement

jdbc-connections = com.vertica.jdbc.VerticaConnection,com.vertica.jdbc.SConnection,com.vertica.jdbc.SConnectionHandle

 
For more details, see Using Node Properties to Detect JDBC Backends.