This sounds like poor coding to me. Your application should get the connection object from the pool and immediately release when done. Having an application hold onto a connection (especially in client/server) world is bound to cause you to run out of connections or reach timeouts.
On 5/2/06, Michal Fleischhans <[EMAIL PROTECTED]> wrote:
Hi all, I have a problem with connection pooling. Example: - about 30 applications using the pool - each application uses 1 DB username/password (30 users) imagine following situation: Only 1 application works hard, the others do nothing. This application takes for example 80% of all possible connections to the DB, store them in a pool and reuses them too often. The other 29 applications become fully loaded BUT they have only 20% of resources (possible connections) together, becouse the first application still holds and reuses the 80% of connections. Is there any way how to manage this problem, so that all applications have the same amount of resources when they all are fully loaded ? To tell JDBC pool that every DB user (application) can use only 1/30 of possible connections doesn't resolve the problem, because when only one application is working, it's using only 1/30 of possible connections even if the other 29/30 are free to use. thanks in advance Michal, Bno - Czech Republic --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Marc Farrow