How do I capture database calls when using MariaDB client?

[pclark]

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-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:

• App Agent Node Properties
• jdbc-callable-statements
  
  

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"

[Jon.Rigual]

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]

Thanks for sharing @Jon.Rigual!