Oracle connection pooling

2003-08-14 Thread Cristopher Daniluk
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

Re: Re: Oracle connection pooling

2003-08-14 Thread
ÔÚ 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

Re: Re: Oracle connection pooling

2003-08-14 Thread
ÔÚ 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

Re: Re: Oracle connection pooling

2003-08-14 Thread
ÔÚ 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

Re: Oracle connection pooling

2003-08-14 Thread Eulogio Robles
How do you use these from Tomcat, instead of DBCP? Is there any how-to? Regards, E. Robles On Sat, 09 Aug 2003 11:11:29 -0400 Mark [EMAIL PROTECTED] wrote: For what it's worth... in a webapp I wrote for my company we had flaky connection problems when using

Re: Re: Oracle connection pooling

2003-08-14 Thread
ÔÚ 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

Re: Oracle connection pooling

2003-08-14 Thread Eric J. Pinnell
Hi, 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

RE: Oracle connection pooling

2003-08-14 Thread Shapira, Yoav
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

RE: Oracle connection pooling

2003-08-14 Thread Cristopher Daniluk
. -Original Message- From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] Sent: Saturday, August 09, 2003 12:07 AM To: Tomcat Users List Subject: Re: Oracle connection pooling Hi, Firewalls, and I'm not speaking for all of them, as a rule of thumb close _idle_ connections after an hour

Re: Re: Oracle connection pooling

2003-08-14 Thread
ÔÚ 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

Re: Oracle connection pooling

2003-08-11 Thread Eulogio Robles
I am having these exact problems with DBCP. How do you configure a JNDI database connection pool on Tomcat using these libs? Best regards, Eulogio Robles Metropolis Intercom On Sat, 09 Aug 2003 11:11:29 -0400 Mark [EMAIL PROTECTED] wrote: For what it's worth... in a webapp I wrote for my

Re: Oracle connection pooling

2003-08-10 Thread
ÔÚ 2003-08-08 23:50:00 ÄúдµÀ£º We are running a fairly large ecommerce site consisting of 3 apacheof you ? Could you tell me ? Thanks~~ 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

Re: Re: Oracle connection pooling

2003-08-09 Thread
ÔÚ 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

Re: Oracle connection pooling

2003-08-09 Thread Mark
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

RE: Oracle connection pooling + Tomcat 4.1.12

2003-02-20 Thread pqin
This Guy Thinks He Knows Everything This Guy Thinks He Knows What He Is Doing -Original Message- From: Alexey Yastremskiy [mailto:[EMAIL PROTECTED]] Sent: February 20, 2003 12:04 AM To: Tomcat Users List Subject: Oracle connection pooling + Tomcat 4.1.12 Hi. I've got a problem: I tried

Oracle connection pooling + Tomcat 4.1.12

2003-02-19 Thread Alexey Yastremskiy
Hi. I've got a problem: I tried to setup oracle connection pooling in my tomcat configuration, but didn't succeed. I checked Tomcat docs and Oracle docs to produce this, but nothing helped :( Does anyone have in production such a configuration, using Oracle-implemented connection pooling? Please

RE: Oracle connection pooling + Tomcat 4.1.12

2003-02-19 Thread Mike Jackson
I had problems using oracle connection pooling when I was using transactions. So I scrapped that and went back to poolman. There is/was something funny in the way it was doing things, I'd commit the transaction, but it'd still be dirty or something. As I explicitly set the isolation mode prior

RE: Oracle connection pooling

2002-10-25 Thread Sinclair, Alan (CORP, GEAccess)
Yoav, Did you mean setting maxWait to 0 ? thanks -Original Message- From: Shapira, Yoav [mailto:Yoav.Shapira;mpi.com] Sent: Thursday, October 24, 2002 7:15 AM To: Tomcat Users List Subject: RE: Oracle connection pooling Hi, parameter namemaxActive/name

RE: Oracle connection pooling

2002-10-25 Thread Shapira, Yoav
Hi, Did you mean setting maxWait to 0 ? No. I meant that setting maxActive to 5, maxIdle to 3, and maxWait to -1 does not mean there will be 3 connections on startup. It's up to the connection pool implementation to decide if it wants to pre-create the connections on startup, or not. Some

RE: Oracle connection pooling

2002-10-25 Thread Sinclair, Alan (CORP, GEAccess)
[mailto:Yoav.Shapira;mpi.com] Sent: Friday, October 25, 2002 8:36 AM To: Tomcat Users List Subject: RE: Oracle connection pooling Hi, Did you mean setting maxWait to 0 ? No. I meant that setting maxActive to 5, maxIdle to 3, and maxWait to -1 does not mean there will be 3 connections on startup

RE: Oracle connection pooling

2002-10-24 Thread Shapira, Yoav
Hi, parameter namemaxActive/name value5/value /parameter parameter namemaxIdle/name value3/value /parameter parameter namemaxWait/name

Oracle connection pooling

2002-10-23 Thread Sinclair, Alan (CORP, GEAccess)
All, On Tomcat 4.0.6, I have been trying most unsuccessfully to setup a JDBC connection pool to Oracle, it is driving me to the point of insanity. I copied classes12.jar, commons-collections.jar, commons-dbcp.jar, commons-pool.jar into $CATALINA_HOME/common/lib This is the server.sml snippet