On Sat, 2009-07-25 at 16:49 -0400, Drew Jensen wrote: > Keith Clark wrote: > > On Sat, 2009-07-25 at 19:39 +0200, Alex Thurgood wrote: > > > >> 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. > >> > >> > > > > I don't think my problem is connectivity. Same error, but I've tried it > > on two different installations with two completely different internet > > connections. One is cable the other phone company. > > > > One thing for sure after doing a little research for you - you guys are > not alone with this problem. > > Anyway - and this is just something that seemed to come up a fair bit in > my readings: > Have you tried using the actual IP address to the server in your > connection settings and not a DNS name?
Yes, I always use the IP and not the DNS name. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
