On Sat, 2009-07-25 at 17:26 -0400, Drew Jensen wrote: > Keith Clark wrote: > > 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 > > > > Ok - just making sure I was on the same page with you. > > Actually Query Browser times out also - unless you are using a localhost > database server, but I doub't that or we wouldn't be having this > discussion. (hmm, maybe I'm wrong on that - but it doesn't really matter) > > I think then the best way to help you is to look at how to handle the > lost connection so that you don't have to shut it all down and start it > all up again - heck, it would be nice if you didn't even know it happened. > > But that is not for tonight - sorry. For one thing it would be nice to > address this in a moe generalized way with a set of basic functions ( or > java perhaps) and then perhaps donate this to Roberto should he like to > add said functions to the Base Tools library he is distributing at the > extension site. In other words give it a little thought. > > But more importantly - I promised my 16 year old Nephew to take him and > a couple of his friends to the Demolition Derby tonight at the county > fair...just us guys...and need to head the door here pretty quickly. > > But I'll get into it with you tomorrow if you like....maybe we can find > others on the list with some ideas also. > > Drew
No problem Drew. I'll be around tomorrow to offer what I can. Now, go enjoy yourselves! Your help is always appreciated. Have fun this evening. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
