[jboss-user] [Datasource Configuration] - Get user info from DataSource connection

[Steven Bruce]

Steven Bruce [http://community.jboss.org/people/mspbrst2] created the discussion

"Get user info from DataSource connection"

To view the discussion, visit: http://community.jboss.org/message/610236#610236

--------------------------------------------------------------
Is it possible to determine which users are using data pool connections?  Or, which subpools are using pool connections?

My JBoss server connects to an Oracle DB, and currently we are maxing out the data pool connections for a specific data source.  Since we are using subpools, the information that I am receiving from the mbean server attributes for the ManagedConnectionPool does not give me an accurate enough picture of what is really happening.  By this I mean that if the max number of connections for DataSource XYZ is 10, I should have 10 connections for both user A and user B.  But if user A has 8 connections and user B has 8 connections, when I retrieve my InUseConnection count from the ManagedConnectionPool, it tells me that I have 16 in use when my max is 10.  Thus, I would like to be able to tell how many I have per subpool so that I have more information to analyze.

Ideally, I would like to be able to see which oracle users are using the connections, however, if the subpools are defined differently than by usernames, it would also be nice if I could see which subpools are using the connections.
Is this possible?

I'm using JBoss 4.2.3 GA if that helps.

Thanks,
Steven
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/610236#610236]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110615/02327b0a/attachment.html