wood burning stoves*
The moose likes Websphere and the fly likes WAS6.1 connection pool issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "WAS6.1 connection pool issue" Watch "WAS6.1 connection pool issue" New topic

WAS6.1 connection pool issue

Richard Vagner
Ranch Hand

Joined: Jun 26, 2001
Posts: 107
Our web app uses Websphere App server 6.1 and db2 database. We got into a situation where a db2 load job essentially prevented the web application from accessing the database and web application just hung.

The problem is after the db2 load job completed for some time, the web application still hung. It looks like a race condition in connection pooling. I was wondering why the connection pooling is not getting back to normal automatically after the load job is long gone?

Please throw some light on this.

Joseph Hayes

Joined: Jun 02, 2009
Posts: 4
Are you using container managed persistence? If not, it will be application specific, I'm afraid.

If it's container managed, are you eventually getting connection timeout exceptions?

If not, the only possibility that I can think of at the moment is that you're somehow keeping connections active but not doing anything with them. The configuration solution for this (as opposed to the programming solution, which should likely be investigated depending on the impact of the outage) would be to use the "aged timeout" setting in the datasource's connection pool. In admin console, navigate as follows: JDBC providers > [your db2 provider] > Data sources > [your datasource]> Connection pools

Reference here for more detail on this: http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/umj_sesspoolset.htm
Richard Vagner
Ranch Hand

Joined: Jun 26, 2001
Posts: 107
Hi Joseph,

Thanks so much. Actually I was thinking about the same thing: Aged Timeout. However, my collegue said once a connection is being used it would never be aged timeout. IBM doc seems to suggests that the physical connection wil not be discarded if the connection is involved in a transaction when the aged timeout is reached.

Can you give me a snario where we might be keeping connections active but not doing anything with them as you suggested?

I think that maybe our problem.

I agree. Here's the link: http://aspose.com/file-tools
subject: WAS6.1 connection pool issue
Similar Threads
Using DataSource in EJB
iseries journalling question?
data source and connection pooling ?
approach other than connection pooling
Connection Object pointing to Null