james-server-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kenny Smith <jakarta-ja...@journalscape.com>
Subject Re: How many DB connections do you use?
Date Mon, 05 May 2003 20:51:29 GMT
Thanks, Noel. I'll just keep watching it and increasing the number as 
needed.

Kenny Smith

Noel J. Bergman wrote:
>>It was the one mentioned in the config.xml file...
>>"SQLException: Giving up... no connections available."
> 
> 
> OK, that is from the database interface.
> 
> The default is to have 20 connections.  They are shared by the default of 10
> spool threads, 30 connections per protocol, and the RemoteDelivery
> thread(s).  As you can see, you've got 71+ threads competing for 20 database
> connections.  Usually that is OK, since the database layer will wait a bit
> for an available connection, but if everyone starts hogging connections for
> longer than expected, you can run into the above message.
> 
> 	--- Noel
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
> 
> 



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


Mime
View raw message