wood burning stoves 2.0*
The moose likes JDBC and the fly likes DataSource Connection is not taking connection from the connection pool - new connection is created 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 » Databases » JDBC
Bookmark "DataSource Connection is not taking connection from the connection pool - new connection is created" Watch "DataSource Connection is not taking connection from the connection pool - new connection is created" New topic
Author

DataSource Connection is not taking connection from the connection pool - new connection is created

ravisha andar
Ranch Hand

Joined: Feb 25, 2011
Posts: 55
Hi All,

I have configued a datasource in WAS 7.0

But the server is creating a new connection for each request and throws the error Connection not available while invoking method createOrWaitForConnection for resource after the maximum connection limit is raeched.

The connection is not getting created from the connection pool.

My connection pool Configurations

Maximum Connections : 200
Minimunm Connections : 50

Can anybody please help me with this !!!
Why is the connection getting created each time even though I close the connection.

I am using Spring JDBC Template which closes the connection


Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DataSource Connection is not taking connection from the connection pool - new connection is created