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

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

Path	csiph.com!eeepc.pasdenom.info!news.pasdenom.info!news.dougwise.org!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!weretis.net!feeder4.news.weretis.net!news.albasani.net!not-for-mail
From	Lew <noone@lewscanon.com>
Newsgroups	comp.lang.java.programmer
Subject	Re: The easiest framework for Java Database applications development released for production use
Date	Wed, 09 Feb 2011 07:55:56 -0500
Organization	albasani.net
Lines	36
Message-ID	<iiu2s1$uvr$1@news.albasani.net> (permalink)
References	<740c95bd-a21f-4ad3-8733-6b3b61e44e18@l18g2000yqm.googlegroups.com> <MPG.27b8fec562e57f9e9897c8@news.justthe.net> <iinp9v$765$1@news.albasani.net> <92e64642-b624-4598-beaa-c57540a30733@k22g2000yqh.googlegroups.com> <mn.3ce37db2e6aca6cf.70216@a.com> <4d51da6f$0$23756$14726298@news.sunsite.dk> <mn.45277db24fddd997.70216@a.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding	8bit
X-Trace	news.albasani.net 9XkR/xmtCIWCyl8ANpcd5KcA4DQqOTLoXeiwm7PGtwxJCt4xXnlG6UeFkrH/PmnjuAaEjcsFSVm3CzcNjukuuA==
NNTP-Posting-Date	Wed, 9 Feb 2011 12:55:29 +0000 (UTC)
In-Reply-To	<mn.45277db24fddd997.70216@a.com>
Cancel-Lock	sha1:vm2X2+Bm4v2FXv/4kZQeq2Zs14o=
User-Agent	Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.13) Gecko/20101208 Thunderbird/3.1.7
Injection-Info	news.albasani.net; logging-data="lJ7zhb7Bpn/ADQXSpdqWvwjDGTI9yh9iVyR91459jKsj+dxFgt00ycXesh1JAhgwPlXDJ1OPgdkoFFDsiJdgw8mqwDaiPObISvykQLdB6MlS8JrVaFD809/h7dH22maU"; mail-complaints-to="abuse@albasani.net"
Xref	csiph.com comp.lang.java.programmer:25898

Show key headers only | 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