Have written custom resource adapter to connect to EIS i.e. Oracle coherence data source.
Using jboss connection pool. I observed that inuseconnectioncount keep increasing.
the time server started: jmx-console showed:
Inuse connectioncount 0
after opening same application from multiple windows around 12 reports ran in parellel. then
Inuse connectioncount 10
problem is if this inusecount keep increasing, it will fill out the pool.
I have using just con.close to close the connection with assumption that it will get back to pool.
Please help: Its urgent.
Normally this is because you forgott lose, maybe in some special conditions.
I'm not sure whether the CCM (CacheConnectionManager) help here, you can enable error/debug for it to track if a invocation does not close the connection.