Re: again:dropped connection

The MySQL server closes idle connections after 8 hours of inactivity; it's
documented in the manual (look for the section titled 'How `mSQL' and
MySQL Client/Server Communications Protocols differ')

The mm.mysql driver, now part of the MySQL product (I think it's called
Connect/J) has an "autoReconnect=true" option that re-establishes the
connection to the database when this happens. I haven't found a way to
turn off the feature with the MySQL server, but the "ping-on-reuse"
init-param to resin's database pool could help. You could also try the
JDBC driver from MySQL AB - there's been some discussion about that on the
list and it's supposed to be *fast*.

Hope that helps

Hari

> 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.
>
Received on Mon 16 Sep 2002 03:09:46 -0700