Red Hat Bugzilla – Bug 535523
add the ability to monitor rhq database connection usage
Last modified: 2015-02-01 18:25:27 EST
mazz and i did a quick search of libraries that may aide in this effort and he found this -- http://code.google.com/p/log4jdbc/
it seems rather promising overall, but need to do more investigation to see whether it's appropriate. the FAQ mentions that it doesn't have tight integration with datasources -- http://code.google.com/p/log4jdbc/wiki/FAQ
however, i'm thinking i can work around this by following the strategy another user brought up in the forums:
there's also the concern that our use of XA datasources may not be properly supported by this framework. again, more investigation is needed to determine whether this can work.
Note that the postgres plugin does as of rev 4597 (RHQ-2021) provide the number of active backends - which corresponds to the total number of connections to the database.
For oracle... statement logging:
Moving features/improvements to 1.4
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-2209