Skip to Content
author's profile photo Former Member
Former Member

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 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.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 20, 2007 at 04:16 PM

    Bruce are you creating and using user sessions in your application?

    If so you should destroy them with the DestroySessionCommand when you are done with them.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Bruce,

      I am not aware of any documentation for best practices on MDM connections. There are probably a number of factor you need to take into consideration when setting the min and max number of connections: concurrent load, peak load, socket resource, etc. As for the timeout, it's pretty much what is acceptable for your application. The timeout is how long the API should wait for a response from the server. You can find more information by doing a search on SO_TIMEOUT.

      Currently sessions don't timeout. We are looking into providing a way for sessions to timeout.

      I don't know much about EJB. When are the sessions created, during the bean creation or during activation? As long as you destroy the sessions you created, the entries in the Console should go away.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.