tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Noel <ericn...@mylife.ph>
Subject Re: Limit time for Database connection
Date Fri, 09 Jul 2004 00:25:56 GMT
On 7/9/2004 8:11 AM, Robert F. Hall wrote:
> Elisabeth,
> 
> Nobody has responded to your question (that I've seen), so I'll "take a 
> shot".
> 
> This sounds like a network issue, and network connection failures have 
> to "time out"
> before they fail.  Using a timed separate thread to obtain the 
> connections for the pool
> occurs to me; if the connection thread doesn't return in a certain 
> amount of time the
> parent thread could throw an Exception.
> 
> Has anybody tired something along these lines?  Is this suggestion way 
> off base?
> 
> Regards,
> Robert
> 
> 
> Bachler, Elisabeth (Elisabeth) wrote:
> 
>> Hello,
>> I defined a database connection that uses a pool connection. 
>> Everything is
>> working well.
>> Now I had a routing problem that prevented any database connection 
>> (with a
>> SQPNestedException fired). The exception fired after a long time.... is
>> there a way of setting the connection limit, so it does not take so long
>> before firing the exception?
>>
>> Thanks
>> Elisabeth
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>  
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 
I thought it would be just as simple as setting the parameter in the DBCP???

<parameter>
       <name>maxWait</name>
       <value>10000</value>
</parameter>

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


Mime
View raw message