This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes PooledConnection maximum Limit Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PooledConnection maximum Limit" Watch "PooledConnection maximum Limit" New topic

PooledConnection maximum Limit

Raj Jindal
Ranch Hand

Joined: Jan 17, 2003
Posts: 50
In a web application i am using oracleConnectionPoolDatasource class for implementing the connection pool. I am getting connection in a bean using oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection. means i m getting a pooled connection.
Please let me know what do we mean by setting of min size and max size AND what happens when load on the server exceeds max limit.
Mani Narayanan

Joined: Feb 20, 2004
Posts: 5
By setting connection pooling, one is acheiving a set of ready to use resources to access the database from the resource pool and giving it back to the pool after completing the job. Usually connection pool size should be less than the maximum connections set in your servlet engine. It has been found that lower settings (10-30 connections) perform better than higher (100+) settings. It is strongly recommended that you code your application to use at most one connection per thread. If you do code your application to require "C" concurrent database connections per thread, then your connection pool must support at least:
T * (C - 1) + 1
connections, where "T" is the maximum number of threads.
I agree. Here's the link:
subject: PooledConnection maximum Limit
Similar Threads
sending large files through webservice
Maximum cookie size - Nokia 6600
Specifying number of pooled EJB instances ..Urgent.!
Error in allocating a connection. Cause: In-use connections equal
No ManagedConnections available