wood burning stoves 2.0*
The moose likes Websphere and the fly likes Connection Pooling - causes Hang up the Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Connection Pooling - causes Hang up the Server" Watch "Connection Pooling - causes Hang up the Server" New topic
Author

Connection Pooling - causes Hang up the Server

KasiMurugan Ramasamy
Ranch Hand

Joined: Jan 30, 2005
Posts: 125
Hi Friends,

We are encountering a problem in Websphere Connection Pooling.
We have set max connection as 10.

In a While loop we are calling a method which updates database. We are closing the connection in that database method at end.


If the while exceeds 10 iteration, we are facing the server hang up. It seems the close connection doesn't return connection immediately to the connection pool.

Please tell me, what could be the problem?. Is there any setting we have to change.


Thanks & Regards
Kasimurugan (SCJP1.4, SCBCD1.3), Preparing SCWCD1.4
Joe Matthew
Ranch Hand

Joined: Jun 10, 2008
Posts: 66
I cannot be but sceptical about this code. Why do you want 10 connections? There is no guarantee that you will be taking only 10 connections or that when you close the connection, it would go back to the pool.

The question I have is whether you really require to open the connection in the called function. Open one connection for all your transactions and one you are done with it, close it. To effectively utilize the pooling of the App Server, you will be needed to code within its limits.

You can definitley increase the connections from 10 to how many you want. But that will not solve this problem.

No solution, but redesign!


Regards,<br />Joe<br /> <br />"Always program as if the person who will be maintaining your program is a violent psychopath that knows where you live."<br />--Martin Golding
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Pooling - causes Hang up the Server