Hi Keith, > I tried adding that and still disconnects after 10 minutes >
All that parameter does is tell the driver to attempt a reconnect if the connection drops. Depending on how you access your remmote mysql server, you can still be disconnected. I have the same problem with my ssh redirected mysql connection. I first thought that the ssh server disconnected me after a certain timeout, but apparently it is, in my case at least, a network reliability problem, i.e. the actual internet connection is not stable enough and the server detects that my connection has dropped and thus severs any further attempt until I manually reinitialise the connection. PITA, but unfortunately have no other solution. I also get at the OOo end a JDBC error message "the server has had no activity for the last X ms" where X is variable. Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
