tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roberts, Eric" <Eric.Robe...@one.at>
Subject RE: DataSource.getConnection() hangs
Date Fri, 07 Feb 2003 11:54:24 GMT
Hi Maris

I don't use a validation query at all and mine works!

I'm using Oracle - maybe different databases have different "features" when working with DBCP
;-))

-----Original Message-----
From: Maris Orbidans [mailto:M.Orbidans@datapro.lv]
Sent: Freitag, 07. Februar 2003 12:37
To: Tomcat Users List
Subject: RE: DataSource.getConnection() hangs



I solved it too. But it seems that mine problem was caused by empty pool validation query
string.

thanx
Maris


> -----Original Message-----
> From: Sean Dockery [mailto:sean@sbdconsultants.com]
> Sent: Wednesday, February 05, 2003 7:27 PM
> To: Tomcat Users List
> Subject: RE: DataSource.getConnection() hangs
> 
> 
> Very very cool thing to know.  I've seen this behavior before 
> but never 
> knew what was causing it.
> 
> At 14:11 2003-02-05 +0100, you wrote:
> >Hi,
> >
> >I had this problem a while ago.
> >
> >Mine was caused by DBCP attempting to open a pool of Db 
> connections when 
> >receiving the first getConnection() request - and my Db was 
> not configured 
> >to handle that many connections - and it just hung waiting for the 
> >maxActive value to become available.
> >
> >I omitted minIdle and maxActive parameters so that they 
> defaulted (in my 
> >case 4 and 2) then it worked. I then got my DBA to 
> reconfigure his startup 
> >parameters to something realistic.
> >
> >HTH
> 
> Sean Dockery
> sean@sbdconsultants.com
> Certified Java Web Component Developer
> Certified Delphi Programmer
> SBD Consultants
> http://www.sbdconsultants.com
> 
> 
> 
> ---------------------------------------------------------------------
> 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


Mime
View raw message