On Sat, 2009-07-25 at 17:09 -0400, Drew Jensen wrote: > Keith Clark wrote: > > 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. > > > > > Ok - well let me come at this a different way. > > Why is this a problem? What is it you want to happen or not happen, i.e > I should not have a new logon screen open just because the connection > was lost.
If I am using Base, and I leave to do something else for 10 minutes and come back to work some more, Base errors. I have to close down Base and start it back up again in order to use it. That is a very short time and a pain to stop and start again. I use MySQL Query Browser and no matter how long I leave it, for days even, I can just type a query and execute it. No reconnection required besides just the original one when I started the program. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
