Bingo! That’ll be it:
http://www.mysql.com/documentation/mysq … #Gone_away
That says “By default, the server closes the connection after 8 hours if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld.”.
I’ll try that tomorrow and see how it goes.
Meanwhile, could Servoy handle this a little more graciously/constructively? Could Servoy be configured to “ping” the DB server (say every hour, but make the minutes configurable)?
Many thanks,
Neale.