Listener won't release connections
Hi,
I'm getting "Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use"
after a few seconds of single user use on my Apex (4.1) application.
Looking at the admin page I can see that the "active" connections have reached the max connections setting.
Problem is, the active sessions counter never reduces. I am just entering the demo app that comes with Apex going into orders and selecting one.
Trying exactly the same on my laptop with local listener and database set up the active connections are released and return to 0 when I do exactly the same.
The JDBC settings are as follows: Inital Pool 3, Min connections 1, max 10, Max statements 10, Inactivity TO 1800, Statement TO 900.
Increasing the max connections simply delays the problem.
Any ideas as to why the connections are not being released back into the pool? Thought it might be something wrong with the Apex install which was done for using the app server, but I can't see anything from the installation guide that helps.
Cheers
Mark