I have setup a datasource and pool in my jsp page using postgresql.
Then in JMX MBean View, when i go to jboss.jca > name=PostgresDS,service=ManagedConnectionPool (which is my datasource). Then i fire up some connections in my browser to test, but if i look under InUseConnectionCount, it still says 0, even though i have some connections open, i set my minsize to 5 and max to 20. Why do i still see 0 in InUseConnectionCount? Is it perhaps my connetcions close to quickly for me to see? Or am i looking at the wrong thing to see how many connections are open?
You do have to keep your application busy to see the InUseConnectionCount be other than 0. I use JMeter to simulate a load and then I can see InUseConnectionCount set to something other than 0.