Re: again:dropped connection

Well if you have written your own connection pool, you can in that one
make some subtle changes, when your application requests an connection
from the pool, check the "lastUsedTime" of the connection if it is older
then a certain time, disconnect it and make a new connection, reset the
"lastUsedTime" for the connection, insert the new connection in the
pool, and return the new connection...

/Christian Andersson

Ben Pezzei wrote:
> hello
>
> I am having problems with the caucho jdbc driver
> for mysql.
>
> It looks like that the driver returns an Exception "dropped
> connection" if there are no requests for about 8 hours (dont
> know the exact amount of idle-time).
>
> I am using a selfwritten Connection-Pool for my web-app (but i
> think to remember that this exception also occured with the
> caucho-pool).
>
> If I reload the page, everything's fine
>
> has anyone a solution for this problem? Google brought no
> usable results.
>
> any help/hint would be great
>
> greetings
> ben
>
Received on Mon 16 Sep 2002 01:24:18 -0700