Crap! I think I’ve got a bug hidden deep down in my code somewhere. I’m working on a project that uses JBoss for the web-container and Oracle as my db.
I’ve got my db connection parameters set (min=5, max=100, IdleTimeoutMinutes=5). I bounced my server about 36 hours ago and am seeing my AvailableConnectionCount steadily going down from 100 to 53 while my ConnectionCount has worked it’s way up to 48.
Thanks to the greatness of the JBoss JMX MBean Inspector I’m able to see all this information, live. I’m pretty certain that their is a bug somewhere because my ConnectionCreatedCount is 87, but with the ConnectionCount at 48 I can see some of my connections are making it back into the “available” pool.
Anybody got any ideas how I should go about tracking the bug down?