Connections - Headed for a Crash?
I am looking at the growing number of connections listed in the Console and I wonder if I am headed for a crash.
I am running version 220.127.116.11 on Solaris with Oracle 10g as the database. I have a web app written in Java running on WebSphere. The web app has an EJB that connects to MDM once (first page view) and then reuses that connection until ejbRemove() is called. The ConnectionAccessor is set by calling ConnectionPoolFactory.getInstance(hostname);
The app is running on 2 app servers.
What is confusing to me is that the list of connections in the Console is growing since we went live on Saturday night (about 164 as of now, with 52 showing Last Activity Time on today).
So, will MDM crash?
Also, should I use SimpleConnectionFactory instead?
Or, should I be changing the timeout and max connection values before calling ConnectionPoolFactory.getInstance(hostname)?
Any help/advice will be greatly appreciated.
Thanks in advance.