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 10:54:02 GMT
  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