I have a doubt in Connection Pooling. I came to know that we can limit the number of connections in Connection Pool. Is it possible and how? Im using JBoss Application Server. Is it Possible in Weblogic?
Certainly it is possible with WebLogic. Because containers aim to be highly configurable I�m more than sure that JBoss will allow configuring the connection pool size (and not only) as well. In order to configure a connection pool in WebLogic, pick one of the connection pools defined under the Services/JDBC/Connection Pools (see the left tree). On the right panel click on the Connection tab and you�ll be able to reconfigure the pool, setting the initial & maximum capacity, capacity increment, the way prepared statements are cached, etc. There is also an advanced options link that will help you setting more advanced features, like setting the test table, or testing frequency, allowing pool shrinking, etc. Regards.