Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #25898

Re: The easiest framework for Java Database applications development released for production use

Show all headers | View raw

Arne Vajhøj wrote :
>> It is good advice to use a connection pool.
>>
>> But if you don't close the connections then they
>> are not returned to the pool and the pool will run
>> out of connections very quickly.

Wojtek wrote:
> proxool auto-closes idle connections

After how long?  This is no refutation of Arne's point.

Pretty much every pooling library supports the auto-close of idle connections, 
e.g., DBCP does.  Since all the major ones do, there's no reason to use a 
pooler that lacks the feature.

The default for DBCP is to allow five minutes before calling a connection 
"abandoned".

Under heavy load, abandoned connections can be a problem,  During that five 
minutes (or whatever), a lot of connections can be rejected if all the pool's 
connections are in use or abandoned but not yet auto-closed.  So Arne's advice 
is correct, even in the face of auto-close being enabled.

-- 
Lew
Ceci n'est pas une fenêtre.
.___________.
|###] | [###|
|##/  | *\##|
|#/ * |   \#|
|#----|----#|
||    |  * ||
|o *  |    o|
|_____|_____|
|===========|

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: The easiest framework for Java Database applications development released for production use Wojtek <nowhere@a.com> - 2011-02-07 20:51 -0800
  Re: The easiest framework for Java Database applications development released for production use Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-02-08 20:01 -0400
  Re: The easiest framework for Java Database applications development released for production use Arne Vajhøj <arne@vajhoej.dk> - 2011-02-08 19:08 -0500
  Re: The easiest framework for Java Database applications development released for production use Lew <noone@lewscanon.com> - 2011-02-09 07:55 -0500
  Re: The easiest framework for Java Database applications development released for production use yaormaAdmin <yaorma@gmail.com> - 2011-02-08 05:44 -0800
  Re: The easiest framework for Java Database applications development released for production use Arne Vajhøj <arne@vajhoej.dk> - 2011-02-08 19:06 -0500
    Re: The easiest framework for Java Database applications development released for production use Wojtek <nowhere@a.com> - 2011-02-08 21:59 -0800

csiph-web