Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
Hi, (n+1)-th times !! : I've new information about the Database Connection Pool's mistery. After the last setup, adding testWhileIdle="true" and timeBetweenEvictionRunsMillis="240" it worked nice after about 3 hours of inactivity, but I don't undestand why It seems to work now and it didn't work before. Any ideas about what could be happening here?. Thanks in advance. Albert - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
Hi for the n-th time ! : I've set up testWhileIdle="true" and timeBetweenEvictionRunsMillis="240". 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]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
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]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
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]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
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]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
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? Thanks again for your help. 2007/11/29, albert quinn <[EMAIL PROTECTED]>: > It could be. I'm really lost, and have no idea about what is happening. > > I forgot to tell that, when I call the web service after about an > hour of inactivity and it waits forever at the 3th line, if i call the > web service again, it works nice and it keeps on working nice (except > if I wait about an hour again). So, it could be what you say. > > Any URL where I can learn about the DBCP configuration and how to > set testOnBorroy to true?. > > MANY thanks for your help with this strange behaviour!!. > > > > 2007/11/29, Mark Thomas <[EMAIL PROTECTED]>: > > albert quinn wrote: > > > The lines 1 and 2 are executed, but the 4th line is never reached. > > > Any idea of what could be happening here or how could I do to discover > > > what's happening? does it seems to be a bug on my code or a setup > > > problem? > > > > Could you database connection be timing out due to inactivity? It is worth > > adding a validation query to your DBCP configuration and setting > > testOnBorrow to true. > > > > 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]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
All of a sudden I have gotten several emails concerning tomcat. All I wanted to do was to get to petedge. Jackie - Original Message - From: "albert quinn" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Thursday, November 29, 2007 4:26 PM Subject: Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool It could be. I'm really lost, and have no idea about what is happening. I forgot to tell that, when I call the web service after about an hour of inactivity and it waits forever at the 3th line, if i call the web service again, it works nice and it keeps on working nice (except if I wait about an hour again). So, it could be what you say. Any URL where I can learn about the DBCP configuration and how to set testOnBorroy to true?. MANY thanks for your help with this strange behaviour!!. 2007/11/29, Mark Thomas <[EMAIL PROTECTED]>: albert quinn wrote: > The lines 1 and 2 are executed, but the 4th line is never reached. > Any idea of what could be happening here or how could I do to discover > what's happening? does it seems to be a bug on my code or a setup > problem? Could you database connection be timing out due to inactivity? It is worth adding a validation query to your DBCP configuration and setting testOnBorrow to true. 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] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.10/1159 - Release Date: 11/29/2007 11:10 AM - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
I don't know why you are writing to me. I just wanted to get to petedge. Jackie J - Original Message - From: "Mark Thomas" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Thursday, November 29, 2007 3:54 PM Subject: Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool albert quinn wrote: The lines 1 and 2 are executed, but the 4th line is never reached. Any idea of what could be happening here or how could I do to discover what's happening? does it seems to be a bug on my code or a setup problem? Could you database connection be timing out due to inactivity? It is worth adding a validation query to your DBCP configuration and setting testOnBorrow to true. 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] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.10/1159 - Release Date: 11/29/2007 11:10 AM - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
It could be. I'm really lost, and have no idea about what is happening. I forgot to tell that, when I call the web service after about an hour of inactivity and it waits forever at the 3th line, if i call the web service again, it works nice and it keeps on working nice (except if I wait about an hour again). So, it could be what you say. Any URL where I can learn about the DBCP configuration and how to set testOnBorroy to true?. MANY thanks for your help with this strange behaviour!!. 2007/11/29, Mark Thomas <[EMAIL PROTECTED]>: > albert quinn wrote: > > The lines 1 and 2 are executed, but the 4th line is never reached. > > Any idea of what could be happening here or how could I do to discover > > what's happening? does it seems to be a bug on my code or a setup > > problem? > > Could you database connection be timing out due to inactivity? It is worth > adding a validation query to your DBCP configuration and setting > testOnBorrow to true. > > 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]
Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool
albert quinn wrote: > The lines 1 and 2 are executed, but the 4th line is never reached. > Any idea of what could be happening here or how could I do to discover > what's happening? does it seems to be a bug on my code or a setup > problem? Could you database connection be timing out due to inactivity? It is worth adding a validation query to your DBCP configuration and setting testOnBorrow to true. 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]