|
Wed May 14 10:57:19 BST 2008 |
| |
Hey,
When we specify the "queueConnectionRequests" to true then connection requests are queued. If connection is not available inside pool it waits infinitely.
Is there any way to specify timeout period for this kind of wait?
To be more clear about my requirement lets say we have setted queueConnectionRequests = true. And lets assume all pooled connection are in use, now some more request comes to the pool then those request will be queued up till some connection is available. This may lead to infinite waiting if connections are not available since long period [infinite] of time. We want to control this waiting though some configuration parameter.
- Amit Goyal |
| |
| sedj |
Wed May 14 19:52:57 BST 2008 |
| |
I think you're better off upping the the number of connections available to the pool.
If you set queueConnectionRequests = true, its only meant to be a stop-gap for exceptional and extraordinary load ... if you experience this kind of throttling on a frequent basis, you should up the size of the pool. If you're DB is unable to cope with this, you should look into DB clustering, or upgrade your server. Setting a timeout for queueing is not really a solution in my opinion. |
