WebSphere Application Server - Re: Unable to get a pooled connection from the datasource

Author

Re: Unable to get a pooled connection from the datasource

Ken Hygh

2005-07-29, 8:09 am

sasitamil2002@yahoo.com wrote:

>Hi me too facing the prob..anyone could resolve this...
>advance thanks
>Tamil.
>
>
There are typically 3 causes for this.

1) the application isn't closing connections and is thus 'leaking' them.
2) the database doesn't have enough 'listeners' for the number of
connections you're trying to open. This generally happens in a clustered
environment, where the database must support #Connections x #Servers.
3) there's a database call that's taking a very long time, and
eventually every configured connection gets into this call and until one
completes, no other threads can get a connection.

#1 is far and away the most common.

Ken