Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-30 Thread albert quinn
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'

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-30 Thread albert quinn
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 r

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-30 Thread albert quinn
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

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread albert quinn
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 m

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread Mark Thomas
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 connectio

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread albert quinn
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 connec

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread Jackie Justice
e: [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

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread Jackie Justice
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 Proble

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread albert quinn
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

Re: [Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread Mark Thomas
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 inac

[Tomcat 5.5.17] Strange Problem With Batabase Connection Pool

2007-11-29 Thread albert quinn
Hi all ! : I'm facing a very strange problem. I'm developing a web service with : - Apache Axis 2 RC 1.3 running on Tomcat 5.5.17, running on Windows XP Professional - Java JDK 1.5 I've set up a database connection pool in Tomcat. My Web Service gets a connection from the pool, sen