tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: DBCP and Firewall timeouts
Date Tue, 07 Jul 2009 16:20:19 GMT
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<chris@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message