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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] > 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 > [EMAIL PROTECTED] > Certified Java Web Component Developer > Certified Delphi Programmer > SBD Consultants > http://www.sbdconsultants.com > > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
