tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "albert quinn" <albertber...@gmail.com>
Subject Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
Date Fri, 30 Nov 2007 11:38:11 GMT
  Hi for the n-th time ! :

  I've set up testWhileIdle="true" and
timeBetweenEvictionRunsMillis="2400000". I'll try again in about an
hour with this new setup and I'll come back if the new setup give me
any new information.



2007/11/30, albert quinn <albertbertal@gmail.com>:
>  Hi again :
>
>  I've read the URLs about DBCP configuration. Then, I've set up DBCP
> for my connection pool. I've added a validation query and I've set
> testOnBorrow="true". I've tried again and I've achieved the same
> strange behaviour : after about and hour of inactivity, it waits
> forever in the 3th line. No errors reported in the Tomcat logs.
>
>  Any idea of what's happening or what can I do to know what's
> happening?. Thanks in advance.
>
> Albert
>
>
>
> 2007/11/29, albert quinn <albertbertal@gmail.com>:
> >  Hi once more time :
> >
> >  Thanks again for your help. Sorry, I didn't know the connections
> > aren't really closed. I've to leave now, but I'll read the URLs you
> > gave me tomorrow and then, I'll try to set up DHCP properly.
> >
> >  Thanks a lot. I'll come back if I get any kind of new information
> > about the mistery.
> >
> >
> > Albert
> >
> >
> >
> >
> >
> >
> > 2007/11/29, Mark Thomas <markt@apache.org>:
> > > albert quinn wrote:
> > > >   Hi again, Mark :
> > > >
> > > >   I've benn thinking about the problem and I don't really think it
> > > > could be a problem with database connection timeout due to inactivity
> > > > because when the web service is called, the web service gets a
> > > > connection from the pool, it uses the connection, and then it closes
> > > > the connection before returning the web service results. So, it
> > > > mustn't be a problem with database connection timeout due to
> > > > inactivity, don't you think?
> > >
> > > No. I disagree with your analysis. The point of DBCP is that the
> > > connections aren't closed. When you call close() in your code that just
> > > returns the connection to the pool. The actual database connection remains
> > > open.
> > >
> > > The URL you want is:
> > > http://commons.apache.org/dbcp/configuration.html
> > >
> > > The starting point for DBCP is
> > > http://commons.apache.org/dbcp/
> > >
> > > Mark
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To start a new topic, e-mail: users@tomcat.apache.org
> > > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > > For additional commands, e-mail: users-help@tomcat.apache.org
> > >
> > >
> >
>

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message