db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Caserta <smoothie...@yahoo.com>
Subject RE: Could not retrieve connection info from pool - DB2
Date Wed, 14 Dec 2005 16:15:00 GMT
Thank you Thomas..

Is it also a good idea for me to set the initialSize
to 20 or 30? Does that help or hinder?? 

--- Thomas Fischer <fischer@seitenbau.net> wrote:

> 
> 
> 
> 
> Hi,
> 
> if you have 20 concurrent users, you pool should at
> least allow for 20
> active connections. I would rather use 50 if I were
> you. You should also
> increase maxIdle accordingly, again use at least 20
> for it. You might also
> want to check that the database itself allows at
> least (maxIdle +
> maxActive) concurrent connections.
> Then, you can also set how the pool behaves when it
> hits a limit. I believe
> you can instruct the pool to simply wait for a freed
> connection instead of
> throwing an error. Read the dbcp property guide at
>
http://jakarta.apache.org/commons/dbcp/configuration.html
> 
>    Thomas
> 
> Jim Caserta <smoothie_jc@yahoo.com> schrieb am
> 14.12.2005 16:40:39:
> 
> > Hi,
> >
> > I'm now using version 3.2 RC2 and I'm receiving
> the
> > following:
> > Could not retrieve connection info from pool.
> >
> > My property file has the following:
> > torque.defaults.pool.maxIdle = 8
> > torque.defaults.pool.maxActive = 10
> > torque.defaults.pool.maxWait = 10000
> >
> torque.defaults.pool.timeBetweenEvictionRunsMillis=
> > 300000
> >
> >
> > Since I wil have approx 20 users hitting my app at
> the
> > same time, I'm not sure what to set these to, or
> is
> > there a default I'm not setting??
> >
> > Thank you for any help!
> > Jim
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
> >
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message