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

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

From	Wojtek <nowhere@a.com>
Newsgroups	comp.lang.java.programmer
Subject	Re: The easiest framework for Java Database applications development released for production use
Date	2011-02-07 20:51 -0800
Organization	NewsGuy - Unlimited Usenet $19.95
Message-ID	<mn.3ce37db2e6aca6cf.70216@a.com> (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>

Show all headers | View raw

yaormaAdmin wrote :
> Often in large projects someone, somewhere, inevitably forgets to
> close the Statement and/or the Resultset in a finally block where an
> exception is thrown.  This results in a cursor being left open in the
> database.  Eventually the code is executed enough times to exhaust the
> maximum number of cursors allowed for the connection.  The next call
> that opens a cursor in the database fails.  This is often not the
> offending code but some perfectly good code that exists in some other
> far off place in the code.

Or you could just use a connection pool manager such as proxool. Use 
proxool to log into the database and then it manages all of that. DB 
connections which are idle for a given number of milliseconds are 
automatically closed. So all of the extra coding to fit yet another 
framework is not needed

Plus you get far better DB performance under load as you do not need 
the expensive connection establishment for every DB operation.

-- 
Wojtek :-)

Back to comp.lang.java.programmer | Previous | Next — 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

csiph-web