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 <[EMAIL PROTECTED]>: > 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 <[EMAIL PROTECTED]>: > > 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 <[EMAIL PROTECTED]>: > > > 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: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]