Howdy, We had similar problems and did the same switch as Mark, with good results. But we also have other apps using DBCP with Oracle that work just as well.
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Mark [mailto:[EMAIL PROTECTED] >Sent: Saturday, August 09, 2003 11:11 AM >To: Tomcat Users List >Subject: Re: Oracle connection pooling > >For what it's worth... in a webapp I wrote for my company we had flaky >connection problems when using >oracle.jdbc.pool.OracleConnectionPoolDataSource against 8i. I switched to >oracle.jdbc.pool.OracleConnectionCacheImpl and all the problems magically >disappeared (much to the delight of our dba's). > >http://otn.oracle.com/doc/oracle8i_816/java.816/a81354/samapp9.htm > > > >At 8/8/2003 11:50 PM, you 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: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
