Re: Pool project still active

[Chad La Joie]

Yes, Matt is correct.  In a production enviornment you most likely do 
not want to set your max connections to Integer.MAX_VALUE.  I suggested 
that only because it's functionally equivalent to setting your 
connections to a negative number, which is what was being attempted.

Hope, Matthew wrote:

-----Original Message-----
From: Chad La Joie [mailto:[EMAIL PROTECTED] 
Sent: 25 July 2003 01:07
To: Jakarta Commons Users List
Subject: Re: Pool project still active

So my suggestion, if you want an unlimited number of 
connections is to 
set the max allowable connections to Integer.MAX_VALUE, which 
is really 
the max possible connections you can have open anyways.


I would point out that your DBA may not be too happy about this - every
RDBMS has limits to the number of connections it can have open (and it's a
lot lower than Inteeger.MAX_VALUE). Often it is better to set a limit for
you application lower than this to allow a little headroom for admin users
to get in if there is a problem, I would suggest asking your DBA how many
concurrent connections to the DB would be reasonable...
Obviously if this is for a performance test suite you may actually want to
push it as far as possible to see what those limits are... but I would
discourage any user from actually setting the value to this in a non test
environment*
Matt

* I don't think you meant this but I thought it was a point worth making in
case it was misinterpreted by others as being a good thing to do
 
**************************************************************************
The information transmitted herewith is sensitive information intended only
for use by the individual or entity to which it is addressed. If the reader
of this message is not the intended recipient, you are hereby notified that
any review, retransmission, dissemination, distribution, copying or other
use of, or taking of any action in reliance upon this information is
strictly prohibited. If you have received this communication in error,
please contact the sender and delete the material from your computer.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

--
Chad La Joie
Project Manager                (540) 231-6853
Middleware Services            http://www.middleware.vt.edu
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]