jira.rhq-project.org has been archived and is now in read-only mode.

All issues have been moved to bugzilla.redhat.com. All new issues or updates to existing issues should be made through bugzilla.
Specific old RHQ issues can be found using a query of this form: https://bugzilla.redhat.com/show_bug.cgi?id=RHQ-1999.
New bugs can be raised here. Accounts at bugzilla.redhat.com have been created for existing RHQ users.
Open bugs raised in the last week can be found here.
Issue Details (XML | Word | Printable)

Key: RHQ-2209
Type: New Feature New Feature
Status: Accepted Accepted
Priority: Major Major
Assignee: Joseph Marques
Reporter: Joseph Marques
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
RHQ Project

add the ability to monitor rhq database connection usage

Created: 01/Jul/09 11:12 PM   Updated: 01/Sep/09 09:52 AM
Return to search
Issue 23 of 32 issue(s)
<< Previous | RHQ-2209 | Next >>
Component/s: Core Server, Database
Fix Version/s: 1.4

Time Tracking:
Not Specified

Date of First Response: 27/Jul/09 05:09 AM


 Description  « Hide
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:

http://groups.google.com/group/log4jdbc/browse_frm/thread/706611d1b85e210
http://groups.google.com/group/log4jdbc/browse_thread/thread/21e97eda7a48b033

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.

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Heiko W. Rupp added a comment - 27/Jul/09 05:09 AM
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.

Greg Hinkle added a comment - 31/Jul/09 04:15 PM

Charles Crouch added a comment - 01/Sep/09 09:52 AM
Moving features/improvements to 1.4