tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "苗启广" <...@souvenirchina.com>
Subject Re: Re: Oracle connection pooling
Date Sat, 09 Aug 2003 08:48:23 GMT


 2003-08-09 00:07:00 д
>Hi,of you ? Could you tell me ? Thanks~~ 
>
>Firewalls, and I'm not speaking for all of them, as a rule of thumb close
>_idle_ connections after an hour.
>
>Your connections should be done well before that.
>
>-e
>
>On Fri, 8 Aug 2003, Cristopher Daniluk wrote:
>
>> We are running a fairly large ecommerce site consisting of 3 apache
>> 2.0.48 servers being balanced between using UltraMonkey/ldirector and 2
>> tomcat servers with AJP1.3. Everything is Linux except the back end
>> which is a fairly hefty and firewalled Sun running Oracle8i.
>>
>> The webapps build a connection pool to oracle via the oracle.jdbc.pool.*
>> connection pool. The pool instantiates fine and everything is great, but
>> gradually the pool begins to break down. Idle connections are closed by
>> Oracle (not sure if its oracle itself or the fw..), but the oracle pool
>> doesn't figure it out. If someone happens to get the dead connection,
>> Tomcat completely hangs on all threads until the session-timeout
>> expires. Even the session replication code stops and the apache servers
>> and the other tomcat in the cluster mark it offline. During the peak
>> traffic it isn't so bad but at the end of the day after load goes back
>> down, it's a big problem.
>>
>> We initially used DBCP but it didn't work for crap with Oracle. Is there
>> a better pool to use with Oracle and Tomcat in a cluster environment and
>> if not, is there a way we can get the Oracle pool to recycle some of
>> these bad connections without blowing up the server?
>>
>> Thanks,
>>
>> Cris Daniluk
>>
>> ---------------------------------------------------------------------
>> 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
>
>
                                 mqg 

- SOUVENIR ----------- --------.
| Souvenir of China     |
| A Good Place for You  |
`--> http://www.souvenirchina.com -'
mailto:sales@souvenirchina.com




Mime
View raw message