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

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

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

Show all headers | View raw

Arne Vajhøj wrote :
> On 07-02-2011 23:51, Wojtek 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.
>
> 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.

proxool auto-closes idle connections

-- 
Wojtek :-)

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 Lew <noone@lewscanon.com> - 2011-02-06 22:35 -0500
  Re: The easiest framework for Java Database applications development released for production use Lew <lew@lewscanon.com> - 2011-02-07 09:57 -0800
    Re: The easiest framework for Java Database applications development released for production use yaormaAdmin <yaorma@gmail.com> - 2011-02-07 11:19 -0800
  Re: The easiest framework for Java Database applications development released for production use Lew <lew@lewscanon.com> - 2011-02-07 08:10 -0800
    Re: The easiest framework for Java Database applications development released for production use yaormaAdmin <yaorma@gmail.com> - 2011-02-07 09:32 -0800
  Re: The easiest framework for Java Database applications development released for production use yaormaAdmin <yaorma@gmail.com> - 2011-02-07 19:29 -0800
    Re: The easiest framework for Java Database applications development released for production use Arne Vajhøj <arne@vajhoej.dk> - 2011-02-07 22:33 -0500
  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 Arne Vajhøj <arne@vajhoej.dk> - 2011-02-07 18:04 -0500
    Re: The easiest framework for Java Database applications development released for production use yaormaAdmin <yaorma@gmail.com> - 2011-02-07 18:59 -0800
      Re: The easiest framework for Java Database applications development released for production use yaormaAdmin <yaorma@gmail.com> - 2011-02-07 19:18 -0800
  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-06 20:30 -0800
    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 Steve Sobol <sjsobol@JustThe.net> - 2011-02-06 21:54 -0800
    Re: The easiest framework for Java Database applications development released for production use Arne Vajhøj <arne@vajhoej.dk> - 2011-02-07 18:00 -0500
    Re: The easiest framework for Java Database applications development released for production use Lew <noone@lewscanon.com> - 2011-02-07 21:33 -0500
    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
    Re: The easiest framework for Java Database applications development released for production use Lew <noone@lewscanon.com> - 2011-02-07 07:25 -0500

csiph-web