cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pclark
AppDynamics Team (Retired)

Updated on 9/5/18

Question

My application uses a MariaDB client. It uses c3pO JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension. How do I capture database calls?

 

Answer

For MariaDB client 1.4.4

We do not support MariaDB clients out of the box. You will need to set up the below jdbc node level properties to achieve the DB queries. 

JDBC_Properties.png

 

jdbc-callable-statements=org.mariadb.jdbc.AbstractCallableFunctionStatement,
org.mariadb.jdbc.AbstractCallableProcedureStatement,
org.mariadb.jdbc.internal.util.dao.CloneableCallableStatement


jdbc-prepared-statements=org.mariadb.jdbc.AbstractMariaDbPrepareStatement

jdbc-connections=org.mariadb.jdbc.MariaDbConnection

jdbc-statements=org.mariadb.jdbc.MariaDbStatement

 

Please refer to the documents below for instructions on how to set node level properties and additional details about these properties:

For MariaDB client <1.4.4

Note: This solution dates from January 2015.

 

Refer to the instructions in Using Node Properties to Detect JDBC Backends and try using the following JDBC node properties and values:

 

jdbc-callable-statements: value="org.mariadb.jdbc.MySQLCallableStatement"
jdbc-connections: value="org.mariadb.jdbc.MySQLConnection"
jdbc-prepared-statements: value="org.mariadb.jdbc.MySQLPreparedStatement,org.mariadb.jdbc.MySQLServerSidePreparedStatement"
jdbc-statements:
value="org.mariadb.jdbc.MySQLStatement"

 

Comments
Jon.Rigual
Discoverer

I found these values to work for MariaDB Client 2.2.6

 

jdbc-prepared-statements=org.mariadb.jdbc.BasePrepareStatement
jdbc-connections=org.mariadb.jdbc.MariaDbConnection
jdbc-callable-statements=org.mariadb.jdbc.CallableFunctionStatement
jdbc-callable-statements=org.mariadb.jdbc.internal.util.dao.CloneableCallableStatement
jdbc-callable-statements=org.mariadb.jdbc.CallableProcedureStatement
jdbc-statements=org.mariadb.jdbc.MariaDbStatement
Nina.Wolinsky
Community Manager

Thanks for sharing @Jon.Rigual!

Version history
Last update:
‎09-07-2018 03:22 PM
Updated by:
On-Demand Webinar
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.


Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!


Read the blog here