Subject Re: [Firebird-Java] UTF-8 and tomcat
Author Mark Rotteveel
On 5-4-2014 19:55, Ray Holme wrote:
> The following ridiculous changes to our DB Resource allow us to actually
> do something for a short while - note that we used 10-20 time the times
> we used normally
> ... validationInterval="300000"
> timeBetweenEvictionRunsMillis="300000"
> minEvictableIdleTimeMillis="600000"
> removeAbandonedTimeout="600"
> I don't know if that helps define what is going on, but I guess
> somewhere somehow we are timing out connections.

removeAbandonedTimeout seems like the most obvious culprit. The
connections if forcefully revoked after the specified timeout (in
seconds): are there connections that are used for longer than 1 minute
(your previous config), or not closed after a request and reused at a
later point?

Although I am not sure how or why that would cause hangs without
exceptions, etc.

You can add logAbandoned="true" and logValidationErrors="true" to see if
anything suspicious jumps out in the logs (see
(+ Enhanced attributes)).

Mark Rotteveel