Guest User

hi. While using the JENNIFER 4.6.1, I do not see the recent DB connection. I am using Spring/Mybatis.
connection_trace_class = com.mysql.jdbc.ConnectionImpl
jdbc_connection_get=org.apache.ibatis.transaction.Transaction.getConnection();com.mysql.jdbc.ConnectionImpl.nativeSQL();com.mysql.jdbc.LoadBalancedMySQLConnection.nativeSQL();com.mysql.jdbc.ReplicationConnection.nativeSQL();com.mysql.jdbc.jdbc2.optional.ConnectionWrapper.nativeSQL()
Please see the setting above. When I go to the monitoring→ real time status→ DB, the number of recent connection is well recorded as 5 to 10. But a certain items including Allocated or Active continue to be shown as 0. I need your help on this.

Khalid Saeed

You do not input the nativeSQL() at jdbc_connection_get.
Please apply either com.mysql.jdbc.LoadBalancedMySQLConnection or om.mysql.jdbc.ReplicationConnection on connection_trace_class.

Guest User

Hi. As you put it, I applied another class at the connection_trace_class. But I could not see even the idle message. I searched the nativeSQL with finder.sh, and applied the class name on it.
com.mysql.jdbc.ConnectionImpl
com.mysql.jdbc.LoadBalancedMySQLConnection
com.mysql.jdbc.ReplicationConnection
com.mysql.jdbc.jdbc2.optional.ConnectionWrapper

what else I need to check?

Khalid Saeed

Have you applied it to each class one by one? If so, please add com.mysql.jdbc to profile_prefix. Then, let me know the profile. You need to restart the software. As large amounts of profile will be stacked, please take off the profile.