Do you hold on to your connections in code or do you close them when done with each request? If you hold on to them, they can still timeout with or without a validationQuery set.
--David AD wrote: > unfortunately still not working. One thing that i noticed, when i > clear my browser cookies, everything works fine again. One of the > things we do is use cookie persistence to send a user to the same > tomcat server (we need this for file uploads,etc). Is there anything > in the session cookie that would cause this issue? > > Thanks > AD > > On Thu, Jul 2, 2009 at 9:38 AM, Christopher > Schultz<ch...@christopherschultz.net> wrote: > David, > > On 7/1/2009 5:01 PM, David Smith wrote: > >>> Christopher Schultz wrote: > >>>> David, > >>>> > >>>> On 7/1/2009 10:49 AM, David Smith wrote: > >>>>> It would and the performance hit is minimal if you use the ping > syntax > >>>>> in your validation query. I believe it looks like this: > >>>>> validationQuery="/* ping */ SELECT 1" > >>>> Note that both the PING is only applicable for MySQL when using > >>>> Connector/J, and "SELECT 1" may only be applicable on certain > databases > >>>> (MySQL being one of them). > >>>> > >>> Right and I double checked the original post that started this thread. > >>> AD described the environment as having MySQL 5.1 > Apologies... the thread was broken somewhere along the way and the > original message wasn't grouped with the others in my mail reader. The > OP definitely said they were using MySQL 5.1. > > -chris --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
