Re: sweeping stale connections - Commons DBCP and Tomcat 4.1.9

2002-08-28 Thread Paul Phillips
Hello - I had this same problem, appending ?autoReconnect=true to your connect URL does work. I tried this -- parameter nameurl/name valuejdbc:mysql://localhost:3306/javatest?autoReconnect=true/value /parameter in my server.xml and it DOES work. Thanks to Glenn and

RE: sweeping stale connections - Commons DBCP and Tomcat 4.1.9

2002-08-27 Thread Jay Gardner
:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 10:04 PM To: Tomcat Users List Subject: sweeping stale connections - Commons DBCP and Tomcat 4.1.9 I'm using Tomcat 4.1.9. I have been having a problem with the DBCP jdbc connection pool when used with MySQL. Apparently MySQL kills off stale

RE: sweeping stale connections - Commons DBCP and Tomcat 4.1.9

2002-08-27 Thread Paul Phillips
Hello I would suggest trying either of the following: parameter nameautoReconnect/name valuetrue/value /parameter I know that the above does not work... I tried it. or parameter nameurl/name

Re: sweeping stale connections - Commons DBCP and Tomcat 4.1.9

2002-08-27 Thread Glenn Nielsen
I had this same problem, appending ?autoReconnect=true to your connect URL does work. Regards, Glenn Paul Phillips wrote: Hello I would suggest trying either of the following: parameter nameautoReconnect/name valuetrue/value /parameter I know that the above does

RE: sweeping stale connections - Commons DBCP and Tomcat 4.1.9

2002-08-27 Thread Mike Jackson
List Subject: sweeping stale connections - Commons DBCP and Tomcat 4.1.9 I'm using Tomcat 4.1.9. I have been having a problem with the DBCP jdbc connection pool when used with MySQL. Apparently MySQL kills off stale connections after an 8 hour period. According to Mark Matthews

sweeping stale connections - Commons DBCP and Tomcat 4.1.9

2002-08-26 Thread Paul Phillips
I'm using Tomcat 4.1.9. I have been having a problem with the DBCP jdbc connection pool when used with MySQL. Apparently MySQL kills off stale connections after an 8 hour period. According to Mark Matthews (developer of the jdbc-mysql driver), I need to configure the pool to sweep out the