How to retrieve JIRA DB connection numbers? ("numactive" "numidle")

[mahaao]

Hi,

I have a question about how to get the db connection pool numbers for JIRA 4.4.4.

In previous version (e.g. 4.1.2), we can use jmx api to check "datasource" information in mBeans.

But after we upgrade JIRA from 4.1.2 to 4.4.4, now all "Active Connection number, Idle Connection number,Total Connection number" are all zero in databasource of mBeans from JMX.
We fount out JIRA 4.4.4 is using new db configuration, "dbconfig.xml".

We already know that JIRA 5.1 supply this feature on Admin panel:
https://confluence.atlassian.com/display/JIRA/Monitoring+Database+Connection+Usage

Where can we retrieve JIRA DB connection numbers on JIRA 4.4.4?

BR

[Florian Zink]

Hi,

maybe in MBeans -> com.atlassian.jira -> BasicDataSource -> Attributes -> NumActive/NumIdle ?

It works for me (JIRA 5.1.5)

Cheers