tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Justin Ruthenbeck <just...@nextengine.com>
Subject Re: Limit time for Database connection
Date Fri, 09 Jul 2004 01:27:27 GMT

See my previous post on the thread.

Combined with "testOnBorrow" and/or "testWhileIdle", it could certainly 
help.

justin


At 05:56 PM 7/8/2004, you wrote:
>Could be, anyone know for sure?
>
>Eric Noel wrote:
>
>>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
>>
>>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
>>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


______________________________________________
Justin Ruthenbeck
Software Engineer, NextEngine Inc.
justinr - AT - nextengine DOT com
Confidential. See:
http://www.nextengine.com/confidentiality.php
______________________________________________


---------------------------------------------------------------------
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