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

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

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

Show all headers | View raw

On Feb 7, 11:51 pm, Wojtek <nowh...@a.com> wrote:
> 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 :-)

Thanks for the comments Wojtek.  In the example code the connection is
instantiated using the DriverManager just to make the example simpler
(and so it stands on its own, without needing additional
dependencies).  The Yaorma framework has been used in several
applications using pooled connections.  Most of this work has used
Tomcat and would only run inside some sort of container.  I'll look
into Proxool more, thanks for the tip.  What would you consider the
gold standard for a connection pool for a desktop/rich client (Swing,
RCP, etc.) application?

Thanks again,
John

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