Re: Socket Server with MySQL

RVic wrote:
> I have a Java socket server that uses MySQL (5.0.27-community) as its
> backend. I've noticed if the server sits idle for a lengthy period of
> time (I have duplicated the results to generate a stack trace by not
> making a socket connection for 48 hours) it faults out with the stack
> trace listed below. I believe it is likely a mysql configuration
> problem and/or a java ServerSocket or Socket issue.

From the practical perspective then I think that:
* if you do not use a connection pool, then you should
send a SELECT 1 every hour to keep things alive
* if you do use a connection pool, then you should
use one capable of verifying connections and return
a valid to you (and if your connection pool does not
provide that, then find one that does)

Arne