File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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
 
wood burning stoves
 
subject: DataSource Connection is not taking connection from the connection pool - new connection is created