Hi All,
We are using the konakart for an online eCommerce store. We are facing issues with connection usage in MySQL side. For troubleshooting the issue I need to monitor the connection usage from the app server (DBCP Connection Pool). I have tried to get the connection usage using JMX attribute but I failed to get, since the connection usage is not exposed to JMX.
I would like to know your feedback/experience on monitoring the DBCP connection pool usage. Can I get the pool usage by writing a piece of code? The configuration I am using in konakart.properties & server details are given below:
torque.database.store1.adapter = mysql
torque.dsfactory.store1.connection.driver = com.mysql.jdbc.Driver
torque.dsfactory.store1.connection.url = jdbc:mysql://XX.XX.XX.XX:XXXX/XXXX?zeroDateTimeBehavior=convertToNull
torque.dsfactory.store1.connection.user = XXX
torque.dsfactory.store1.connection.password = XXX!
....
# Using commons-dbcp
torque.dsfactory.store1.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
Web Server: Apache 2.2
App Server: Tomcat 7
DB Server: MySQL 5.5
Thanks,
Shaiju B