Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I capture database calls when using MariaDB client?

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"

 

Version history
Revision #:
8 of 8
Last update:
‎09-07-2018 03:22 PM
Updated by:
 
Labels (1)
Tags (1)
0 Kudos
Comments
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

Thanks for sharing @Jon.Rigual!